My Portfolio

SELECT PEI.VENDOR_ID, ASP.SEGMENT1 VENDOR_NO, ASP.VENDOR_NAME, PEV.PROJECT_NUMBER,PEV.PROJECT_NAME ,PCE.PROJECT_ID, PEV.TASK_NUMBER,PEV.TASK_NAME, PEV.PROJECT_TYPE, PEV.EMPLOYEE_NAME, PEV.EXPENDITURE_ITEM_DATE, PEV.EXPENDITURE_TYPE, PEV.EXPENDITURE_CATEGORY, PEV.EXPENDITURE_COMMENT, PEV.TRANSACTION_SOURCE, PEV.EXPENDITURE_GROUP, PEV.EXPENDITURE_STATUS_CODE, PEV.COST_DISTRIBUTED_FLAG, PEV.TRANSFERRED_FROM_EXP_ITEM_ID, PEV.TRANSFERRED_ITEM_FLAG, PEV.LAST_UPDATE_DATE, PEV.LAST_UPDATE_DATE, PEV.ALLOW_ADJUSTMENTS_FLAG, PEV.COSTED_FLAG, PEV.COST_BURDENED_FLAG, PEV.GL_ACCOUNTED_FLAG, PEV.USER_TRANSACTION_SOURCE, PEV.ORIG_EXP_TXN_REFERENCE1, PEV.ORIG_USER_EXP_TXN_REFERENCE, PEV.ORIG_EXP_TXN_REFERENCE2, PEV.LATEST_PA_DATE, PEV.LATEST_GL_DATE, PEV.DOCUMENT_HEADER_ID, PEV.DOCUMENT_DISTRIBUTION_ID, PEV.DOCUMENT_TYPE, PCE.DR_CODE_COMBINATION_ID, (select CONCATENATED_SEGMENTS from GL_CODE_COMBINATIONS_KFV where CODE_COMBINATION_ID=PCE.DR_CODE_COMBINATION_ID) Debit_ACCOUNT, PCE.CR_CODE_COMBINATION_ID...

 Oracle Functional GL 1. HOW MANY KEY FLEXFIELDS ARE THERE IN ORACLE FINANCIALS? ·         General Ledger o   Accounting Flexfield ·         Assets o   Asset Key Flexfield o   Location Flexfield o   Category Flexfield ·         Service o   Service Item Flexfield ·         Receivables o   Territory Flexfield o   Sales Tax Location Flexfield ·         Inventory o   Item Categories o   System Items o   Sales Orders o   Item Catalogs 2. WHAT ARE THE BENEFITS OF FLEXFIELDS? - Configure applications to support your own accounting, product and other codes. - Enable the construction of intelligent keys. - C...