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: WIP_TXN_COMP_INTERFACE_V

Product:	WIP - Work in Process
Description:	Information from MTL_TRANSACTIONS_INTERFACE
Implementation/DBA Data:	APPS.WIP_TXN_COMP_INTERFACE_V

View Text

SELECT MTI.TRANSACTION_DATE TRANSACTION_DATE
, MTI.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, MTI.REVISION REVISION
, MTI.SUBINVENTORY_CODE SUBINVENTORY_CODE
, MTI.TRANSACTION_UOM TRANSACTION_UOM
, MTI.TRANSACTION_REFERENCE TRANSACTION_REFERENCE
, MTI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MTI.LAST_UPDATED_BY LAST_UPDATED_BY
, MTI.CREATION_DATE CREATION_DATE
, MTI.CREATED_BY CREATED_BY
, MTI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MTI.WIP_ENTITY_TYPE WIP_ENTITY_TYPE
, MTI.ORGANIZATION_ID ORGANIZATION_ID
, MTI.ACCT_PERIOD_ID ACCT_PERIOD_ID
, MTI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MTI.LOCATOR_ID LOCATOR_ID
, MTI.REASON_ID REASON_ID
, MTI.PARENT_ID PARENT_ID
, MTI.SCHEDULE_GROUP SCHEDULE_GROUP
, MTI.TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, MTI.VALIDATION_REQUIRED VALIDATION_REQUIRED
, MTI.PROCESS_FLAG PROCESS_FLAG
, MTI.TRANSACTION_INTERFACE_ID TRANSACTION_INTERFACE_ID
, MTI.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, MTI.TRANSACTION_MODE TRANSACTION_MODE
, MTI.TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID
, MTI.TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, MTI.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, MTI.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, MTI.SOURCE_CODE SOURCE_CODE
, MTI.SOURCE_LINE_ID SOURCE_LINE_ID
, MTI.SOURCE_HEADER_ID SOURCE_HEADER_ID
, MTI.SOURCE_TASK_ID SOURCE_TASK_ID
, MTI.SOURCE_PROJECT_ID SOURCE_PROJECT_ID
, MTI.PROJECT_ID PROJECT_ID
, MTI.TASK_ID TASK_ID
, MTI.FLOW_SCHEDULE FLOW_SCHEDULE
, MTI.PRIMARY_QUANTITY PRIMARY_QUANTITY
, MSIV.CONCATENATED_SEGMENTS COMPONENT_ITEM
, NVL(MSI.LOT_CONTROL_CODE
, 1) LOT_CONTROL
, MTI.COMPLETION_TRANSACTION_ID
, MTI.TRANSACTION_BATCH_SEQ
, MTI.TRANSACTION_BATCH_ID
FROM MTL_TRANSACTIONS_INTERFACE MTI
, MTL_SYSTEM_ITEMS MSI
, MTL_SYSTEM_ITEMS_KFV MSIV
WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
AND MSIV.ORGANIZATION_ID = MTI.ORGANIZATION_ID
AND MSIV.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID ORDER BY OPERATION_SEQ_NUM

Columns

Name
TRANSACTION_DATE
OPERATION_SEQ_NUM
REVISION
SUBINVENTORY_CODE
TRANSACTION_UOM
TRANSACTION_REFERENCE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
WIP_ENTITY_TYPE
ORGANIZATION_ID
ACCT_PERIOD_ID
INVENTORY_ITEM_ID
LOCATOR_ID
REASON_ID
PARENT_ID
SCHEDULE_GROUP
TRANSACTION_QUANTITY
VALIDATION_REQUIRED
PROCESS_FLAG
TRANSACTION_INTERFACE_ID
TRANSACTION_HEADER_ID
TRANSACTION_MODE
TRANSACTION_SOURCE_ID
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_ACTION_ID
TRANSACTION_TYPE_ID
SOURCE_CODE
SOURCE_LINE_ID
SOURCE_HEADER_ID
SOURCE_TASK_ID
SOURCE_PROJECT_ID
PROJECT_ID
TASK_ID
FLOW_SCHEDULE
PRIMARY_QUANTITY
COMPONENT_ITEM
LOT_CONTROL
COMPLETION_TRANSACTION_ID
TRANSACTION_BATCH_SEQ
TRANSACTION_BATCH_ID