CMR_XLA_CONSIGN_INTORG_TXNS

Details

Schema: FUSION
Object owner: CMR
Object type: VIEW

Columns

Name
ACCOUNTING_EVENT_ID CMR_RCV_TRANSACTION_ID TRANSACTION_TYPE TRANSACTION_DATE RECEIPT_NUMBER QUANTITY UOM_CODE INVENTORY_ITEM_ID ITEM_NUMBER INV_ORG_ID INV_ORG_CODE BUSINESS_UNIT_ID BUSINESS_UNIT_NAME SOURCE_DOCUMENT_NUMBER SOURCE_DOCUMENT_TYPE FROM_INV_ORGANIZATION_ID FROM_INVENTORY_ORG_CODE FROM_PROFIT_CENTER_BU_ID FROM_PROFIT_CENTER_BU_NAME

Name

ACCOUNTING_EVENT_ID

CMR_RCV_TRANSACTION_ID

TRANSACTION_TYPE

TRANSACTION_DATE

RECEIPT_NUMBER

QUANTITY

UOM_CODE

INVENTORY_ITEM_ID

ITEM_NUMBER

INV_ORG_ID

INV_ORG_CODE

BUSINESS_UNIT_ID

BUSINESS_UNIT_NAME

SOURCE_DOCUMENT_NUMBER

SOURCE_DOCUMENT_TYPE

FROM_INV_ORGANIZATION_ID

FROM_INVENTORY_ORG_CODE

FROM_PROFIT_CENTER_BU_ID

FROM_PROFIT_CENTER_BU_NAME

Query

SQL_Statement
(SELECT CRE.ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID , CT.CMR_RCV_TRANSACTION_ID CMR_RCV_TRANSACTION_ID , CT.TRANSACTION_TYPE TRANSACTION_TYPE , CT.TRANSACTION_DATE TRANSACTION_DATE , CT.RECEIPT_NUMBER RECEIPT_NUMBER , CRE.SOURCE_DOC_QTY QUANTITY , IUOM.UNIT_OF_MEASURE UOM_CODE , CRE.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , ESI.ITEM_NUMBER ITEM_NUMBER , CRE.INVENTORY_ORG_ID INV_ORG_ID , IOP.ORGANIZATION_CODE INV_ORG_CODE, CRE.BUSINESS_UNIT_ID BUSINESS_UNIT_ID , HAOUS.NAME BUSINESS_UNIT_NAME, ct.SHIPMENT_NUMBER SOURCE_DOCUMENT_NUMBER, FND.MEANING SOURCE_DOCUMENT_TYPE, CT.SHIP_FROM_INV_ORG_ID FROM_INV_ORGANIZATION_ID, FROMINVORG.ORGANIZATION_CODE FROM_INVENTORY_ORG_CODE, FROMINVORG.BUSINESS_UNIT_ID FROM_PROFIT_CENTER_BU_ID, FROMBU.NAME FROM_PROFIT_CENTER_BU_NAME FROM CMR_TRANSACTIONS CT , EGP_SYSTEM_ITEMS_VL ESI , INV_ORG_PARAMETERS IOP , HR_ALL_ORGANIZATION_UNITS HAOUS , CMR_RCV_EVENTS CRE , INV_UNITS_OF_MEASURE_VL IUOM, FND_LOOKUPS FND, INV_ORG_PARAMETERS FROMINVORG, HR_ALL_ORGANIZATION_UNITS FROMBU WHERE CRE.INVENTORY_ITEM_ID = ESI.INVENTORY_ITEM_ID(+) AND CRE.INVENTORY_ORG_ID = ESI.INVENTORY_ORGANIZATION_ID(+) AND IOP.ORGANIZATION_ID = CRE.INVENTORY_ORG_ID AND HAOUS.ORGANIZATION_ID = CRE.BUSINESS_UNIT_ID AND CRE.CMR_RCV_TRANSACTION_ID = CT.CMR_RCV_TRANSACTION_ID AND CRE.EVENT_CLASS_CODE = 'CS_INTER_ORG_RECEIPT' AND IUOM.UOM_CODE = CRE.SOURCE_DOC_UOM_CODE AND CRE.EVENT_SOURCE = FND.LOOKUP_CODE AND FND.LOOKUP_TYPE ='ORA_CMR_DOC_FLOW_TYPES' AND CT.SHIP_FROM_INV_ORG_ID = FROMINVORG.ORGANIZATION_ID AND FROMBU.ORGANIZATION_ID = FROMINVORG.BUSINESS_UNIT_ID AND CRE.CONSIGNED_FLAG ='Y')

SQL_Statement

(SELECT CRE.ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID ,

CT.CMR_RCV_TRANSACTION_ID CMR_RCV_TRANSACTION_ID ,

CT.TRANSACTION_TYPE TRANSACTION_TYPE ,

CT.TRANSACTION_DATE TRANSACTION_DATE ,

CT.RECEIPT_NUMBER RECEIPT_NUMBER ,

CRE.SOURCE_DOC_QTY QUANTITY ,

IUOM.UNIT_OF_MEASURE UOM_CODE ,

CRE.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,

ESI.ITEM_NUMBER ITEM_NUMBER ,

CRE.INVENTORY_ORG_ID INV_ORG_ID ,

IOP.ORGANIZATION_CODE INV_ORG_CODE,

CRE.BUSINESS_UNIT_ID BUSINESS_UNIT_ID ,

HAOUS.NAME BUSINESS_UNIT_NAME,

ct.SHIPMENT_NUMBER SOURCE_DOCUMENT_NUMBER,

FND.MEANING SOURCE_DOCUMENT_TYPE,

CT.SHIP_FROM_INV_ORG_ID FROM_INV_ORGANIZATION_ID,

FROMINVORG.ORGANIZATION_CODE FROM_INVENTORY_ORG_CODE,

FROMINVORG.BUSINESS_UNIT_ID FROM_PROFIT_CENTER_BU_ID,

FROMBU.NAME FROM_PROFIT_CENTER_BU_NAME

FROM CMR_TRANSACTIONS CT ,

EGP_SYSTEM_ITEMS_VL ESI ,

INV_ORG_PARAMETERS IOP ,

HR_ALL_ORGANIZATION_UNITS HAOUS ,

CMR_RCV_EVENTS CRE ,

INV_UNITS_OF_MEASURE_VL IUOM,

FND_LOOKUPS FND,

INV_ORG_PARAMETERS FROMINVORG,

HR_ALL_ORGANIZATION_UNITS FROMBU

WHERE CRE.INVENTORY_ITEM_ID = ESI.INVENTORY_ITEM_ID(+)

AND CRE.INVENTORY_ORG_ID = ESI.INVENTORY_ORGANIZATION_ID(+)

AND IOP.ORGANIZATION_ID = CRE.INVENTORY_ORG_ID

AND HAOUS.ORGANIZATION_ID = CRE.BUSINESS_UNIT_ID

AND CRE.CMR_RCV_TRANSACTION_ID = CT.CMR_RCV_TRANSACTION_ID

AND CRE.EVENT_CLASS_CODE = 'CS_INTER_ORG_RECEIPT'

AND IUOM.UOM_CODE = CRE.SOURCE_DOC_UOM_CODE

AND CRE.EVENT_SOURCE = FND.LOOKUP_CODE

AND FND.LOOKUP_TYPE ='ORA_CMR_DOC_FLOW_TYPES'

AND CT.SHIP_FROM_INV_ORG_ID = FROMINVORG.ORGANIZATION_ID

AND FROMBU.ORGANIZATION_ID = FROMINVORG.BUSINESS_UNIT_ID

AND CRE.CONSIGNED_FLAG ='Y')