VIEW: APPS.PO_REQ_EXTRACT_DETAIL_V

Source

View Text - Preformatted

SELECT POBD.AE_EVENT_ID , POBD.LINE_NUMBER , POBD.LINE_ID , POBD.DISTRIBUTION_ID , POBD.DISTRIBUTION_TYPE , 'PO_REQ_DISTRIBUTIONS_ALL' , POBD.MAIN_OR_BACKING_CODE , POBD.CODE_COMBINATION_ID , POBD.CURRENCY_CODE , POBD.ACCOUNTED_AMT , POBD.ENTERED_AMT , POBD.BACKING_DIST_ENTERED_AMT , POBD.BACKING_DIST_ACCOUNTED_AMT, POBD.JE_LINE_DESCRIPTION , POBD.REFERENCE10 , POBD.APPLIED_TO_APPL_ID , POBD.APPLIED_TO_ENTITY_CODE , POBD.APPLIED_TO_HEADER_ID_1 , POBD.APPLIED_TO_DIST_LINK_TYPE, POBD.APPLIED_TO_DIST_ID_1 , POBD.APPLIED_TO_DIST_ID_2 , POBD.APPLIED_TO_DIST_ID_3 , POBD.APPLIED_TO_DIST_ID_4 , POBD.APPLIED_TO_DIST_ID_5, 'N', POBD.ADJUSTMENT_STATUS, PSA_BC_XLA_PUB.Get_sla_notupgraded_flag (Pobd.applied_to_appl_id, pobd.applied_to_entity_code,Pobd.applied_to_header_id_1, pobd.applied_to_dist_link_type,Pobd.applied_to_dist_id_1), POBD.PA_PROJECT_ID, POBD.PA_AWARD_ID, POBD.PA_TASK_ID, POBD.PA_EXP_ORG_ID, POBD.PA_EXP_TYPE, POBD.PA_EXP_ITEM_DATE, glenct.encumbrance_type_id FROM PO_BC_DISTRIBUTIONS POBD, XLA_EVENTS_GT XEG, gl_encumbrance_types glenct WHERE XEG.EVENT_ID = POBD.AE_EVENT_ID AND glenct.encumbrance_type_key = 'Commitment'

View Text - HTML Formatted

SELECT POBD.AE_EVENT_ID
, POBD.LINE_NUMBER
, POBD.LINE_ID
, POBD.DISTRIBUTION_ID
, POBD.DISTRIBUTION_TYPE
, 'PO_REQ_DISTRIBUTIONS_ALL'
, POBD.MAIN_OR_BACKING_CODE
, POBD.CODE_COMBINATION_ID
, POBD.CURRENCY_CODE
, POBD.ACCOUNTED_AMT
, POBD.ENTERED_AMT
, POBD.BACKING_DIST_ENTERED_AMT
, POBD.BACKING_DIST_ACCOUNTED_AMT
, POBD.JE_LINE_DESCRIPTION
, POBD.REFERENCE10
, POBD.APPLIED_TO_APPL_ID
, POBD.APPLIED_TO_ENTITY_CODE
, POBD.APPLIED_TO_HEADER_ID_1
, POBD.APPLIED_TO_DIST_LINK_TYPE
, POBD.APPLIED_TO_DIST_ID_1
, POBD.APPLIED_TO_DIST_ID_2
, POBD.APPLIED_TO_DIST_ID_3
, POBD.APPLIED_TO_DIST_ID_4
, POBD.APPLIED_TO_DIST_ID_5
, 'N'
, POBD.ADJUSTMENT_STATUS
, PSA_BC_XLA_PUB.GET_SLA_NOTUPGRADED_FLAG (POBD.APPLIED_TO_APPL_ID
, POBD.APPLIED_TO_ENTITY_CODE
, POBD.APPLIED_TO_HEADER_ID_1
, POBD.APPLIED_TO_DIST_LINK_TYPE
, POBD.APPLIED_TO_DIST_ID_1)
, POBD.PA_PROJECT_ID
, POBD.PA_AWARD_ID
, POBD.PA_TASK_ID
, POBD.PA_EXP_ORG_ID
, POBD.PA_EXP_TYPE
, POBD.PA_EXP_ITEM_DATE
, GLENCT.ENCUMBRANCE_TYPE_ID
FROM PO_BC_DISTRIBUTIONS POBD
, XLA_EVENTS_GT XEG
, GL_ENCUMBRANCE_TYPES GLENCT
WHERE XEG.EVENT_ID = POBD.AE_EVENT_ID
AND GLENCT.ENCUMBRANCE_TYPE_KEY = 'COMMITMENT'