機械翻訳について

CML_MATERIAL_PO_LINES_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: CML

• オブジェクト・タイプ: VIEW

列

名前
PO_HEADER_ID PO_LINE_ID LINE_NUMBER INVENTORY_ITEM_ID CATEGORY_ID DEFAULT_INVENTORY_ORG_ID PURCHASE_BASIS

問合せ

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'