VIEW: APPS.WIP_TXN_COMP_INTERFACE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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