CML_SERVICEPO_DTLS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: FUSION
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PO_NUMBER LINE_NUMBER SHIPMENT_NUMBER CMR_PO_LINE_LOCATION_ID PO_HEADER_ID PO_LINE_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT distinct cpod.po_number, cpod.line_number, cpod.shipment_number, cpod.cmr_po_line_location_id, cpod.po_header_id, cpod.po_line_id FROM cmr_purchase_order_dtls cpod WHERE cpod.purchase_basis = 'SERVICES' AND cpod.active_flag = 'Y' |