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, 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