CML_SERVICE_PO_LINES_V

Details

• Schema: FUSION

• Object owner: CML

• Object type: VIEW

Columns

Name
PO_HEADER_ID PO_LINE_ID LINE_NUMBER PURCHASE_BASIS

Query

SQL_Statement
SELECT distinct cpod.po_header_id, cpod.po_line_id, cpod.line_number, cpod.purchase_basis FROM cmr_purchase_order_dtls cpod WHERE cpod.purchase_basis = 'SERVICES' AND cpod.active_flag = 'Y'