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'