Product: | WSM - Shop Floor Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSM_INV_TXNS_WIP_LOTS_V |
SELECT WE.GEN_OBJECT_ID OBJECT_ID
, 5 OBJECT_TYPE
, MMT.ORGANIZATION_ID ORGANIZATION_ID
, MMT.TRANSACTION_ID TRANSACTION_ID
, MMT.TRANSACTION_DATE TRANSACTION_DATE
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, MTST.TRANSACTION_SOURCE_TYPE_NAME TRANSACTION_SOURCE_TYPE_NAME
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 13
, MMT.TRANSACTION_SOURCE_NAME
, INV_OBJECT_GENEALOGY.GETSOURCE(MMT.ORGANIZATION_ID
, MMT.TRANSACTION_SOURCE_TYPE_ID
, MMT.TRANSACTION_SOURCE_ID)) TRANSACTION_SOURCE
, NULL TRADING_PARTNER
, NULL PROJECT
, NULL TASK
, MMT.TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, MMT.TRANSACTION_UOM
, MMT.PRIMARY_QUANTITY PRIMARY_QUANTITY
, MMT.CREATED_BY
, MMT.SOURCE_CODE
, MMT.SOURCE_LINE_ID
, MMT.TRANSACTION_TYPE_ID
, WLPN1.LICENSE_PLATE_NUMBER LPN_NUMBER
, WLPN2.LICENSE_PLATE_NUMBER TRANSFER_LPN_NUMBER
, WLPN3.LICENSE_PLATE_NUMBER CONTENT_LPN_NUMBER
FROM WIP_ENTITIES WE
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TXN_SOURCE_TYPES MTST
, MTL_PARAMETERS MP
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WMS_LICENSE_PLATE_NUMBERS WLPN2
, WMS_LICENSE_PLATE_NUMBERS WLPN3
WHERE MMT.TRANSACTION_SOURCE_ID=WE.WIP_ENTITY_ID
AND MMT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
AND MMT.TRANSACTION_ACTION_ID IN (1
, 27
, 30
, 31
, 32
, 33
, 34 )
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
AND MMT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WLPN1.LPN_ID(+) = MMT.LPN_ID
AND WLPN2.LPN_ID(+) = MMT.TRANSFER_LPN_ID
AND WLPN3.LPN_ID(+) = MMT.CONTENT_LPN_ID