View: FIIBV_PA_COST_F_FCV

View Text

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

Columns