1. Tables and Views for SCM
  2. CML_MATERIAL_PO_LINES_V

CML_MATERIAL_PO_LINES_V

Details

  • Schema: FUSION

  • Object owner: CML

  • Object type: VIEW

Columns

Name

PO_HEADER_ID

PO_LINE_ID

LINE_NUMBER

INVENTORY_ITEM_ID

CATEGORY_ID

DEFAULT_INVENTORY_ORG_ID

PURCHASE_BASIS

Query

SQL_Statement

SELECT distinct cpod.po_header_id,

cpod.po_line_id,

cpod.line_number,

cpod.inventory_item_id,

cpod.category_id,

cpod.default_inventory_org_id,

cpod.purchase_basis

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'