CML_SERVICE_PO_HEADERS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CML
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PO_HEADER_ID PO_NUMBER PROCUREMENT_BUSINESS_UNIT_ID DELIVER_TO_BUSINESS_UNIT_ID SOLD_TO_LEGAL_ENTITY_ID CURRENCY_CODE VENDOR_ID VENDOR_SITE_ID AGENT_ID |
問合せ
| 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.currency_code, cpod.vendor_id, cpod.vendor_site_id, cpod.agent_id FROM cmr_purchase_order_dtls cpod WHERE cpod.purchase_basis = 'SERVICES' AND cpod.active_flag = 'Y' |