VIEW: APPS.WMS_STRATEGY_MAT_TXN_TMP_V

Source

View Text - Preformatted

SELECT 2 ,mtrl.LINE_ID ,mtrl.HEADER_ID ,mtrl.LINE_NUMBER ,mtrl.INVENTORY_ITEM_ID ,mtrl.REVISION ,mtrl.ORGANIZATION_ID ,mtrl.FROM_SUBINVENTORY_CODE ,mtrl.FROM_LOCATOR_ID ,DECODE(mtt.TRANSACTION_ACTION_ID,3,TO_ORGANIZATION_ID,ORGANIZATION_ID) ,mtrl.TO_SUBINVENTORY_CODE ,mtrl.TO_LOCATOR_ID ,mtrl.TO_ACCOUNT_ID ,mtrl.LOT_NUMBER ,mtrl.UOM_CODE ,mtrl.QUANTITY-NVL(mtrl.QUANTITY_DETAILED,0) ,mtrl.DATE_REQUIRED ,mtrl.REASON_ID ,mtrl.REFERENCE ,mtrl.REFERENCE_TYPE_CODE ,mtrl.REFERENCE_ID ,mtrl.PROJECT_ID ,mtrl.TASK_ID ,mtrl.TRANSACTION_HEADER_ID ,mtrl.LINE_STATUS ,mtrl.STATUS_DATE ,mtrl.LAST_UPDATED_BY ,mtrl.LAST_UPDATE_LOGIN ,mtrl.LAST_UPDATE_DATE ,mtrl.CREATED_BY ,mtrl.CREATION_DATE ,mtrl.REQUEST_ID ,mtrl.PROGRAM_APPLICATION_ID ,mtrl.PROGRAM_ID ,mtrl.PROGRAM_UPDATE_DATE ,mtrl.ATTRIBUTE1 ,mtrl.ATTRIBUTE2 ,mtrl.ATTRIBUTE3 ,mtrl.ATTRIBUTE4 ,mtrl.ATTRIBUTE5 ,mtrl.ATTRIBUTE6 ,mtrl.ATTRIBUTE7 ,mtrl.ATTRIBUTE8 ,mtrl.ATTRIBUTE9 ,mtrl.ATTRIBUTE10 ,mtrl.ATTRIBUTE11 ,mtrl.ATTRIBUTE12 ,mtrl.ATTRIBUTE13 ,mtrl.ATTRIBUTE14 ,mtrl.ATTRIBUTE15 ,mtrl.ATTRIBUTE_CATEGORY ,mtrl.PRIMARY_QUANTITY ,mtrl.TRANSACTION_TYPE_ID ,mtrl.TRANSACTION_SOURCE_TYPE_ID ,mtt.TRANSACTION_ACTION_ID ,wtct.TXN_SOURCE_ID ,wtct.TXN_SOURCE_LINE_ID ,wtct.TXN_SOURCE_NAME ,wtct.TXN_SOURCE_LINE_DETAIL ,wtct.FREIGHT_CARRIER_CODE ,wtct.CUSTOMER_ID FROM MTL_TXN_REQUEST_LINES mtrl ,MTL_TRANSACTION_TYPES mtt ,WMS_TXN_CONTEXT_TEMP wtct WHERE mtrl.TRANSACTION_TYPE_ID = mtt.TRANSACTION_TYPE_ID AND mtt.TRANSACTION_ACTION_ID in (1,2,3,21,28,34) AND mtrl.LINE_ID = wtct.LINE_ID UNION ALL SELECT 1 ,mtrl.LINE_ID ,mtrl.HEADER_ID ,mtrl.LINE_NUMBER ,mtrl.INVENTORY_ITEM_ID ,mtrl.REVISION ,decode(mtt.transaction_action_id,3,mtrl.to_organization_id, mtrl.organization_id) ,mtrl.FROM_SUBINVENTORY_CODE ,mtrl.FROM_LOCATOR_ID ,mtrl.organization_id ,mtrl.TO_SUBINVENTORY_CODE ,mtrl.TO_LOCATOR_ID ,mtrl.TO_ACCOUNT_ID ,mtrl.LOT_NUMBER ,mtrl.UOM_CODE ,mtrl.QUANTITY-NVL(mtrl.QUANTITY_DETAILED,0) ,mtrl.DATE_REQUIRED ,mtrl.REASON_ID ,mtrl.REFERENCE ,mtrl.REFERENCE_TYPE_CODE ,mtrl.REFERENCE_ID ,mtrl.PROJECT_ID ,mtrl.TASK_ID ,mtrl.TRANSACTION_HEADER_ID ,mtrl.LINE_STATUS ,mtrl.STATUS_DATE ,mtrl.LAST_UPDATED_BY ,mtrl.LAST_UPDATE_LOGIN ,mtrl.LAST_UPDATE_DATE ,mtrl.CREATED_BY ,mtrl.CREATION_DATE ,mtrl.REQUEST_ID ,mtrl.PROGRAM_APPLICATION_ID ,mtrl.PROGRAM_ID ,mtrl.PROGRAM_UPDATE_DATE ,mtrl.ATTRIBUTE1 ,mtrl.ATTRIBUTE2 ,mtrl.ATTRIBUTE3 ,mtrl.ATTRIBUTE4 ,mtrl.ATTRIBUTE5 ,mtrl.ATTRIBUTE6 ,mtrl.ATTRIBUTE7 ,mtrl.ATTRIBUTE8 ,mtrl.ATTRIBUTE9 ,mtrl.ATTRIBUTE10 ,mtrl.ATTRIBUTE11 ,mtrl.ATTRIBUTE12 ,mtrl.ATTRIBUTE13 ,mtrl.ATTRIBUTE14 ,mtrl.ATTRIBUTE15 ,mtrl.ATTRIBUTE_CATEGORY ,mtrl.PRIMARY_QUANTITY ,mtrl.TRANSACTION_TYPE_ID ,mtrl.TRANSACTION_SOURCE_TYPE_ID ,mtt.TRANSACTION_ACTION_ID ,wtct.TXN_SOURCE_ID ,wtct.TXN_SOURCE_LINE_ID ,wtct.TXN_SOURCE_NAME ,wtct.TXN_SOURCE_LINE_DETAIL ,wtct.FREIGHT_CARRIER_CODE ,wtct.CUSTOMER_ID FROM MTL_TXN_REQUEST_LINES mtrl ,MTL_TRANSACTION_TYPES mtt ,WMS_TXN_CONTEXT_TEMP wtct WHERE mtrl.TRANSACTION_TYPE_ID = mtt.TRANSACTION_TYPE_ID AND mtt.TRANSACTION_ACTION_ID in (2,3,12,27,28,31,33) AND mtrl.LINE_ID = wtct.LINE_ID

View Text - HTML Formatted

SELECT 2
, MTRL.LINE_ID
, MTRL.HEADER_ID
, MTRL.LINE_NUMBER
, MTRL.INVENTORY_ITEM_ID
, MTRL.REVISION
, MTRL.ORGANIZATION_ID
, MTRL.FROM_SUBINVENTORY_CODE
, MTRL.FROM_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 3
, TO_ORGANIZATION_ID
, ORGANIZATION_ID)
, MTRL.TO_SUBINVENTORY_CODE
, MTRL.TO_LOCATOR_ID
, MTRL.TO_ACCOUNT_ID
, MTRL.LOT_NUMBER
, MTRL.UOM_CODE
, MTRL.QUANTITY-NVL(MTRL.QUANTITY_DETAILED
, 0)
, MTRL.DATE_REQUIRED
, MTRL.REASON_ID
, MTRL.REFERENCE
, MTRL.REFERENCE_TYPE_CODE
, MTRL.REFERENCE_ID
, MTRL.PROJECT_ID
, MTRL.TASK_ID
, MTRL.TRANSACTION_HEADER_ID
, MTRL.LINE_STATUS
, MTRL.STATUS_DATE
, MTRL.LAST_UPDATED_BY
, MTRL.LAST_UPDATE_LOGIN
, MTRL.LAST_UPDATE_DATE
, MTRL.CREATED_BY
, MTRL.CREATION_DATE
, MTRL.REQUEST_ID
, MTRL.PROGRAM_APPLICATION_ID
, MTRL.PROGRAM_ID
, MTRL.PROGRAM_UPDATE_DATE
, MTRL.ATTRIBUTE1
, MTRL.ATTRIBUTE2
, MTRL.ATTRIBUTE3
, MTRL.ATTRIBUTE4
, MTRL.ATTRIBUTE5
, MTRL.ATTRIBUTE6
, MTRL.ATTRIBUTE7
, MTRL.ATTRIBUTE8
, MTRL.ATTRIBUTE9
, MTRL.ATTRIBUTE10
, MTRL.ATTRIBUTE11
, MTRL.ATTRIBUTE12
, MTRL.ATTRIBUTE13
, MTRL.ATTRIBUTE14
, MTRL.ATTRIBUTE15
, MTRL.ATTRIBUTE_CATEGORY
, MTRL.PRIMARY_QUANTITY
, MTRL.TRANSACTION_TYPE_ID
, MTRL.TRANSACTION_SOURCE_TYPE_ID
, MTT.TRANSACTION_ACTION_ID
, WTCT.TXN_SOURCE_ID
, WTCT.TXN_SOURCE_LINE_ID
, WTCT.TXN_SOURCE_NAME
, WTCT.TXN_SOURCE_LINE_DETAIL
, WTCT.FREIGHT_CARRIER_CODE
, WTCT.CUSTOMER_ID
FROM MTL_TXN_REQUEST_LINES MTRL
, MTL_TRANSACTION_TYPES MTT
, WMS_TXN_CONTEXT_TEMP WTCT
WHERE MTRL.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND MTT.TRANSACTION_ACTION_ID IN (1
, 2
, 3
, 21
, 28
, 34)
AND MTRL.LINE_ID = WTCT.LINE_ID UNION ALL SELECT 1
, MTRL.LINE_ID
, MTRL.HEADER_ID
, MTRL.LINE_NUMBER
, MTRL.INVENTORY_ITEM_ID
, MTRL.REVISION
, DECODE(MTT.TRANSACTION_ACTION_ID
, 3
, MTRL.TO_ORGANIZATION_ID
, MTRL.ORGANIZATION_ID)
, MTRL.FROM_SUBINVENTORY_CODE
, MTRL.FROM_LOCATOR_ID
, MTRL.ORGANIZATION_ID
, MTRL.TO_SUBINVENTORY_CODE
, MTRL.TO_LOCATOR_ID
, MTRL.TO_ACCOUNT_ID
, MTRL.LOT_NUMBER
, MTRL.UOM_CODE
, MTRL.QUANTITY-NVL(MTRL.QUANTITY_DETAILED
, 0)
, MTRL.DATE_REQUIRED
, MTRL.REASON_ID
, MTRL.REFERENCE
, MTRL.REFERENCE_TYPE_CODE
, MTRL.REFERENCE_ID
, MTRL.PROJECT_ID
, MTRL.TASK_ID
, MTRL.TRANSACTION_HEADER_ID
, MTRL.LINE_STATUS
, MTRL.STATUS_DATE
, MTRL.LAST_UPDATED_BY
, MTRL.LAST_UPDATE_LOGIN
, MTRL.LAST_UPDATE_DATE
, MTRL.CREATED_BY
, MTRL.CREATION_DATE
, MTRL.REQUEST_ID
, MTRL.PROGRAM_APPLICATION_ID
, MTRL.PROGRAM_ID
, MTRL.PROGRAM_UPDATE_DATE
, MTRL.ATTRIBUTE1
, MTRL.ATTRIBUTE2
, MTRL.ATTRIBUTE3
, MTRL.ATTRIBUTE4
, MTRL.ATTRIBUTE5
, MTRL.ATTRIBUTE6
, MTRL.ATTRIBUTE7
, MTRL.ATTRIBUTE8
, MTRL.ATTRIBUTE9
, MTRL.ATTRIBUTE10
, MTRL.ATTRIBUTE11
, MTRL.ATTRIBUTE12
, MTRL.ATTRIBUTE13
, MTRL.ATTRIBUTE14
, MTRL.ATTRIBUTE15
, MTRL.ATTRIBUTE_CATEGORY
, MTRL.PRIMARY_QUANTITY
, MTRL.TRANSACTION_TYPE_ID
, MTRL.TRANSACTION_SOURCE_TYPE_ID
, MTT.TRANSACTION_ACTION_ID
, WTCT.TXN_SOURCE_ID
, WTCT.TXN_SOURCE_LINE_ID
, WTCT.TXN_SOURCE_NAME
, WTCT.TXN_SOURCE_LINE_DETAIL
, WTCT.FREIGHT_CARRIER_CODE
, WTCT.CUSTOMER_ID
FROM MTL_TXN_REQUEST_LINES MTRL
, MTL_TRANSACTION_TYPES MTT
, WMS_TXN_CONTEXT_TEMP WTCT
WHERE MTRL.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND MTT.TRANSACTION_ACTION_ID IN (2
, 3
, 12
, 27
, 28
, 31
, 33)
AND MTRL.LINE_ID = WTCT.LINE_ID