CMR_XLA_INTERORG_REF_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
SHIP_FROM_INVENTORY_ORG_CODE SHIP_FROM_PROFIT_CENTER_BU SOURCE_DOCUMENT_NUMBER CMR_RCV_TRANSACTION_ID

Query

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