View: INVBV_MATERIAL_TRANSACTIONS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVBV_MATERIAL_TRANSACTIONS

View Text

SELECT MMT.TRANSACTION_ID
, MMT.TRANSACTION_TYPE_ID
, '_LA:MMT.TRANSACTION_ACTION_ID:MFG_LOOKUPS:MTL_TRANSACTION_ACTION:MEANING'
, MMT.TRANSACTION_SOURCE_TYPE_ID
, MMT.TRANSACTION_SOURCE_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 1
, MMT.TRANSACTION_SOURCE_ID
, NULL) PO_HEADER_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 2
, MMT.TRANSACTION_SOURCE_ID
, 8
, MMT.TRANSACTION_SOURCE_ID
, 12
, MMT.TRANSACTION_SOURCE_ID
, NULL) SALES_ORDER_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 3
, MMT.TRANSACTION_SOURCE_ID
, NULL) ACCOUNT_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 5
, MMT.TRANSACTION_SOURCE_ID
, NULL) WIP_ENTITY_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 6
, MMT.TRANSACTION_SOURCE_ID
, NULL) ACCOUNT_ALIAS_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 7
, MMT.TRANSACTION_SOURCE_ID
, NULL) REQUISITION_HEADER_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 9
, MMT.TRANSACTION_SOURCE_ID
, NULL) CYCLE_COUNT_HEADER_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 10
, MMT.TRANSACTION_SOURCE_ID
, NULL) PHYSICAL_INVENTORY_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 11
, MMT.TRANSACTION_SOURCE_ID
, NULL) COST_UPDATE_ID
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 1
, NULL
, 2
, NULL
, 3
, NULL
, 5
, NULL
, 6
, NULL
, 7
, NULL
, 8
, NULL
, 9
, NULL
, 10
, NULL
, 11
, NULL
, 12
, NULL
, MMT.TRANSACTION_SOURCE_NAME)
, MMT.TRANSACTION_DATE
, MMT.TRANSACTION_QUANTITY
, MMT.TRANSACTION_UOM
, MMT.PRIMARY_QUANTITY
, MMT.INVENTORY_ITEM_ID
, MMT.ORGANIZATION_ID
, MMT.SUBINVENTORY_CODE
, MMT.LOCATOR_ID
, MMT.REVISION
, MMT.TRANSFER_SUBINVENTORY
, MMT.TRANSFER_LOCATOR_ID
, MMT.TRANSFER_ORGANIZATION_ID
, MMT.TRANSFER_TRANSACTION_ID
, MMT.TRANSACTION_SET_ID
, MMT.SHIPMENT_NUMBER
, MMT.WAYBILL_AIRBILL
, MMT.FREIGHT_CODE
, MMT.NUMBER_OF_CONTAINERS
, MMT.REASON_ID
, MMT.TRANSACTION_REFERENCE
, '_LA:DECODE(MMT.COSTED_FLAG
, NULL
, 1
, ''Y''
, 1
, ''N''
, 2
, ''E''
, 3) :MFG_LOOKUPS:INV_YES_NO_ERROR:MEANING'
, '_LA:DECODE ( MMT.SOURCE_PROJECT_ID
, NULL
, DECODE ( MMT.PROJECT_ID
, NULL
, NULL
, DECODE(MMT.PM_COST_COLLECTED
, NULL
, 1
, ''Y''
, 1
, ''N''
, 2
, ''E''
, 3
, 1) )
, DECODE( MMT.PM_COST_COLLECTED
, NULL
, 1
, ''Y''
, 1
, ''N''
, 2
, ''E''
, 3
, 1) ) :MFG_LOOKUPS:INV_YES_NO_ERROR:MEANING'
, MMT.VENDOR_LOT_NUMBER
, MMT.SOURCE_CODE
, MMT.SOURCE_LINE_ID
, MMT.RCV_TRANSACTION_ID
, MMT.MOVE_TRANSACTION_ID
, MMT.COMPLETION_TRANSACTION_ID
, MMT.DEPARTMENT_ID
, MMT.OPERATION_SEQ_NUM
, MMT.SOURCE_PROJECT_ID
, MMT.SOURCE_TASK_ID
, MMT.PROJECT_ID
, MMT.TASK_ID
, MMT.TO_PROJECT_ID
, MMT.TO_TASK_ID
, MMT.EXPENDITURE_TYPE
, MMT.PA_EXPENDITURE_ORG_ID
, MMT.ERROR_CODE
, MMT.ERROR_EXPLANATION
, MMT.CURRENCY_CODE
, MMT.OVERCOMPLETION_TRANSACTION_QTY
, MMT.OVERCOMPLETION_PRIMARY_QTY
, MMT.OVERCOMPLETION_TRANSACTION_ID
, MMT.COMMON_BOM_SEQ_ID
, MMT.COMMON_ROUTING_SEQ_ID
, MMT.ORG_COST_GROUP_ID
, MMT.COST_TYPE_ID
FROM MTL_MATERIAL_TRANSACTIONS MMT
WHERE MMT.TRANSACTION_ACTION_ID NOT IN (24
, 30)
AND (MMT.TRANSACTION_SOURCE_TYPE_ID IN (1
, 2
, 3
, 4
, 5
, 6
, 7
, 8
, 9
, 10
, 11
, 12
, 13) OR MMT.TRANSACTION_SOURCE_TYPE_ID >99)
AND NVL (MMT.LOGICAL_TRANSACTION
, -99) <> 1
AND '_SEC:MMT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns