View: MTL_PENDING_TXNS_MFG_LOTS_V

Product:	INV - Inventory
Description:	The view is based on WIP_ENTITIES, MTL_TRANSACTION_LOTS_TEMP, MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_TXN_SOURCE_TYPES,MTL_PARAMETERS
Implementation/DBA Data:	APPS.MTL_PENDING_TXNS_MFG_LOTS_V

View Text

SELECT WE.GEN_OBJECT_ID OBJECT_ID
, 5 OBJECT_TYPE
, MMTT.TRANSACTION_TEMP_ID TRANSACTION_ID
, MMTT.TRANSACTION_DATE TRANSACTION_DATE
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, MMTT.ORGANIZATION_ID ORGANIZATION_ID
, MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE
, MMTT.LOCATOR_ID LOCATOR_ID
, MTST.TRANSACTION_SOURCE_TYPE_NAME TRANSACTION_SOURCE_NAME
, DECODE(MMTT.TRANSACTION_SOURCE_TYPE_ID
, 13
, MMTT.TRANSACTION_SOURCE_NAME
, INV_OBJECT_GENEALOGY.GETSOURCE(MMTT.ORGANIZATION_ID
, MMTT.TRANSACTION_SOURCE_TYPE_ID
, MMTT.TRANSACTION_SOURCE_ID) ) TRANSACTION_SOURCE
, NULL TRADING_PARTNER
, NULL PROJECT
, NULL TASK
, DECODE(MTLT.TRANSACTION_QUANTITY
, NULL
, MMTT.TRANSACTION_QUANTITY
, MTLT.TRANSACTION_QUANTITY) TRANSACTION_QUANTITY
, MMTT.TRANSACTION_UOM
, DECODE(MTLT.PRIMARY_QUANTITY
, NULL
, MMTT.PRIMARY_QUANTITY
, MTLT.PRIMARY_QUANTITY) PRIMARY_QUANTITY
, DECODE(MTLT.SECONDARY_QUANTITY
, NULL
, MMTT.SECONDARY_TRANSACTION_QUANTITY
, MTLT.SECONDARY_QUANTITY) SECONDARY_QUANTITY
, MTLT.GRADE_CODE GRADE_CODE
, MMTT.CREATED_BY
, MMTT.SOURCE_CODE
, MMTT.SOURCE_LINE_ID
, MMTT.TRANSACTION_TYPE_ID
, WLPN1.LPN_ID
, WLPN2.LPN_ID TRANSFER_LPN_ID
, WLPN3.LPN_ID CONTENT_LPN_ID
, WLPN1.LICENSE_PLATE_NUMBER LPN_NUMBER
, WLPN2.LICENSE_PLATE_NUMBER TRANSFER_LPN_NUMBER
, WLPN3.LICENSE_PLATE_NUMBER CONTENT_LPN_NUMBER
, MMTT.SOURCE_LOT_NUMBER SUPPLIER_LOT_NUMBER
, MTLT.LOT_NUMBER TRANSACTION_LOT_NUMBER
, MMTT.TRANSACTION_STATUS TRANSACTION_STATUS
FROM WIP_ENTITIES WE
, MTL_TRANSACTION_LOTS_TEMP MTLT
, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, MTL_TXN_SOURCE_TYPES MTST
, MTL_PARAMETERS MP
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WMS_LICENSE_PLATE_NUMBERS WLPN2
, WMS_LICENSE_PLATE_NUMBERS WLPN3
WHERE MMTT.TRANSACTION_SOURCE_ID=WE.WIP_ENTITY_ID
AND MMTT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
AND MTLT.TRANSACTION_TEMP_ID (+) = MMTT.TRANSACTION_TEMP_ID
AND MMTT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
AND WE.ENTITY_TYPE IN (9
, 10)
AND MMTT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WLPN1.LPN_ID(+) = MMTT.LPN_ID
AND WLPN2.LPN_ID(+) = MMTT.TRANSFER_LPN_ID
AND WLPN3.LPN_ID(+) = MMTT.CONTENT_LPN_ID

Columns