eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CST_MTL_RCV_TXN_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_MTL_RCV_TXN_V

View Text

SELECT MMT.ROWID
, XFI.LEGAL_ENTITY_ID
, XFI.NAME
, CCG.COST_GROUP_ID
, CCG.COST_GROUP
, CCG.ORGANIZATION_ID
, MMT.ORGANIZATION_ID
, NULL
, HAOU1.NAME
, MP1.ORGANIZATION_CODE
, GLL.PRIMARY_LEDGER_ID
, MMT.TRANSFER_ORGANIZATION_ID
, HAOU2.NAME
, MP2.ORGANIZATION_CODE
, MMT.TRANSFER_SUBINVENTORY
, MMT.TRANSFER_LOCATOR_ID
, MIL1.CONCATENATED_SEGMENTS
, MMT.SHIPMENT_NUMBER
, MMT.TRANSFER_TRANSACTION_ID
, MMT.TRANSACTION_ID
, MMT.TRANSACTION_DATE
, MMT.TRANSACTION_SOURCE_TYPE_ID
, MTST.TRANSACTION_SOURCE_TYPE_NAME
, MMT.TRANSACTION_SOURCE_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 1
, PHA.SEGMENT1
, 2
, MSOK.CONCATENATED_SEGMENTS
, 3
, GCCK.CONCATENATED_SEGMENTS
, 4
, MTRH.REQUEST_NUMBER
, 5
, WE.WIP_ENTITY_NAME
, 6
, GCCK2.CONCATENATED_SEGMENTS
, 7
, PRHA.SEGMENT1
, 8
, MSOK.CONCATENATED_SEGMENTS
, 9
, MCCH.CYCLE_COUNT_HEADER_NAME
, 10
, MPI.PHYSICAL_INVENTORY_NAME
, 11
, CCU.DESCRIPTION
, 12
, MSOK.CONCATENATED_SEGMENTS
, MMT.TRANSACTION_SOURCE_NAME)
, MMT.TRANSACTION_QUANTITY
, MMT.TRANSACTION_UOM
, MMT.PRIMARY_QUANTITY
, MSV.PRIMARY_UOM_CODE
, MMT.TRANSACTION_ACTION_ID
, LU1.MEANING TRANSACTION_ACTION
, MMT.TRANSACTION_TYPE_ID
, MTT.TRANSACTION_TYPE_NAME
, TO_NUMBER ( NULL )
, NULL
, TO_NUMBER ( NULL )
, TO_NUMBER ( NULL )
, TO_NUMBER ( NULL )
, NULL
, TO_NUMBER ( NULL )
, TO_NUMBER ( NULL )
, TO_NUMBER ( NULL )
, NULL
, TO_NUMBER ( NULL )
, NULL
, NULL
, NULL
, TO_NUMBER ( NULL )
, MMT.INVENTORY_ITEM_ID
, MSV.DESCRIPTION
, MMT.REVISION
, MMT.WAYBILL_AIRBILL
, MMT.FREIGHT_CODE
, MMT.NUMBER_OF_CONTAINERS
, MMT.SUBINVENTORY_CODE
, MMT.LOCATOR_ID
, MIL2.CONCATENATED_SEGMENTS
, MTR.REASON_NAME
, MMT.TRANSACTION_REFERENCE
, MMT.LAST_UPDATE_DATE
, MMT.LAST_UPDATED_BY
, MMT.CREATION_DATE
, MMT.CREATED_BY
, MMT.LAST_UPDATE_LOGIN
, MMT.REQUEST_ID
, MMT.PROGRAM_APPLICATION_ID
, MMT.PROGRAM_ID
, MMT.PROGRAM_UPDATE_DATE
, MMT.ATTRIBUTE_CATEGORY
, MMT.ATTRIBUTE1
, MMT.ATTRIBUTE2
, MMT.ATTRIBUTE3
, MMT.ATTRIBUTE4
, MMT.ATTRIBUTE5
, MMT.ATTRIBUTE6
, MMT.ATTRIBUTE7
, MMT.ATTRIBUTE8
, MMT.ATTRIBUTE9
, MMT.ATTRIBUTE10
, MMT.ATTRIBUTE11
, MMT.ATTRIBUTE12
, MMT.ATTRIBUTE13
, MMT.ATTRIBUTE14
, MMT.ATTRIBUTE15
, 'MMT'
FROM CST_COST_GROUPS CCG
, CST_COST_GROUP_ASSIGNMENTS CCGA
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TXN_SOURCE_TYPES MTST
, MTL_SYSTEM_ITEMS_VL MSV
, MTL_TRANSACTION_TYPES MTT
, MTL_TRANSACTION_REASONS MTR
, XLE_FIRSTPARTY_INFORMATION_V XFI
, GL_LEDGER_LE_V GLL
, HR_ALL_ORGANIZATION_UNITS_TL HAOU1
, HR_ALL_ORGANIZATION_UNITS_TL HAOU2
, MTL_PARAMETERS MP
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MFG_LOOKUPS LU1
, PO_HEADERS_ALL PHA
, MTL_TXN_REQUEST_HEADERS MTRH
, WIP_ENTITIES WE
, MTL_SALES_ORDERS_KFV MSOK
, GL_CODE_COMBINATIONS_KFV GCCK
, MTL_CYCLE_COUNT_HEADERS MCCH
, MTL_PHYSICAL_INVENTORIES MPI
, PO_REQUISITION_HEADERS_ALL PRHA
, CST_COST_UPDATES CCU
, GL_CODE_COMBINATIONS_KFV GCCK2
, MTL_GENERIC_DISPOSITIONS MGD
, MTL_ITEM_LOCATIONS_KFV MIL1
, MTL_ITEM_LOCATIONS_KFV MIL2
WHERE MMT.TRANSACTION_TYPE_ID != 26
AND MMT.ORGANIZATION_ID = DECODE(MMT.TRANSACTION_ACTION_ID
, 21
, DECODE(MMT.FOB_POINT
, 1
, MMT.ORGANIZATION_ID
, CCGA.ORGANIZATION_ID)
, 12
, DECODE(MMT.FOB_POINT
, 2
, MMT.ORGANIZATION_ID
, CCGA.ORGANIZATION_ID)
, CCGA.ORGANIZATION_ID)
AND MMT.ORGANIZATION_ID = DECODE(MMT.TRANSACTION_ACTION_ID
, 21
, DECODE(MMT.FOB_POINT
, 1
, MMT.ORGANIZATION_ID
, NVL(MMT.OWNING_ORGANIZATION_ID
, MMT.ORGANIZATION_ID))
, 12
, DECODE(MMT.FOB_POINT
, 2
, MMT.ORGANIZATION_ID
, NVL(MMT.OWNING_ORGANIZATION_ID
, MMT.ORGANIZATION_ID))
, NVL(MMT.OWNING_ORGANIZATION_ID
, MMT.ORGANIZATION_ID))
AND NVL(MMT.OWNING_TP_TYPE
, 2) = 2
AND ( (CCGA.ORGANIZATION_ID = MMT.ORGANIZATION_ID) OR (CCGA.ORGANIZATION_ID = MMT.TRANSFER_ORGANIZATION_ID
AND CCGA.COST_GROUP_ID NOT IN (SELECT COST_GROUP_ID
FROM CST_COST_GROUP_ASSIGNMENTS CCGA2
WHERE CCGA2.ORGANIZATION_ID = MMT.ORGANIZATION_ID)
AND ( (MMT.TRANSACTION_ACTION_ID = 21
AND MMT.FOB_POINT = 1) OR (MMT.TRANSACTION_ACTION_ID = 12
AND MMT.FOB_POINT = 2) ) ) )
AND CCGA.COST_GROUP_ID = CCG.COST_GROUP_ID
AND XFI.LEGAL_ENTITY_ID = CCG.LEGAL_ENTITY
AND GLL.LEGAL_ENTITY_ID = XFI.LEGAL_ENTITY_ID
AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
AND MMT.TRANSFER_LOCATOR_ID = MIL1.INVENTORY_LOCATION_ID(+)
AND MMT.LOCATOR_ID = MIL2.INVENTORY_LOCATION_ID (+)
AND MMT.TRANSFER_ORGANIZATION_ID = MIL1.ORGANIZATION_ID (+)
AND MMT.ORGANIZATION_ID = MIL2.ORGANIZATION_ID (+)
AND MP1.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND HAOU1.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND HAOU1.LANGUAGE = USERENV('LANG')
AND MSV.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MSV.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
AND MTST.TRANSACTION_SOURCE_TYPE_ID = MMT.TRANSACTION_SOURCE_TYPE_ID
AND MMT.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND LU1.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION'
AND LU1.LOOKUP_CODE = MMT.TRANSACTION_ACTION_ID
AND MP2.ORGANIZATION_ID (+) = MMT.TRANSFER_ORGANIZATION_ID
AND HAOU2.ORGANIZATION_ID(+) = MMT.TRANSFER_ORGANIZATION_ID
AND NVL(HAOU2.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND MTR.REASON_ID (+) = MMT.REASON_ID
AND PHA.PO_HEADER_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND WE.WIP_ENTITY_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND MTRH.HEADER_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND MSOK.SALES_ORDER_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND GCCK.CODE_COMBINATION_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND MCCH.CYCLE_COUNT_HEADER_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND MPI.PHYSICAL_INVENTORY_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND MPI.ORGANIZATION_ID (+) = MMT.ORGANIZATION_ID
AND PRHA.REQUISITION_HEADER_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND CCU.COST_UPDATE_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND MGD.DISPOSITION_ID (+) = MMT.TRANSACTION_SOURCE_ID
AND GCCK2.CODE_COMBINATION_ID (+) = MGD.DISTRIBUTION_ACCOUNT
AND MMT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND NVL(MP.PROCESS_ENABLED_FLAG
, 'N') <> 'Y' UNION SELECT MMT.ROWID
, XFI.LEGAL_ENTITY_ID
, XFI.NAME
, CCG.COST_GROUP_ID
, CCG.COST_GROUP
, CCG.ORGANIZATION_ID
, MMT.ORGANIZATION_ID
, NULL
, HAOU1.NAME
, MP1.ORGANIZATION_CODE
, GLL.PRIMARY_LEDGER_ID
, MMT.TRANSFER_ORGANIZATION_ID
, HAOU2.NAME
, MP2.ORGANIZATION_CODE
, MMT.TRANSFER_SUBINVENTORY
, MMT.TRANSFER_LOCATOR_ID
, MIL1.CONCATENATED_SEGMENTS
, MMT.SHIPMENT_NUMBER
, MMT.TRANSFER_TRANSACTION_ID
, MMT.TRANSACTION_ID
, MMT.TRANSACTION_DATE
, MMT.TRANSACTION_SOURCE_TYPE_ID
, MTST.TRANSACTION_SOURCE_TYPE_NAME
, MMT.TRANSACTION_SOURCE_ID
, MMT.TRANSACTION_SOURCE_NAME
, MMT.TRANSACTION_QUANTITY
, MMT.TRANSACTION_UOM
, MMT.PRIMARY_QUANTITY
, MSV.PRIMARY_UOM_CODE
, MMT.TRANSACTION_ACTION_ID
, LU1.MEANING TRANSACTION_ACTION
, MMT.TRANSACTION_TYPE_ID
, MTT.TRANSACTION_TYPE_NAME
, TO_NUMBER ( NULL )
, NULL
, TO_NUMBER ( NULL )
, TO_NUMBER ( NULL )
, TO_NUMBER ( NULL )
, NULL
, TO_NUMBER ( NULL )
, TO_NUMBER ( NULL )
, TO_NUMBER ( NULL )
, NULL
, TO_NUMBER ( NULL)
, NULL
, NULL
, NULL
, TO_NUMBER ( NULL )
, MMT.INVENTORY_ITEM_ID
, MSV.DESCRIPTION
, MMT.REVISION
, MMT.WAYBILL_AIRBILL
, MMT.FREIGHT_CODE
, MMT.NUMBER_OF_CONTAINERS
, MMT.SUBINVENTORY_CODE
, MMT.LOCATOR_ID
, MIL2.CONCATENATED_SEGMENTS
, MTR.REASON_NAME
, MMT.TRANSACTION_REFERENCE
, MMT.LAST_UPDATE_DATE
, MMT.LAST_UPDATED_BY
, MMT.CREATION_DATE
, MMT.CREATED_BY
, MMT.LAST_UPDATE_LOGIN
, MMT.REQUEST_ID
, MMT.PROGRAM_APPLICATION_ID
, MMT.PROGRAM_ID
, MMT.PROGRAM_UPDATE_DATE
, MMT.ATTRIBUTE_CATEGORY
, MMT.ATTRIBUTE1
, MMT.ATTRIBUTE2
, MMT.ATTRIBUTE3
, MMT.ATTRIBUTE4
, MMT.ATTRIBUTE5
, MMT.ATTRIBUTE6
, MMT.ATTRIBUTE7
, MMT.ATTRIBUTE8
, MMT.ATTRIBUTE9
, MMT.ATTRIBUTE10
, MMT.ATTRIBUTE11
, MMT.ATTRIBUTE12
, MMT.ATTRIBUTE13
, MMT.ATTRIBUTE14
, MMT.ATTRIBUTE15
, 'MMT'
FROM CST_COST_GROUPS CCG
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TXN_SOURCE_TYPES MTST
, MTL_SYSTEM_ITEMS_VL MSV
, MTL_TRANSACTION_TYPES MTT
, MTL_TRANSACTION_REASONS MTR
, XLE_FIRSTPARTY_INFORMATION_V XFI
, GL_LEDGER_LE_V GLL
, HR_ALL_ORGANIZATION_UNITS_TL HAOU1
, HR_ALL_ORGANIZATION_UNITS_TL HAOU2
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MFG_LOOKUPS LU1
, MTL_ITEM_LOCATIONS_KFV MIL1
, MTL_ITEM_LOCATIONS_KFV MIL2
WHERE MMT.TRANSACTION_TYPE_ID = 26
AND MMT.ORGANIZATION_ID = NVL(MMT.OWNING_ORGANIZATION_ID
, MMT.ORGANIZATION_ID)
AND NVL(MMT.OWNING_TP_TYPE
, 2) = 2
AND MMT.ORG_COST_GROUP_ID = CCG.COST_GROUP_ID
AND XFI.LEGAL_ENTITY_ID = CCG.LEGAL_ENTITY
AND GLL.LEGAL_ENTITY_ID = XFI.LEGAL_ENTITY_ID
AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
AND MMT.TRANSFER_LOCATOR_ID = MIL1.INVENTORY_LOCATION_ID(+)
AND MMT.LOCATOR_ID = MIL2.INVENTORY_LOCATION_ID (+)
AND MMT.TRANSFER_ORGANIZATION_ID = MIL1.ORGANIZATION_ID (+)
AND MMT.ORGANIZATION_ID = MIL2.ORGANIZATION_ID (+)
AND MP1.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND HAOU1.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND HAOU1.LANGUAGE = USERENV('LANG')
AND MSV.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MSV.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
AND MTST.TRANSACTION_SOURCE_TYPE_ID = MMT.TRANSACTION_SOURCE_TYPE_ID
AND MMT.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND LU1.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION'
AND LU1.LOOKUP_CODE = MMT.TRANSACTION_ACTION_ID
AND MP2.ORGANIZATION_ID (+) = MMT.TRANSFER_ORGANIZATION_ID
AND HAOU2.ORGANIZATION_ID(+) = MMT.TRANSFER_ORGANIZATION_ID
AND NVL(HAOU2.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND MTR.REASON_ID ( + ) = MMT.REASON_ID UNION SELECT RT.ROWID
, XFI.LEGAL_ENTITY_ID
, XFI.NAME
, CCG.COST_GROUP_ID
, CCG.COST_GROUP
, CCG.ORGANIZATION_ID
, RT.ORGANIZATION_ID
, PH.ORG_ID
, HAOU.NAME
, MP.ORGANIZATION_CODE
, GLL.PRIMARY_LEDGER_ID
, TO_NUMBER ( NULL )
, NULL
, NULL
, NULL
, TO_NUMBER ( NULL )
, NULL
, NULL
, TO_NUMBER ( NULL )
, RT.TRANSACTION_ID
, RT.TRANSACTION_DATE
, TO_NUMBER ( NULL )
, RT.SOURCE_DOCUMENT_CODE
, TO_NUMBER ( NULL )
, NULL
, RT.QUANTITY
, RT.UOM_CODE
, RT.PRIMARY_QUANTITY
, RT.PRIMARY_UNIT_OF_MEASURE
, TO_NUMBER ( NULL )
, NULL
, TO_NUMBER ( NULL )
, RT.TRANSACTION_TYPE
, RT.PO_HEADER_ID
, PH.SEGMENT1
, RT.PO_LINE_ID
, PL.LINE_NUM
, PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, RT.VENDOR_ID
, PV.VENDOR_NAME
, RT.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, RSH.RECEIPT_NUM
, RSH.SHIPMENT_NUM
, RT.LOCATION_ID
, RSL.ITEM_ID
, RSL.ITEM_DESCRIPTION
, RSL.ITEM_REVISION
, NULL
, NULL
, TO_NUMBER ( NULL )
, RT.SUBINVENTORY
, RT.LOCATOR_ID
, MIL.CONCATENATED_SEGMENTS
, MTR.REASON_NAME
, RT.COMMENTS
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.CREATION_DATE
, RT.CREATED_BY
, RT.LAST_UPDATE_LOGIN
, RT.REQUEST_ID
, RT.PROGRAM_APPLICATION_ID
, RT.PROGRAM_ID
, RT.PROGRAM_UPDATE_DATE
, RT.ATTRIBUTE_CATEGORY
, RT.ATTRIBUTE1
, RT.ATTRIBUTE2
, RT.ATTRIBUTE3
, RT.ATTRIBUTE4
, RT.ATTRIBUTE5
, RT.ATTRIBUTE6
, RT.ATTRIBUTE7
, RT.ATTRIBUTE8
, RT.ATTRIBUTE9
, RT.ATTRIBUTE10
, RT.ATTRIBUTE11
, RT.ATTRIBUTE12
, RT.ATTRIBUTE13
, RT.ATTRIBUTE14
, RT.ATTRIBUTE15
, 'RCV'
FROM CST_COST_GROUPS CCG
, CST_COST_GROUP_ASSIGNMENTS CCGA
, RCV_TRANSACTIONS RT
, PO_HEADERS_ALL PH
, PO_LINES_ALL PL
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES_ALL PRL
, MTL_TRANSACTION_REASONS MTR
, XLE_FIRSTPARTY_INFORMATION_V XFI
, GL_LEDGER_LE_V GLL
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL HAOU
, MTL_ITEM_LOCATIONS_KFV MIL
WHERE RT.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND NVL(RT.CONSIGNED_FLAG
, 'N') = 'N'
AND CCGA.COST_GROUP_ID = CCG.COST_GROUP_ID
AND XFI.LEGAL_ENTITY_ID = CCG.LEGAL_ENTITY
AND GLL.LEGAL_ENTITY_ID = XFI.LEGAL_ENTITY_ID
AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
AND MIL.ORGANIZATION_ID (+) = RT.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID (+) = RT.LOCATOR_ID
AND MP.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND HAOU.LANGUAGE = USERENV('LANG')
AND RT.PO_HEADER_ID IS NOT NULL
AND PH.PO_HEADER_ID = RT.PO_HEADER_ID
AND PL.PO_LINE_ID = RT.PO_LINE_ID
AND MTR.REASON_ID ( + ) = RT.REASON_ID
AND PRL.REQUISITION_LINE_ID ( + ) = RT.REQUISITION_LINE_ID
AND PRH.REQUISITION_HEADER_ID ( + ) = PRL.REQUISITION_HEADER_ID
AND PV.VENDOR_ID (+) = RT.VENDOR_ID
AND PVS.VENDOR_SITE_ID = RT.VENDOR_SITE_ID
AND PVS.ORG_ID = PH.ORG_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RT.ORGANIZATION_ID IS NOT NULL
AND RT.DESTINATION_TYPE_CODE != 'INVENTORY' UNION SELECT RT.ROWID
, XFI.LEGAL_ENTITY_ID
, XFI.NAME
, CCG.COST_GROUP_ID
, CCG.COST_GROUP
, CCG.ORGANIZATION_ID
, RT.ORGANIZATION_ID
, PRH.ORG_ID
, HAOU.NAME
, MP.ORGANIZATION_CODE
, GLL.PRIMARY_LEDGER_ID
, TO_NUMBER ( NULL )
, NULL
, NULL
, NULL
, TO_NUMBER ( NULL )
, NULL
, NULL
, TO_NUMBER ( NULL )
, RT.TRANSACTION_ID
, RT.TRANSACTION_DATE
, TO_NUMBER ( NULL )
, RT.SOURCE_DOCUMENT_CODE
, TO_NUMBER ( NULL )
, NULL
, RT.QUANTITY
, RT.UOM_CODE
, RT.PRIMARY_QUANTITY
, RT.PRIMARY_UNIT_OF_MEASURE
, TO_NUMBER ( NULL )
, NULL
, TO_NUMBER ( NULL )
, RT.TRANSACTION_TYPE
, RT.PO_HEADER_ID
, NULL
, RT.PO_LINE_ID
, TO_NUMBER(NULL)
, PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, RT.VENDOR_ID
, PV.VENDOR_NAME
, RT.VENDOR_SITE_ID
, NULL
, RSH.RECEIPT_NUM
, RSH.SHIPMENT_NUM
, RT.LOCATION_ID
, RSL.ITEM_ID
, RSL.ITEM_DESCRIPTION
, RSL.ITEM_REVISION
, NULL
, NULL
, TO_NUMBER ( NULL )
, RT.SUBINVENTORY
, RT.LOCATOR_ID
, MIL.CONCATENATED_SEGMENTS
, MTR.REASON_NAME
, RT.COMMENTS
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.CREATION_DATE
, RT.CREATED_BY
, RT.LAST_UPDATE_LOGIN
, RT.REQUEST_ID
, RT.PROGRAM_APPLICATION_ID
, RT.PROGRAM_ID
, RT.PROGRAM_UPDATE_DATE
, RT.ATTRIBUTE_CATEGORY
, RT.ATTRIBUTE1
, RT.ATTRIBUTE2
, RT.ATTRIBUTE3
, RT.ATTRIBUTE4
, RT.ATTRIBUTE5
, RT.ATTRIBUTE6
, RT.ATTRIBUTE7
, RT.ATTRIBUTE8
, RT.ATTRIBUTE9
, RT.ATTRIBUTE10
, RT.ATTRIBUTE11
, RT.ATTRIBUTE12
, RT.ATTRIBUTE13
, RT.ATTRIBUTE14
, RT.ATTRIBUTE15
, 'RCV'
FROM CST_COST_GROUPS CCG
, CST_COST_GROUP_ASSIGNMENTS CCGA
, RCV_TRANSACTIONS RT
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_VENDORS PV
, PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES_ALL PRL
, MTL_TRANSACTION_REASONS MTR
, XLE_FIRSTPARTY_INFORMATION_V XFI
, GL_LEDGER_LE_V GLL
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL HAOU
, MTL_ITEM_LOCATIONS_KFV MIL
WHERE RT.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND NVL(RT.CONSIGNED_FLAG
, 'N') = 'N'
AND CCGA.COST_GROUP_ID = CCG.COST_GROUP_ID
AND XFI.LEGAL_ENTITY_ID = CCG.LEGAL_ENTITY
AND GLL.LEGAL_ENTITY_ID = XFI.LEGAL_ENTITY_ID
AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
AND MIL.ORGANIZATION_ID (+) = RT.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID (+) = RT.LOCATOR_ID
AND MP.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND HAOU.LANGUAGE = USERENV('LANG')
AND RT.PO_HEADER_ID IS NULL
AND MTR.REASON_ID ( + ) = RT.REASON_ID
AND PRL.REQUISITION_LINE_ID ( + ) = RT.REQUISITION_LINE_ID
AND PRH.REQUISITION_HEADER_ID ( + ) = PRL.REQUISITION_HEADER_ID
AND PV.VENDOR_ID ( + ) = RT.VENDOR_ID
AND RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RT.ORGANIZATION_ID IS NOT NULL
AND RT.DESTINATION_TYPE_CODE != 'INVENTORY' UNION SELECT RAE.ROWID
, XFI.LEGAL_ENTITY_ID
, XFI.NAME
, CCG.COST_GROUP_ID
, CCG.COST_GROUP
, CCG.ORGANIZATION_ID
, RAE.ORGANIZATION_ID
, PH.ORG_ID
, HAOU.NAME
, MP.ORGANIZATION_CODE
, GLL.PRIMARY_LEDGER_ID
, TO_NUMBER ( NULL )
, NULL
, NULL
, NULL
, TO_NUMBER ( NULL )
, NULL
, NULL
, TO_NUMBER ( NULL )
, RAE.ACCOUNTING_EVENT_ID
, RAE.TRANSACTION_DATE
, TO_NUMBER ( NULL )
, RT.SOURCE_DOCUMENT_CODE
, TO_NUMBER ( NULL )
, NULL
, RAE.TRANSACTION_QUANTITY
, RT.UOM_CODE
, RAE.PRIMARY_QUANTITY
, RAE.PRIMARY_UNIT_OF_MEASURE
, TO_NUMBER ( NULL )
, NULL
, TO_NUMBER ( NULL )
, DECODE(RAE.EVENT_TYPE_ID
, 18
, RAET.DESCRIPTION
, 19
, RAET.DESCRIPTION
, 20
, RAET.DESCRIPTION
, RAET.EVENT_TYPE_NAME) EVENT_TYPE_NAME
, RAE.PO_HEADER_ID
, PH.SEGMENT1
, RT.PO_LINE_ID
, PL.LINE_NUM
, PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, RT.VENDOR_ID
, PV.VENDOR_NAME
, RT.VENDOR_SITE_ID
, NULL
, RSH.RECEIPT_NUM
, RSH.SHIPMENT_NUM
, RT.LOCATION_ID
, RSL.ITEM_ID
, RSL.ITEM_DESCRIPTION
, RSL.ITEM_REVISION
, NULL
, NULL
, TO_NUMBER ( NULL )
, RT.SUBINVENTORY
, RT.LOCATOR_ID
, MIL.CONCATENATED_SEGMENTS
, MTR.REASON_NAME
, RT.COMMENTS
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.CREATION_DATE
, RT.CREATED_BY
, RT.LAST_UPDATE_LOGIN
, RT.REQUEST_ID
, RT.PROGRAM_APPLICATION_ID
, RT.PROGRAM_ID
, RT.PROGRAM_UPDATE_DATE
, RT.ATTRIBUTE_CATEGORY
, RT.ATTRIBUTE1
, RT.ATTRIBUTE2
, RT.ATTRIBUTE3
, RT.ATTRIBUTE4
, RT.ATTRIBUTE5
, RT.ATTRIBUTE6
, RT.ATTRIBUTE7
, RT.ATTRIBUTE8
, RT.ATTRIBUTE9
, RT.ATTRIBUTE10
, RT.ATTRIBUTE11
, RT.ATTRIBUTE12
, RT.ATTRIBUTE13
, RT.ATTRIBUTE14
, RT.ATTRIBUTE15
, 'RAE'
FROM CST_COST_GROUPS CCG
, CST_COST_GROUP_ASSIGNMENTS CCGA
, RCV_TRANSACTIONS RT
, RCV_ACCOUNTING_EVENTS RAE
, RCV_ACCOUNTING_EVENT_TYPES RAET
, PO_HEADERS_ALL PH
, PO_LINES_ALL PL
, PO_VENDORS PV
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES_ALL PRL
, MTL_TRANSACTION_REASONS MTR
, XLE_FIRSTPARTY_INFORMATION_V XFI
, GL_LEDGER_LE_V GLL
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL HAOU
, MTL_ITEM_LOCATIONS_KFV MIL
WHERE RAE.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND RAE.EVENT_TYPE_ID = RAET.EVENT_TYPE_ID
AND NVL(RT.CONSIGNED_FLAG
, 'N') = 'N'
AND CCGA.COST_GROUP_ID = CCG.COST_GROUP_ID
AND XFI.LEGAL_ENTITY_ID = CCG.LEGAL_ENTITY
AND GLL.LEGAL_ENTITY_ID = XFI.LEGAL_ENTITY_ID
AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
AND MIL.ORGANIZATION_ID (+) = RT.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID (+) = RT.LOCATOR_ID
AND MP.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
AND HAOU.LANGUAGE = USERENV('LANG')
AND RAE.RCV_TRANSACTION_ID = RT.TRANSACTION_ID
AND RT.PO_HEADER_ID IS NOT NULL
AND PH.PO_HEADER_ID = RT.PO_HEADER_ID
AND PL.PO_LINE_ID = RT.PO_LINE_ID
AND MTR.REASON_ID ( + ) = RT.REASON_ID
AND PRL.REQUISITION_LINE_ID ( + ) = RT.REQUISITION_LINE_ID
AND PRH.REQUISITION_HEADER_ID ( + ) = PRL.REQUISITION_HEADER_ID
AND PV.VENDOR_ID (+) = RT.VENDOR_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RT.ORGANIZATION_ID IS NOT NULL
AND RAE.EVENT_TYPE_ID IN (7
, 9
, 10
, 18
, 19
, 20)
AND RT.DESTINATION_TYPE_CODE != 'INVENTORY'

Columns

Name
ROW_ID
LEGAL_ENTITY_ID
LEGAL_ENTITY_NAME
COST_GROUP_ID
COST_GROUP_NAME
MASTER_ORG_ID
ORGANIZATION_ID
OPERATING_UNIT_ID
ORGANIZATION_NAME
ORG_CODE
SET_OF_BOOKS_ID
TRANSFER_ORGANIZATION_ID
TRANSFER_ORGANIZATION_NAME
TRANSFER_ORGANIZATION_CODE
TRANSFER_SUBINVENTORY
TRANSFER_LOCATOR_ID
TRANSFER_LOCATOR_NAME
SHIPMENT_NUMBER
TRANSFER_TRANSACTION_ID
TRANSACTION_ID
TRANSACTION_DATE
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_SOURCE_TYPE_NAME
TRANSACTION_SOURCE_ID
TRANSACTION_SOURCE_NAME_DB
TRANSACTION_QUANTITY
TRANSACTION_UOM
PRIMARY_QUANTITY
PRIMARY_UOM_CODE
TRANSACTION_ACTION_ID
TRANSACTION_ACTION
TRANSACTION_TYPE_ID
TRANSACTION_TYPE_NAME
PO_HEADER_ID
PO_HEADER_NUM
PO_LINE_ID
PO_LINE_NUM
REQUISITION_ID
REQUISITION_NUM
REQUISITION_LINE_ID
REQUISITION_LINE_NUM
PO_VENDOR_ID
PO_VENDOR_NAME
PO_VENDOR_SITE_ID
PO_VENDOR_SITE_NAME
RECEIPT_NUM
REC_SHIPMENT_NUMBER
RECEIVING_LOCATION_ID
INVENTORY_ITEM_ID
ITEM_DESCRIPTION
REVISION
WAYBILL_AIRBILL
FREIGHT_CODE
NUMBER_OF_CONTAINERS
SUBINVENTORY
LOCATOR_ID
LOCATOR_NAME
REASON_NAME
TRANSACTION_REFERENCE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
SOURCE_TABLE