eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.FIIBV_PA_COST_F_FCV

Source

View Text - Preformatted


SELECT NULL SEQ_ID, to_char( cdl.expenditure_item_id ) || '-' || to_char( cdl.line_num ) || '-' || i.instance_code COST_PK, null RAW_COST_G, cdl.ACCT_RAW_COST RAW_COST_B, cdl.DENOM_RAW_COST RAW_COST_T, null BURDENED_COST_G, cdl.ACCT_BURDENED_COST BURDENED_COST_B, cdl.DENOM_BURDENED_COST BURDENED_COST_T, cdl.QUANTITY QUANTITY, cdl.billable_flag BILLABLE_FLAG, i.instance_code INSTANCE_FK, sob.set_of_books_id || '-' || i.instance_code SET_OF_BOOKS_FK, ei.task_id || '-' || i.instance_code PROJECT_FK, to_char( null ) PROJECT_ORG_FK, decode( NVL(ei.override_to_organization_id, pe.incurred_by_organization_id), NULL, 'NA_EDW', NVL(ei.override_to_organization_id, pe.incurred_by_organization_id) || '-' || i.instance_code) EXPENDITURE_ORG_FK, et.expenditure_type || '-' || i.instance_code EXPENDITURE_TYPE_FK, nvl(ei.acct_currency_code,'NA_EDW') CURRENCY_GL_FK, nvl(ei.denom_currency_code,'NA_EDW') CURRENCY_TRX_FK, decode(pe.incurred_by_person_id, NULL, 'NA_EDW', pe.incurred_by_person_id || '-' || i.instance_code || '-' || 'EMPLOYEE-PERS') EMPLOYEE_FK, edw_util.get_edw_uom( 'PA-' || et.unit_of_measure, null) UNIT_OF_MEASURE_FK, decode( ei.expenditure_item_date, NULL, 'NA_EDW', to_char(ei.expenditure_item_date,'dd-mm-yyyy') || '-' || sob.period_set_name || '-' || pi.pa_period_type || '-' || i.instance_code || '-PD' ) TRANSACTION_DATE_FK, decode( cdl.pa_date, NULL, 'NA_EDW', to_char(cdl.pa_date, 'dd-mm-yyyy') || '-' || sob.period_set_name || '-' || pi.pa_period_type || '-' || i.instance_code || '-PD' ) PA_DATE_FK, decode( cdl.gl_date, NULL, 'NA_EDW', to_char(cdl.gl_date, 'dd-mm-yyyy') || '-' || sob.period_set_name || '-' || sob.accounted_period_type || '-' || i.instance_code || '-CD' ) GL_DATE_FK, 'NA_EDW' GL_ACCT1_FK, 'NA_EDW' GL_ACCT2_FK, 'NA_EDW' GL_ACCT3_FK, 'NA_EDW' GL_ACCT4_FK, 'NA_EDW' GL_ACCT5_FK, 'NA_EDW' GL_ACCT6_FK, 'NA_EDW' GL_ACCT7_FK, 'NA_EDW' GL_ACCT8_FK, 'NA_EDW' GL_ACCT9_FK, 'NA_EDW' GL_ACCT10_FK, sob.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, sob.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, cdl.dr_code_combination_id CODE_COMBINATION_ID, nvl( edw_currency.get_rate ( cdl.ACCT_CURRENCY_CODE, ei.expenditure_item_date, null ), -1) GLOBAL_CURRENCY_RATE, cdl.PROGRAM_UPDATE_DATE LAST_UPDATE_DATE, '_DF:PA:PA_EXPENDITURE_ITEMS_DESC_FLEX:ei' , '_DF:PA:PA_EXPENDITURES_DESC_FLEX:pe', '_DF:PA:PA_EXPENDITURE_TYPES_DESC_FLEX:et', '_DF:PA:PA_TASKS_DESC_FLEX:t', '_DF:SQLGL:GL_SETS_OF_BOOKS:sob', '_KF:SQLGL:GL#:gcc' ,cdl.ACCT_CURRENCY_CODE FROM_CURRENCY, ei.expenditure_item_date TRANSACTION_DATE FROM fii_pa_cost_pk fiipk, pa_cost_distribution_lines_all cdl, pa_expenditure_items_all ei, pa_expenditures_all pe, pa_expenditure_types et, pa_tasks t, pa_implementations_all pi, gl_sets_of_books sob, edw_local_instance i, gl_code_combinations gcc WHERE cdl.expenditure_item_id = fiipk.primary_key1 AND cdl.line_num = fiipk.primary_key2 AND cdl.line_type = 'R' AND cdl.expenditure_item_id = ei.expenditure_item_id AND ei.expenditure_type = et.expenditure_type AND ei.task_id = t.task_id AND pe.expenditure_id = ei.expenditure_id AND NVL(cdl.org_id,-99) = NVL(pi.org_id,-99) AND sob.set_of_books_id = pi.set_of_books_id AND gcc.code_combination_id = cdl.dr_code_combination_id

View Text - HTML Formatted

SELECT NULL SEQ_ID
, TO_CHAR( CDL.EXPENDITURE_ITEM_ID ) || '-' || TO_CHAR( CDL.LINE_NUM ) || '-' || I.INSTANCE_CODE COST_PK
, NULL RAW_COST_G
, CDL.ACCT_RAW_COST RAW_COST_B
, CDL.DENOM_RAW_COST RAW_COST_T
, NULL BURDENED_COST_G
, CDL.ACCT_BURDENED_COST BURDENED_COST_B
, CDL.DENOM_BURDENED_COST BURDENED_COST_T
, CDL.QUANTITY QUANTITY
, CDL.BILLABLE_FLAG BILLABLE_FLAG
, I.INSTANCE_CODE INSTANCE_FK
, SOB.SET_OF_BOOKS_ID || '-' || I.INSTANCE_CODE SET_OF_BOOKS_FK
, EI.TASK_ID || '-' || I.INSTANCE_CODE PROJECT_FK
, TO_CHAR( NULL ) PROJECT_ORG_FK
, DECODE( NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, PE.INCURRED_BY_ORGANIZATION_ID)
, NULL
, 'NA_EDW'
, NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, PE.INCURRED_BY_ORGANIZATION_ID) || '-' || I.INSTANCE_CODE) EXPENDITURE_ORG_FK
, ET.EXPENDITURE_TYPE || '-' || I.INSTANCE_CODE EXPENDITURE_TYPE_FK
, NVL(EI.ACCT_CURRENCY_CODE
, 'NA_EDW') CURRENCY_GL_FK
, NVL(EI.DENOM_CURRENCY_CODE
, 'NA_EDW') CURRENCY_TRX_FK
, DECODE(PE.INCURRED_BY_PERSON_ID
, NULL
, 'NA_EDW'
, PE.INCURRED_BY_PERSON_ID || '-' || I.INSTANCE_CODE || '-' || 'EMPLOYEE-PERS') EMPLOYEE_FK
, EDW_UTIL.GET_EDW_UOM( 'PA-' || ET.UNIT_OF_MEASURE
, NULL) UNIT_OF_MEASURE_FK
, DECODE( EI.EXPENDITURE_ITEM_DATE
, NULL
, 'NA_EDW'
, TO_CHAR(EI.EXPENDITURE_ITEM_DATE
, 'DD-MM-YYYY') || '-' || SOB.PERIOD_SET_NAME || '-' || PI.PA_PERIOD_TYPE || '-' || I.INSTANCE_CODE || '-PD' ) TRANSACTION_DATE_FK
, DECODE( CDL.PA_DATE
, NULL
, 'NA_EDW'
, TO_CHAR(CDL.PA_DATE
, 'DD-MM-YYYY') || '-' || SOB.PERIOD_SET_NAME || '-' || PI.PA_PERIOD_TYPE || '-' || I.INSTANCE_CODE || '-PD' ) PA_DATE_FK
, DECODE( CDL.GL_DATE
, NULL
, 'NA_EDW'
, TO_CHAR(CDL.GL_DATE
, 'DD-MM-YYYY') || '-' || SOB.PERIOD_SET_NAME || '-' || SOB.ACCOUNTED_PERIOD_TYPE || '-' || I.INSTANCE_CODE || '-CD' ) GL_DATE_FK
, 'NA_EDW' GL_ACCT1_FK
, 'NA_EDW' GL_ACCT2_FK
, 'NA_EDW' GL_ACCT3_FK
, 'NA_EDW' GL_ACCT4_FK
, 'NA_EDW' GL_ACCT5_FK
, 'NA_EDW' GL_ACCT6_FK
, 'NA_EDW' GL_ACCT7_FK
, 'NA_EDW' GL_ACCT8_FK
, 'NA_EDW' GL_ACCT9_FK
, 'NA_EDW' GL_ACCT10_FK
, SOB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SOB.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, CDL.DR_CODE_COMBINATION_ID CODE_COMBINATION_ID
, NVL( EDW_CURRENCY.GET_RATE ( CDL.ACCT_CURRENCY_CODE
, EI.EXPENDITURE_ITEM_DATE
, NULL )
, -1) GLOBAL_CURRENCY_RATE
, CDL.PROGRAM_UPDATE_DATE LAST_UPDATE_DATE
, '_DF:PA:PA_EXPENDITURE_ITEMS_DESC_FLEX:EI'
, '_DF:PA:PA_EXPENDITURES_DESC_FLEX:PE'
, '_DF:PA:PA_EXPENDITURE_TYPES_DESC_FLEX:ET'
, '_DF:PA:PA_TASKS_DESC_FLEX:T'
, '_DF:SQLGL:GL_SETS_OF_BOOKS:SOB'
, '_KF:SQLGL:GL#:GCC'
, CDL.ACCT_CURRENCY_CODE FROM_CURRENCY
, EI.EXPENDITURE_ITEM_DATE TRANSACTION_DATE
FROM FII_PA_COST_PK FIIPK
, PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL PE
, PA_EXPENDITURE_TYPES ET
, PA_TASKS T
, PA_IMPLEMENTATIONS_ALL PI
, GL_SETS_OF_BOOKS SOB
, EDW_LOCAL_INSTANCE I
, GL_CODE_COMBINATIONS GCC
WHERE CDL.EXPENDITURE_ITEM_ID = FIIPK.PRIMARY_KEY1
AND CDL.LINE_NUM = FIIPK.PRIMARY_KEY2
AND CDL.LINE_TYPE = 'R'
AND CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND EI.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND EI.TASK_ID = T.TASK_ID
AND PE.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND NVL(CDL.ORG_ID
, -99) = NVL(PI.ORG_ID
, -99)
AND SOB.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID
AND GCC.CODE_COMBINATION_ID = CDL.DR_CODE_COMBINATION_ID