CMR_XLA_INTERORG_REF_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CMR
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SHIP_FROM_INVENTORY_ORG_CODE SHIP_FROM_PROFIT_CENTER_BU SOURCE_DOCUMENT_NUMBER CMR_RCV_TRANSACTION_ID |
問合せ
| SQL_Statement |
|---|
|
select IOP.ORGANIZATION_CODE SHIP_FROM_INVENTORY_ORG_CODE, HAOUS.name SHIP_FROM_PROFIT_CENTER_BU, CT.SHIPMENT_NUMBER SOURCE_DOCUMENT_NUMBER, CT.CMR_RCV_TRANSACTION_ID CMR_RCV_TRANSACTION_ID from CMR_TRANSACTIONS CT, INV_ORG_PARAMETERS SHIP_INV_ORG, HR_ALL_ORGANIZATION_UNITS HAOUS, INV_ORG_PARAMETERS IOP where IOP.ORGANIZATION_ID = CT.SHIP_FROM_INV_ORG_ID and CT.SHIP_FROM_INV_ORG_ID = IOP.ORGANIZATION_ID and IOP.BUSINESS_UNIT_ID = HAOUS.ORGANIZATION_ID |