VIEW: APPS.PA_XLA_CDL_LINES_V

Source

View Text - Preformatted

SELECT cdl.Acct_Event_Id , cdl.Expenditure_Item_Id , cdl.Line_Num , imp.Set_Of_Books_Id , DECODE(NVL(CDL.Acct_Source_Code, 'UPG') , 'UPG', DECODE (cdl.line_type, 'R', 'Y' ,'N') , 'PA', DECODE(CDL.Line_Num_Reversed, NULL, 'N', 'Y') , 'N') , TO_NUMBER (DECODE(NVL(CDL.Acct_Source_Code, 'UPG'), 'PA', DECODE(CDL.Line_Num_Reversed, NULL, NULL, CDL.Line_Num_Reversed), NULL) ), cdl.Line_Type , cdl.Denom_Currency_Code , DECODE(cdl.Line_Type, 'C', -1 * cdl.Denom_Raw_Cost, cdl.Denom_Raw_Cost), DECODE(cdl.Line_Type, 'C', -1 * cdl.Denom_Raw_Cost, 'D', cdl.Denom_Raw_Cost, cdl.Denom_Burdened_Cost), DECODE(cdl.line_type, 'C', -1 * cdl.Acct_raw_cost , cdl.Acct_raw_cost), DECODE(cdl.line_type, 'C', -1 * cdl.Acct_raw_cost, 'D', cdl.acct_raw_cost, cdl.Acct_burdened_cost), cdl.acct_exchange_rate , cdl.Acct_Rate_type , cdl.Acct_Rate_date , cdl.Dr_Code_Combination_id , DECODE(ei.System_Linkage_Function , 'VI', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , 'ER', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , cdl.Cr_Code_Combination_id) , DECODE( NVL(cdl.Acct_Source_Code, 'UPG') , 'UPG', DECODE ( cdl.line_type, 'R', DECODE (ei.Adjusted_Expenditure_Item_Id, NULL, 'Y','N') , 'N') , 'EXT', 'N' , 'PA', DECODE(cdl.Parent_Line_Num, NULL, 'Y', 'N') , 'N') allow_override_ccid_flag, DECODE(NVL(cdl.Acct_Source_Code, 'UPG') , 'UPG', cdl.Dr_Code_Combination_Id , 'EXT', cdl.Dr_Code_Combination_Id , 'PA', DECODE( NVL(cdl.Line_Num_Reversed, cdl.Parent_Line_Num), NULL, cdl.Dr_Code_Combination_Id , DECODE(cdl.Parent_Line_Num, NULL, cdl.Dr_Code_Combination_Id , PA_XLA_INTERFACE_PKG.Get_Sla_Ccid( 275 ,ei.Adjusted_Expenditure_Item_Id ,cdl.Parent_Line_Num ,cdl.Line_Type ,'DEBIT' ,imp.Set_Of_Books_Id ) ) ) , PA_XLA_INTERFACE_PKG.Get_Sla_Ccid( DECODE( cdl.Acct_Source_Code ,'AP_INV', 200 ,'AP_PAY', 200 ,'AP_APP', 200 ,'INV', 707 ,'WIP', 707 ,'RCV', 707 ,NULL ) ,DECODE( cdl.Acct_Source_Code ,'AP_INV', ei.Document_Distribution_Id ,'AP_PAY', cdl.system_reference5 ,'AP_APP', cdl.system_reference5 ,'INV', cdl.System_Reference5 ,'WIP', cdl.System_Reference5 ,'RCV', cdl.System_Reference5 ,NULL ) ,NULL ,DECODE (cdl.acct_source_code ,'AP_PAY','AP_PMT_DIST' ,'AP_INV','AP_INV_DIST' ,'AP_APP','AP_PREPAY' ,'RCV','RCV_RECEIVING_SUB_LEDGER' ,'INV','MTL_TRANSACTION_ACCOUNTS' ,'WIP','WIP_TRANSACTION_ACCOUNTS' ,cdl.line_type ) ,'DEBIT' ,imp.Set_Of_Books_Id ) ) adj_cost_ccid, DECODE(NVL(cdl.Acct_Source_Code, 'UPG') , 'UPG', DECODE(ei.System_Linkage_Function , 'VI', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , 'ER', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , cdl.Cr_Code_Combination_id) , 'EXT', DECODE(ei.System_Linkage_Function , 'VI', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , 'ER', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , cdl.Cr_Code_Combination_id) , 'RCV', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , 'AP_INV', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , 'AP_PAY', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , 'AP_APP', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , 'PA', DECODE( NVL(cdl.Line_Num_Reversed, cdl.Parent_Line_Num), NULL, DECODE(ei.System_Linkage_Function , 'VI' , NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , 'ER' , NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , cdl.Cr_Code_Combination_id) , DECODE(cdl.Parent_Line_Num, NULL, DECODE(ei.System_Linkage_Function , 'VI', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , 'ER', NVL(cdl.Cr_Code_Combination_id, imp.Def_Supplier_Cost_Cr_Ccid) , cdl.Cr_Code_Combination_id) , PA_XLA_INTERFACE_PKG.Get_Sla_Ccid( 275 ,ei.Adjusted_Expenditure_Item_Id ,cdl.Parent_Line_Num ,cdl.Line_Type ,'CREDIT' ,imp.Set_Of_Books_Id ) ) ) , PA_XLA_INTERFACE_PKG.Get_Sla_Ccid( DECODE( NVL(cdl.Acct_Source_Code, 'UPG') ,'INV', 707 ,'WIP', 707 ,NULL ) ,DECODE( NVL(cdl.Acct_Source_Code, 'UPG') ,'INV', cdl.System_Reference4 ,'WIP', cdl.System_Reference4 ,NULL ) ,NULL ,DECODE (cdl.acct_source_code ,'RCV','RCV_RECEIVING_SUB_LEDGER' ,'INV','MTL_TRANSACTION_ACCOUNTS' ,'WIP','WIP_TRANSACTION_ACCOUNTS' ,cdl.line_type ) ,'CREDIT' ,imp.Set_Of_Books_Id ) ) adj_cost_clearing_ccid, cdl.Project_Id , cdl.Task_Id , cdl.Work_Type_Id , cdl.Billable_Flag ,DECODE(NVL(cdl.Acct_Source_Code, 'UPG'), 'UPG', DECODE ( cdl.line_type, 'R', 'Y', 'N') , 'N') ,'COST' ,'COST_CLEARING' ,cdl.budget_ccid ,(SELECT DECODE(pbl.bc_event_id,NULL,'Y','N') FROM pa_budget_lines pbl WHERE pbl.budget_line_id = cdl.budget_line_id) ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,275 ,'PA_BUDGET_ENC' ,'BUDGETS' ,cdl.budget_line_id ,cdl.budget_version_id ,NULL ,NULL ,pa_funds_control_utils.get_bdgt_link(cdl.project_id, 'STD') ,cdl.encumbrance_amount ,PA_FUNDS_CONTROL_UTILS.get_encum_type_id(cdl.Project_Id,'STD') ,PA_FUNDS_CONTROL_UTILS.get_encum_type_id(cdl.Project_Id,'STD') ,NULL ,decode(nvl(ei.po_line_id, -99), -99, 'N', 'Y') ,cdl.liquidate_encum_flag ,'N' FROM PA_Expenditure_Items_All ei , PA_Cost_Distribution_Lines_All cdl , PA_Implementations_All imp WHERE ei.Expenditure_Item_Id = cdl.Expenditure_Item_Id AND imp.Org_Id = cdl.Org_Id UNION ALL SELECT bccom.bc_Event_Id , bccom.Exp_Item_Id , bccom.bc_commitment_id , bccom.Set_Of_Books_Id , 'N' , NULL, 'E', ei.acct_currency_code, NULL, NULL, NULL , NULL, NULL, NULL , NULL , NULL , NULL, 'N', NULL, NULL, bccom.Project_Id , bccom.Task_Id , NULL , NULL ,NULL ,NULL ,NULL ,bccom.budget_ccid , PA_FUNDS_CONTROL_UTILS.get_sla_notupgraded_flag( DECODE(bccom.document_type,'AP',200,'PO',201) ,DECODE(bccom.document_type ,'AP','AP_INVOICES' ,'PO',decode(bccom.document_distribution_type ,'SCHEDULED','RELEASE' ,'BLANKET','RELEASE' ,'PURCHASE_ORDER')) ,DECODE(bccom.document_type ,'AP',bccom.document_header_id ,'PO', decode(bccom.document_distribution_type ,'SCHEDULED',bccom.document_header_id_2 ,'BLANKET',bccom.document_header_id_2 ,bccom.document_header_id)) ,bccom.document_distribution_id ,DECODE(bccom.document_type,'AP','AP_INV_DIST' ,'PO','PO_DISTRIBUTIONS_ALL') ,bccom.budget_version_id ,bccom.budget_line_id) ,decode(bccom.document_Type, 'AP', (decode(bccom.burden_method_code, 'S', 'PA_AP_INV_BURDENED', 'D', 'PA_AP_INV_BURDEN', NULL)) , 'PO', (decode(bccom.burden_method_code, 'S', 'PA_PO_BURDENED', 'D', 'PA_PO_BURDEN', NULL)) , NULL) ,NULL ,decode(bccom.document_type, 'AP', 200, NULL) ,decode(bccom.document_type, 'AP', 'PA_AP_BURDEN', NULL) ,decode(bccom.document_type, 'AP', 'AP_INVOICES', NULL) ,decode(bccom.document_type, 'AP', bccom.document_distribution_id, NULL) ,decode(bccom.document_type, 'AP', bccom.expenditure_type, NULL) ,decode(bccom.document_type, 'AP', bccom.document_header_id, NULL) ,decode(bccom.document_type, 'PO', 201, NULL) ,decode(bccom.document_type, 'PO', 'PA_PO_BURDEN', NULL) ,decode(bccom.document_type, 'PO', decode(bccom.document_distribution_type ,'SCHEDULED','RELEASE' ,'BLANKET','RELEASE' ,'PURCHASE_ORDER') , NULL) ,decode(bccom.document_type, 'PO', bccom.document_distribution_id, NULL) ,decode(bccom.document_type, 'PO', bccom.expenditure_type, NULL) ,decode(bccom.document_type, 'PO', decode(bccom.document_distribution_type ,'SCHEDULED',bccom.document_header_id_2 ,'BLANKET',bccom.document_header_id_2 ,bccom.document_header_id) , NULL) ,275 ,'PA_BUDGET_ENC' ,'BUDGETS' ,bccom.budget_line_id ,bccom.budget_version_id ,NULL ,bccom.document_type ,pa_funds_control_utils.get_bdgt_link(ei.project_id, 'STD') ,(-1*(nvl(bccom.accounted_Dr,0)-nvl(bccom.accounted_cr,0))) ,(SELECT enct.encumbrance_type_id FROM gl_encumbrance_types enct WHERE enct.encumbrance_type_KEY = DECODE(bccom.document_type,'PO','Obligation','Invoices')) ,PA_FUNDS_CONTROL_UTILS.get_encum_type_id(bccom.Project_Id,'STD') ,decode(bccom.document_type, 'PO', decode(bccom.document_distribution_type ,'SCHEDULED',bccom.document_header_id_2 ,'BLANKET',bccom.document_header_id_2 ,NULL) , NULL) ,decode(nvl(ei.po_line_id, -99), -99, 'N', 'Y') ,NULL ,DECODE(bccom.document_type ,'AP', PA_FUNDS_CONTROL_UTILS.get_ap_sla_reversed_status(bccom.document_header_id,bccom.document_distribution_id) ,'N') FROM PA_Expenditure_Items_All ei , PA_bc_commitments_all bccom WHERE ei.Expenditure_Item_Id = bccom.Exp_Item_Id

View Text - HTML Formatted

SELECT CDL.ACCT_EVENT_ID
, CDL.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, IMP.SET_OF_BOOKS_ID
, DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, DECODE (CDL.LINE_TYPE
, 'R'
, 'Y'
, 'N')
, 'PA'
, DECODE(CDL.LINE_NUM_REVERSED
, NULL
, 'N'
, 'Y')
, 'N')
, TO_NUMBER (DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'PA'
, DECODE(CDL.LINE_NUM_REVERSED
, NULL
, NULL
, CDL.LINE_NUM_REVERSED)
, NULL) )
, CDL.LINE_TYPE
, CDL.DENOM_CURRENCY_CODE
, DECODE(CDL.LINE_TYPE
, 'C'
, -1 * CDL.DENOM_RAW_COST
, CDL.DENOM_RAW_COST)
, DECODE(CDL.LINE_TYPE
, 'C'
, -1 * CDL.DENOM_RAW_COST
, 'D'
, CDL.DENOM_RAW_COST
, CDL.DENOM_BURDENED_COST)
, DECODE(CDL.LINE_TYPE
, 'C'
, -1 * CDL.ACCT_RAW_COST
, CDL.ACCT_RAW_COST)
, DECODE(CDL.LINE_TYPE
, 'C'
, -1 * CDL.ACCT_RAW_COST
, 'D'
, CDL.ACCT_RAW_COST
, CDL.ACCT_BURDENED_COST)
, CDL.ACCT_EXCHANGE_RATE
, CDL.ACCT_RATE_TYPE
, CDL.ACCT_RATE_DATE
, CDL.DR_CODE_COMBINATION_ID
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, DECODE( NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, DECODE ( CDL.LINE_TYPE
, 'R'
, DECODE (EI.ADJUSTED_EXPENDITURE_ITEM_ID
, NULL
, 'Y'
, 'N')
, 'N')
, 'EXT'
, 'N'
, 'PA'
, DECODE(CDL.PARENT_LINE_NUM
, NULL
, 'Y'
, 'N')
, 'N') ALLOW_OVERRIDE_CCID_FLAG
, DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, CDL.DR_CODE_COMBINATION_ID
, 'EXT'
, CDL.DR_CODE_COMBINATION_ID
, 'PA'
, DECODE( NVL(CDL.LINE_NUM_REVERSED
, CDL.PARENT_LINE_NUM)
, NULL
, CDL.DR_CODE_COMBINATION_ID
, DECODE(CDL.PARENT_LINE_NUM
, NULL
, CDL.DR_CODE_COMBINATION_ID
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID( 275
, EI.ADJUSTED_EXPENDITURE_ITEM_ID
, CDL.PARENT_LINE_NUM
, CDL.LINE_TYPE
, 'DEBIT'
, IMP.SET_OF_BOOKS_ID ) ) )
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID( DECODE( CDL.ACCT_SOURCE_CODE
, 'AP_INV'
, 200
, 'AP_PAY'
, 200
, 'AP_APP'
, 200
, 'INV'
, 707
, 'WIP'
, 707
, 'RCV'
, 707
, NULL )
, DECODE( CDL.ACCT_SOURCE_CODE
, 'AP_INV'
, EI.DOCUMENT_DISTRIBUTION_ID
, 'AP_PAY'
, CDL.SYSTEM_REFERENCE5
, 'AP_APP'
, CDL.SYSTEM_REFERENCE5
, 'INV'
, CDL.SYSTEM_REFERENCE5
, 'WIP'
, CDL.SYSTEM_REFERENCE5
, 'RCV'
, CDL.SYSTEM_REFERENCE5
, NULL )
, NULL
, DECODE (CDL.ACCT_SOURCE_CODE
, 'AP_PAY'
, 'AP_PMT_DIST'
, 'AP_INV'
, 'AP_INV_DIST'
, 'AP_APP'
, 'AP_PREPAY'
, 'RCV'
, 'RCV_RECEIVING_SUB_LEDGER'
, 'INV'
, 'MTL_TRANSACTION_ACCOUNTS'
, 'WIP'
, 'WIP_TRANSACTION_ACCOUNTS'
, CDL.LINE_TYPE )
, 'DEBIT'
, IMP.SET_OF_BOOKS_ID ) ) ADJ_COST_CCID
, DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, 'EXT'
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, 'RCV'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'AP_INV'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'AP_PAY'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'AP_APP'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'PA'
, DECODE( NVL(CDL.LINE_NUM_REVERSED
, CDL.PARENT_LINE_NUM)
, NULL
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, DECODE(CDL.PARENT_LINE_NUM
, NULL
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID( 275
, EI.ADJUSTED_EXPENDITURE_ITEM_ID
, CDL.PARENT_LINE_NUM
, CDL.LINE_TYPE
, 'CREDIT'
, IMP.SET_OF_BOOKS_ID ) ) )
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID( DECODE( NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'INV'
, 707
, 'WIP'
, 707
, NULL )
, DECODE( NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'INV'
, CDL.SYSTEM_REFERENCE4
, 'WIP'
, CDL.SYSTEM_REFERENCE4
, NULL )
, NULL
, DECODE (CDL.ACCT_SOURCE_CODE
, 'RCV'
, 'RCV_RECEIVING_SUB_LEDGER'
, 'INV'
, 'MTL_TRANSACTION_ACCOUNTS'
, 'WIP'
, 'WIP_TRANSACTION_ACCOUNTS'
, CDL.LINE_TYPE )
, 'CREDIT'
, IMP.SET_OF_BOOKS_ID ) ) ADJ_COST_CLEARING_CCID
, CDL.PROJECT_ID
, CDL.TASK_ID
, CDL.WORK_TYPE_ID
, CDL.BILLABLE_FLAG
, DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, DECODE ( CDL.LINE_TYPE
, 'R'
, 'Y'
, 'N')
, 'N')
, 'COST'
, 'COST_CLEARING'
, CDL.BUDGET_CCID
, (SELECT DECODE(PBL.BC_EVENT_ID
, NULL
, 'Y'
, 'N')
FROM PA_BUDGET_LINES PBL
WHERE PBL.BUDGET_LINE_ID = CDL.BUDGET_LINE_ID)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 275
, 'PA_BUDGET_ENC'
, 'BUDGETS'
, CDL.BUDGET_LINE_ID
, CDL.BUDGET_VERSION_ID
, NULL
, NULL
, PA_FUNDS_CONTROL_UTILS.GET_BDGT_LINK(CDL.PROJECT_ID
, 'STD')
, CDL.ENCUMBRANCE_AMOUNT
, PA_FUNDS_CONTROL_UTILS.GET_ENCUM_TYPE_ID(CDL.PROJECT_ID
, 'STD')
, PA_FUNDS_CONTROL_UTILS.GET_ENCUM_TYPE_ID(CDL.PROJECT_ID
, 'STD')
, NULL
, DECODE(NVL(EI.PO_LINE_ID
, -99)
, -99
, 'N'
, 'Y')
, CDL.LIQUIDATE_ENCUM_FLAG
, 'N'
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_IMPLEMENTATIONS_ALL IMP
WHERE EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND IMP.ORG_ID = CDL.ORG_ID UNION ALL SELECT BCCOM.BC_EVENT_ID
, BCCOM.EXP_ITEM_ID
, BCCOM.BC_COMMITMENT_ID
, BCCOM.SET_OF_BOOKS_ID
, 'N'
, NULL
, 'E'
, EI.ACCT_CURRENCY_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, NULL
, NULL
, BCCOM.PROJECT_ID
, BCCOM.TASK_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, BCCOM.BUDGET_CCID
, PA_FUNDS_CONTROL_UTILS.GET_SLA_NOTUPGRADED_FLAG( DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 200
, 'PO'
, 201)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 'AP_INVOICES'
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, 'RELEASE'
, 'BLANKET'
, 'RELEASE'
, 'PURCHASE_ORDER'))
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, BCCOM.DOCUMENT_HEADER_ID
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, BCCOM.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, BCCOM.DOCUMENT_HEADER_ID_2
, BCCOM.DOCUMENT_HEADER_ID))
, BCCOM.DOCUMENT_DISTRIBUTION_ID
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 'AP_INV_DIST'
, 'PO'
, 'PO_DISTRIBUTIONS_ALL')
, BCCOM.BUDGET_VERSION_ID
, BCCOM.BUDGET_LINE_ID)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, (DECODE(BCCOM.BURDEN_METHOD_CODE
, 'S'
, 'PA_AP_INV_BURDENED'
, 'D'
, 'PA_AP_INV_BURDEN'
, NULL))
, 'PO'
, (DECODE(BCCOM.BURDEN_METHOD_CODE
, 'S'
, 'PA_PO_BURDENED'
, 'D'
, 'PA_PO_BURDEN'
, NULL))
, NULL)
, NULL
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 200
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 'PA_AP_BURDEN'
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 'AP_INVOICES'
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, BCCOM.DOCUMENT_DISTRIBUTION_ID
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, BCCOM.EXPENDITURE_TYPE
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, BCCOM.DOCUMENT_HEADER_ID
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, 201
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, 'PA_PO_BURDEN'
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, 'RELEASE'
, 'BLANKET'
, 'RELEASE'
, 'PURCHASE_ORDER')
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, BCCOM.DOCUMENT_DISTRIBUTION_ID
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, BCCOM.EXPENDITURE_TYPE
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, BCCOM.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, BCCOM.DOCUMENT_HEADER_ID_2
, BCCOM.DOCUMENT_HEADER_ID)
, NULL)
, 275
, 'PA_BUDGET_ENC'
, 'BUDGETS'
, BCCOM.BUDGET_LINE_ID
, BCCOM.BUDGET_VERSION_ID
, NULL
, BCCOM.DOCUMENT_TYPE
, PA_FUNDS_CONTROL_UTILS.GET_BDGT_LINK(EI.PROJECT_ID
, 'STD')
, (-1*(NVL(BCCOM.ACCOUNTED_DR
, 0)-NVL(BCCOM.ACCOUNTED_CR
, 0)))
, (SELECT ENCT.ENCUMBRANCE_TYPE_ID
FROM GL_ENCUMBRANCE_TYPES ENCT
WHERE ENCT.ENCUMBRANCE_TYPE_KEY = DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, 'OBLIGATION'
, 'INVOICES'))
, PA_FUNDS_CONTROL_UTILS.GET_ENCUM_TYPE_ID(BCCOM.PROJECT_ID
, 'STD')
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, BCCOM.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, BCCOM.DOCUMENT_HEADER_ID_2
, NULL)
, NULL)
, DECODE(NVL(EI.PO_LINE_ID
, -99)
, -99
, 'N'
, 'Y')
, NULL
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, PA_FUNDS_CONTROL_UTILS.GET_AP_SLA_REVERSED_STATUS(BCCOM.DOCUMENT_HEADER_ID
, BCCOM.DOCUMENT_DISTRIBUTION_ID)
, 'N')
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_BC_COMMITMENTS_ALL BCCOM
WHERE EI.EXPENDITURE_ITEM_ID = BCCOM.EXP_ITEM_ID