CML_MATERIAL_PO_HEADERS_V
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: VIEW
Columns
Name |
---|
PO_HEADER_ID PO_NUMBER PROCUREMENT_BUSINESS_UNIT_ID DELIVER_TO_BUSINESS_UNIT_ID SOLD_TO_LEGAL_ENTITY_ID REQUISITIONING_BU_ID CURRENCY_CODE VENDOR_ID VENDOR_SITE_ID |
Query
SQL_Statement |
---|
SELECT distinct cpod.po_header_id, cpod.po_number, cpod.procurement_business_unit_id, cpod.deliver_to_business_unit_id, cpod.sold_to_legal_entity_id, cpod.requisitioning_bu_id, cpod.currency_code, cpod.vendor_id, cpod.vendor_site_id FROM cmr_purchase_order_dtls cpod WHERE cpod.accrue_on_receipt_flag = 'Y' AND cpod.purchase_basis ='GOODS' AND cpod.active_flag = 'Y' AND NVL(cpod.consigned_flag, 'N') = 'N' |