CMR_XLA_XCC_PE_DTLS_V
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: VIEW
Columns
Name |
---|
CMR_PO_DISTRIBUTION_ID PE_BUDGETARY_CONTROL_FLAG ENCUMBRANCE_TYPE_ID |
Query
SQL_Statement |
---|
SELECT cpod.cmr_po_distribution_id cmr_po_distribution_id, DECODE(pod.funds_status,NULL,'N','NOT_APPLICABLE', 'N', 'Y') pe_budgetary_control_flag , getv.encumbrance_type_id encumbrance_type_id FROM cmr_purchase_order_dtls cpod, po_distributions_all pod, gl_encumbrance_types_vl getv WHERE cpod.external_system_ref_id = pod.po_distribution_id AND cpod.po_line_location_id = pod.line_location_id AND cpod.po_header_id = pod.po_header_id AND cpod.active_flag ='Y' AND getv.encumbrance_type_code = 'Obligation' |