VIEW: APPS.PO_EXTRACT_DETAIL_V

Source

View Text - Preformatted

SELECT PBD.AE_EVENT_ID, PBD.LINE_NUMBER, PBD.DISTRIBUTION_ID, PBD.DISTRIBUTION_TYPE, PBD.LINE_LOCATION_ID, DECODE(PBD.DISTRIBUTION_TYPE, 'REQUISITION', NULL,PBD.LINE_ID), DECODE(PBD.DISTRIBUTION_TYPE, 'REQUISITION', PBD.LINE_ID, NULL), DECODE(PBD.DISTRIBUTION_TYPE, 'REQUISITION','PO_REQ_DISTRIBUTIONS_ALL', 'PO_DISTRIBUTIONS_ALL'), PBD.MAIN_OR_BACKING_CODE, PBD.CODE_COMBINATION_ID, PBD.CURRENCY_CODE, PBD.ENTERED_AMT , PBD.ACCOUNTED_AMT, PBD.BACKING_DIST_ENTERED_AMT , PBD.BACKING_DIST_ACCOUNTED_AMT, PBD.JE_LINE_DESCRIPTION, PBD.REFERENCE10, PBD.APPLIED_TO_APPL_ID, PBD.APPLIED_TO_ENTITY_CODE, PBD.APPLIED_TO_HEADER_ID_1, PBD.APPLIED_TO_DIST_LINK_TYPE, PBD.APPLIED_TO_DIST_ID_1 , PBD.APPLIED_TO_DIST_ID_2 , PBD.APPLIED_TO_DIST_ID_3 , PBD.APPLIED_TO_DIST_ID_4 , PBD.APPLIED_TO_DIST_ID_5 , decode(MAIN_OR_BACKING_CODE, 'M', DISTRIBUTION_ID, APPLIED_TO_DIST_ID_2), 'N', PBD.ADJUSTMENT_STATUS, PSA_BC_XLA_PUB.Get_sla_notupgraded_flag (Pbd.applied_to_appl_id, pbd.applied_to_entity_code,Pbd.applied_to_header_id_1, pbd.applied_to_dist_link_type,Pbd.applied_to_dist_id_1), PBD.PA_PROJECT_ID, PBD.PA_AWARD_ID, PBD.PA_TASK_ID, PBD.PA_EXP_ORG_ID, PBD.PA_EXP_TYPE, PBD.PA_EXP_ITEM_DATE, PO_DOCUMENT_FUNDS_PVT.is_req_enc_flipped(PBD.DISTRIBUTION_ID,PBD.AE_EVENT_ID), 'PO_DISTRIBUTIONS_ALL', decode(PBD.main_or_backing_code, 'B_REQ', 1000, 1001) FROM PO_BC_DISTRIBUTIONS PBD , XLA_EVENTS_GT XEG WHERE XEG.EVENT_ID = PBD.AE_EVENT_ID

View Text - HTML Formatted

SELECT PBD.AE_EVENT_ID
, PBD.LINE_NUMBER
, PBD.DISTRIBUTION_ID
, PBD.DISTRIBUTION_TYPE
, PBD.LINE_LOCATION_ID
, DECODE(PBD.DISTRIBUTION_TYPE
, 'REQUISITION'
, NULL
, PBD.LINE_ID)
, DECODE(PBD.DISTRIBUTION_TYPE
, 'REQUISITION'
, PBD.LINE_ID
, NULL)
, DECODE(PBD.DISTRIBUTION_TYPE
, 'REQUISITION'
, 'PO_REQ_DISTRIBUTIONS_ALL'
, 'PO_DISTRIBUTIONS_ALL')
, PBD.MAIN_OR_BACKING_CODE
, PBD.CODE_COMBINATION_ID
, PBD.CURRENCY_CODE
, PBD.ENTERED_AMT
, PBD.ACCOUNTED_AMT
, PBD.BACKING_DIST_ENTERED_AMT
, PBD.BACKING_DIST_ACCOUNTED_AMT
, PBD.JE_LINE_DESCRIPTION
, PBD.REFERENCE10
, PBD.APPLIED_TO_APPL_ID
, PBD.APPLIED_TO_ENTITY_CODE
, PBD.APPLIED_TO_HEADER_ID_1
, PBD.APPLIED_TO_DIST_LINK_TYPE
, PBD.APPLIED_TO_DIST_ID_1
, PBD.APPLIED_TO_DIST_ID_2
, PBD.APPLIED_TO_DIST_ID_3
, PBD.APPLIED_TO_DIST_ID_4
, PBD.APPLIED_TO_DIST_ID_5
, DECODE(MAIN_OR_BACKING_CODE
, 'M'
, DISTRIBUTION_ID
, APPLIED_TO_DIST_ID_2)
, 'N'
, PBD.ADJUSTMENT_STATUS
, PSA_BC_XLA_PUB.GET_SLA_NOTUPGRADED_FLAG (PBD.APPLIED_TO_APPL_ID
, PBD.APPLIED_TO_ENTITY_CODE
, PBD.APPLIED_TO_HEADER_ID_1
, PBD.APPLIED_TO_DIST_LINK_TYPE
, PBD.APPLIED_TO_DIST_ID_1)
, PBD.PA_PROJECT_ID
, PBD.PA_AWARD_ID
, PBD.PA_TASK_ID
, PBD.PA_EXP_ORG_ID
, PBD.PA_EXP_TYPE
, PBD.PA_EXP_ITEM_DATE
, PO_DOCUMENT_FUNDS_PVT.IS_REQ_ENC_FLIPPED(PBD.DISTRIBUTION_ID
, PBD.AE_EVENT_ID)
, 'PO_DISTRIBUTIONS_ALL'
, DECODE(PBD.MAIN_OR_BACKING_CODE
, 'B_REQ'
, 1000
, 1001)
FROM PO_BC_DISTRIBUTIONS PBD
, XLA_EVENTS_GT XEG
WHERE XEG.EVENT_ID = PBD.AE_EVENT_ID