VIEW: APPS.CSP_PICK_TRANSACTIONS_V

Source

View Text - Preformatted

SELECT mmtt.rowid , mmtt.TRANSACTION_HEADER_ID, mmtt.TRANSACTION_TEMP_ID, mmtt.SOURCE_CODE, mmtt.SOURCE_LINE_ID, mmtt.TRANSACTION_MODE, mmtt.LOCK_FLAG, mmtt.LAST_UPDATE_DATE, mmtt.LAST_UPDATED_BY, mmtt.CREATION_DATE, mmtt.CREATED_BY, mmtt.LAST_UPDATE_LOGIN, mmtt.REQUEST_ID, mmtt.PROGRAM_APPLICATION_ID, mmtt.PROGRAM_ID, mmtt.PROGRAM_UPDATE_DATE, mmtt.INVENTORY_ITEM_ID, mmtt.REVISION, mmtt.ORGANIZATION_ID, mmtt.SUBINVENTORY_CODE, mmtt.LOCATOR_ID, mmtt.TRANSACTION_QUANTITY, mmtt.PRIMARY_QUANTITY, mmtt.TRANSACTION_UOM, mmtt.TRANSACTION_COST, mmtt.TRANSACTION_TYPE_ID, mmtt.TRANSACTION_ACTION_ID, mmtt.TRANSACTION_SOURCE_TYPE_ID, mmtt.TRANSACTION_SOURCE_ID, mmtt.TRANSACTION_SOURCE_NAME, mmtt.TRANSACTION_DATE, mmtt.ACCT_PERIOD_ID, mmtt.DISTRIBUTION_ACCOUNT_ID, mmtt.TRANSACTION_REFERENCE, mmtt.REQUISITION_LINE_ID, mmtt.REQUISITION_DISTRIBUTION_ID, mmtt.REASON_ID, mmtt.LOT_NUMBER, mmtt.LOT_EXPIRATION_DATE, mmtt.SERIAL_NUMBER, mmtt.RECEIVING_DOCUMENT, mmtt.DEMAND_ID, mmtt.RCV_TRANSACTION_ID, mmtt.MOVE_TRANSACTION_ID, mmtt.COMPLETION_TRANSACTION_ID, mmtt.WIP_ENTITY_TYPE, mmtt.SCHEDULE_ID, mmtt.REPETITIVE_LINE_ID, mmtt.EMPLOYEE_CODE, mmtt.PRIMARY_SWITCH, mmtt.SCHEDULE_UPDATE_CODE, mmtt.SETUP_TEARDOWN_CODE, mmtt.ITEM_ORDERING, mmtt.NEGATIVE_REQ_FLAG, mmtt.OPERATION_SEQ_NUM, mmtt.PICKING_LINE_ID, mmtt.TRX_SOURCE_LINE_ID, mmtt.TRX_SOURCE_DELIVERY_ID, mmtt.PHYSICAL_ADJUSTMENT_ID, mmtt.CYCLE_COUNT_ID, mmtt.RMA_LINE_ID, mmtt.CUSTOMER_SHIP_ID, mmtt.CURRENCY_CODE, mmtt.CURRENCY_CONVERSION_RATE, mmtt.CURRENCY_CONVERSION_TYPE, mmtt.CURRENCY_CONVERSION_DATE, mmtt.USSGL_TRANSACTION_CODE, mmtt.VENDOR_LOT_NUMBER, mmtt.ENCUMBRANCE_ACCOUNT, mmtt.ENCUMBRANCE_AMOUNT, mmtt.SHIP_TO_LOCATION, mmtt.SHIPMENT_NUMBER, mmtt.TRANSFER_COST, mmtt.TRANSPORTATION_COST, mmtt.TRANSPORTATION_ACCOUNT, mmtt.FREIGHT_CODE, mmtt.CONTAINERS, mmtt.WAYBILL_AIRBILL, mmtt.EXPECTED_ARRIVAL_DATE, mmtt.TRANSFER_SUBINVENTORY, mmtt.TRANSFER_ORGANIZATION, mmtt.TRANSFER_TO_LOCATION, mmtt.NEW_AVERAGE_COST, mmtt.VALUE_CHANGE, mmtt.PERCENTAGE_CHANGE, mmtt.MATERIAL_ALLOCATION_TEMP_ID, mmtt.DEMAND_SOURCE_HEADER_ID, mmtt.DEMAND_SOURCE_LINE, mmtt.DEMAND_SOURCE_DELIVERY, mmtt.ITEM_SEGMENTS, mmtt.ITEM_DESCRIPTION, mmtt.ITEM_TRX_ENABLED_FLAG, mmtt.ITEM_LOCATION_CONTROL_CODE, mmtt.ITEM_RESTRICT_SUBINV_CODE, mmtt.ITEM_RESTRICT_LOCATORS_CODE, mmtt.ITEM_REVISION_QTY_CONTROL_CODE, mmtt.ITEM_PRIMARY_UOM_CODE, mmtt.ITEM_UOM_CLASS, mmtt.ITEM_SHELF_LIFE_CODE, mmtt.ITEM_SHELF_LIFE_DAYS, mmtt.ITEM_LOT_CONTROL_CODE, mmtt.ITEM_SERIAL_CONTROL_CODE, mmtt.ITEM_INVENTORY_ASSET_FLAG, mmtt.ALLOWED_UNITS_LOOKUP_CODE, mmtt.DEPARTMENT_ID, mmtt.DEPARTMENT_CODE, mmtt.WIP_SUPPLY_TYPE, mmtt.SUPPLY_SUBINVENTORY, mmtt.SUPPLY_LOCATOR_ID, mmtt.VALID_SUBINVENTORY_FLAG, mmtt.VALID_LOCATOR_FLAG, mmtt.LOCATOR_SEGMENTS, mmtt.CURRENT_LOCATOR_CONTROL_CODE, mmtt.NUMBER_OF_LOTS_ENTERED, mmtt.WIP_COMMIT_FLAG, mmtt.NEXT_LOT_NUMBER, mmtt.LOT_ALPHA_PREFIX, mmtt.NEXT_SERIAL_NUMBER, mmtt.SERIAL_ALPHA_PREFIX, mmtt.SHIPPABLE_FLAG, mmtt.POSTING_FLAG, mmtt.REQUIRED_FLAG, mmtt.PROCESS_FLAG, mmtt.ERROR_CODE, mmtt.ERROR_EXPLANATION, mmtt.ATTRIBUTE_CATEGORY, mmtt.ATTRIBUTE1, mmtt.ATTRIBUTE2, mmtt.ATTRIBUTE3, mmtt.ATTRIBUTE4, mmtt.ATTRIBUTE5, mmtt.ATTRIBUTE6, mmtt.ATTRIBUTE7, mmtt.ATTRIBUTE8, mmtt.ATTRIBUTE9, mmtt.ATTRIBUTE10, mmtt.ATTRIBUTE11, mmtt.ATTRIBUTE12, mmtt.ATTRIBUTE13, mmtt.ATTRIBUTE14, mmtt.ATTRIBUTE15, mmtt.MOVEMENT_ID, mmtt.RESERVATION_QUANTITY, mmtt.SHIPPED_QUANTITY, mmtt.TRANSACTION_LINE_NUMBER, mmtt.TASK_ID, mmtt.TO_TASK_ID, mmtt.SOURCE_TASK_ID, mmtt.PROJECT_ID, mmtt.SOURCE_PROJECT_ID, mmtt.PA_EXPENDITURE_ORG_ID, mmtt.TO_PROJECT_ID, mmtt.EXPENDITURE_TYPE, mmtt.FINAL_COMPLETION_FLAG, mmtt.TRANSFER_PERCENTAGE, mmtt.TRANSACTION_SEQUENCE_ID, mmtt.MATERIAL_ACCOUNT, mmtt.MATERIAL_OVERHEAD_ACCOUNT, mmtt.RESOURCE_ACCOUNT, mmtt.OUTSIDE_PROCESSING_ACCOUNT, mmtt.OVERHEAD_ACCOUNT, mmtt.FLOW_SCHEDULE, mmtt.COST_GROUP_ID, mmtt.DEMAND_CLASS, mmtt.QA_COLLECTION_ID, mmtt.KANBAN_CARD_ID, mmtt.OVERCOMPLETION_TRANSACTION_ID, mmtt.OVERCOMPLETION_PRIMARY_QTY, mmtt.OVERCOMPLETION_TRANSACTION_QTY, mmtt.END_ITEM_UNIT_NUMBER, mmtt.SCHEDULED_PAYBACK_DATE, mmtt.LINE_TYPE_CODE , mmtt.PARENT_TRANSACTION_TEMP_ID, mmtt.PUT_AWAY_STRATEGY_ID, mmtt.PUT_AWAY_RULE_ID, mmtt.PICK_STRATEGY_ID, mmtt.PICK_RULE_ID, mmtt.COMMON_BOM_SEQ_ID, mmtt.COMMON_ROUTING_SEQ_ID, mmtt.COST_TYPE_ID , mmtt.ORG_COST_GROUP_ID, mmtt.MOVE_ORDER_LINE_ID, mmtt.TASK_GROUP_ID, mmtt.PICK_SLIP_NUMBER, mmtt.RESERVATION_ID, mmtt.TRANSACTION_STATUS, mss.locator_type, mss1.locator_type, cpll.picklist_line_id, cpll.picklist_line_number, cpll.picklist_header_id, cpll.uom_code, cpll.quantity_picked, mmtt.standard_operation_id, mmtt.task_priority, mmtt.wms_task_type, mmtt.parent_line_id FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT, MTL_SECONDARY_INVENTORIES mss, mtl_secondary_inventories mss1, CSP_PICKLIST_LINES CPLL, CSP_PICKLIST_HEADERS CPLH WHERE mmtt.transaction_temp_id = cpll.transaction_temp_id AND mss.secondary_inventory_name(+) = mmtt.subinventory_code AND mss.organization_id(+) = mmtt.organization_id AND mss1.secondary_inventory_name(+) = mmtt.transfer_subinventory AND mss1.organization_id(+) = mmtt.organization_id AND cpll.picklist_header_id = cplh.picklist_header_id AND mmtt.organization_id = cplh.organization_id

View Text - HTML Formatted

SELECT MMTT.ROWID
, MMTT.TRANSACTION_HEADER_ID
, MMTT.TRANSACTION_TEMP_ID
, MMTT.SOURCE_CODE
, MMTT.SOURCE_LINE_ID
, MMTT.TRANSACTION_MODE
, MMTT.LOCK_FLAG
, MMTT.LAST_UPDATE_DATE
, MMTT.LAST_UPDATED_BY
, MMTT.CREATION_DATE
, MMTT.CREATED_BY
, MMTT.LAST_UPDATE_LOGIN
, MMTT.REQUEST_ID
, MMTT.PROGRAM_APPLICATION_ID
, MMTT.PROGRAM_ID
, MMTT.PROGRAM_UPDATE_DATE
, MMTT.INVENTORY_ITEM_ID
, MMTT.REVISION
, MMTT.ORGANIZATION_ID
, MMTT.SUBINVENTORY_CODE
, MMTT.LOCATOR_ID
, MMTT.TRANSACTION_QUANTITY
, MMTT.PRIMARY_QUANTITY
, MMTT.TRANSACTION_UOM
, MMTT.TRANSACTION_COST
, MMTT.TRANSACTION_TYPE_ID
, MMTT.TRANSACTION_ACTION_ID
, MMTT.TRANSACTION_SOURCE_TYPE_ID
, MMTT.TRANSACTION_SOURCE_ID
, MMTT.TRANSACTION_SOURCE_NAME
, MMTT.TRANSACTION_DATE
, MMTT.ACCT_PERIOD_ID
, MMTT.DISTRIBUTION_ACCOUNT_ID
, MMTT.TRANSACTION_REFERENCE
, MMTT.REQUISITION_LINE_ID
, MMTT.REQUISITION_DISTRIBUTION_ID
, MMTT.REASON_ID
, MMTT.LOT_NUMBER
, MMTT.LOT_EXPIRATION_DATE
, MMTT.SERIAL_NUMBER
, MMTT.RECEIVING_DOCUMENT
, MMTT.DEMAND_ID
, MMTT.RCV_TRANSACTION_ID
, MMTT.MOVE_TRANSACTION_ID
, MMTT.COMPLETION_TRANSACTION_ID
, MMTT.WIP_ENTITY_TYPE
, MMTT.SCHEDULE_ID
, MMTT.REPETITIVE_LINE_ID
, MMTT.EMPLOYEE_CODE
, MMTT.PRIMARY_SWITCH
, MMTT.SCHEDULE_UPDATE_CODE
, MMTT.SETUP_TEARDOWN_CODE
, MMTT.ITEM_ORDERING
, MMTT.NEGATIVE_REQ_FLAG
, MMTT.OPERATION_SEQ_NUM
, MMTT.PICKING_LINE_ID
, MMTT.TRX_SOURCE_LINE_ID
, MMTT.TRX_SOURCE_DELIVERY_ID
, MMTT.PHYSICAL_ADJUSTMENT_ID
, MMTT.CYCLE_COUNT_ID
, MMTT.RMA_LINE_ID
, MMTT.CUSTOMER_SHIP_ID
, MMTT.CURRENCY_CODE
, MMTT.CURRENCY_CONVERSION_RATE
, MMTT.CURRENCY_CONVERSION_TYPE
, MMTT.CURRENCY_CONVERSION_DATE
, MMTT.USSGL_TRANSACTION_CODE
, MMTT.VENDOR_LOT_NUMBER
, MMTT.ENCUMBRANCE_ACCOUNT
, MMTT.ENCUMBRANCE_AMOUNT
, MMTT.SHIP_TO_LOCATION
, MMTT.SHIPMENT_NUMBER
, MMTT.TRANSFER_COST
, MMTT.TRANSPORTATION_COST
, MMTT.TRANSPORTATION_ACCOUNT
, MMTT.FREIGHT_CODE
, MMTT.CONTAINERS
, MMTT.WAYBILL_AIRBILL
, MMTT.EXPECTED_ARRIVAL_DATE
, MMTT.TRANSFER_SUBINVENTORY
, MMTT.TRANSFER_ORGANIZATION
, MMTT.TRANSFER_TO_LOCATION
, MMTT.NEW_AVERAGE_COST
, MMTT.VALUE_CHANGE
, MMTT.PERCENTAGE_CHANGE
, MMTT.MATERIAL_ALLOCATION_TEMP_ID
, MMTT.DEMAND_SOURCE_HEADER_ID
, MMTT.DEMAND_SOURCE_LINE
, MMTT.DEMAND_SOURCE_DELIVERY
, MMTT.ITEM_SEGMENTS
, MMTT.ITEM_DESCRIPTION
, MMTT.ITEM_TRX_ENABLED_FLAG
, MMTT.ITEM_LOCATION_CONTROL_CODE
, MMTT.ITEM_RESTRICT_SUBINV_CODE
, MMTT.ITEM_RESTRICT_LOCATORS_CODE
, MMTT.ITEM_REVISION_QTY_CONTROL_CODE
, MMTT.ITEM_PRIMARY_UOM_CODE
, MMTT.ITEM_UOM_CLASS
, MMTT.ITEM_SHELF_LIFE_CODE
, MMTT.ITEM_SHELF_LIFE_DAYS
, MMTT.ITEM_LOT_CONTROL_CODE
, MMTT.ITEM_SERIAL_CONTROL_CODE
, MMTT.ITEM_INVENTORY_ASSET_FLAG
, MMTT.ALLOWED_UNITS_LOOKUP_CODE
, MMTT.DEPARTMENT_ID
, MMTT.DEPARTMENT_CODE
, MMTT.WIP_SUPPLY_TYPE
, MMTT.SUPPLY_SUBINVENTORY
, MMTT.SUPPLY_LOCATOR_ID
, MMTT.VALID_SUBINVENTORY_FLAG
, MMTT.VALID_LOCATOR_FLAG
, MMTT.LOCATOR_SEGMENTS
, MMTT.CURRENT_LOCATOR_CONTROL_CODE
, MMTT.NUMBER_OF_LOTS_ENTERED
, MMTT.WIP_COMMIT_FLAG
, MMTT.NEXT_LOT_NUMBER
, MMTT.LOT_ALPHA_PREFIX
, MMTT.NEXT_SERIAL_NUMBER
, MMTT.SERIAL_ALPHA_PREFIX
, MMTT.SHIPPABLE_FLAG
, MMTT.POSTING_FLAG
, MMTT.REQUIRED_FLAG
, MMTT.PROCESS_FLAG
, MMTT.ERROR_CODE
, MMTT.ERROR_EXPLANATION
, MMTT.ATTRIBUTE_CATEGORY
, MMTT.ATTRIBUTE1
, MMTT.ATTRIBUTE2
, MMTT.ATTRIBUTE3
, MMTT.ATTRIBUTE4
, MMTT.ATTRIBUTE5
, MMTT.ATTRIBUTE6
, MMTT.ATTRIBUTE7
, MMTT.ATTRIBUTE8
, MMTT.ATTRIBUTE9
, MMTT.ATTRIBUTE10
, MMTT.ATTRIBUTE11
, MMTT.ATTRIBUTE12
, MMTT.ATTRIBUTE13
, MMTT.ATTRIBUTE14
, MMTT.ATTRIBUTE15
, MMTT.MOVEMENT_ID
, MMTT.RESERVATION_QUANTITY
, MMTT.SHIPPED_QUANTITY
, MMTT.TRANSACTION_LINE_NUMBER
, MMTT.TASK_ID
, MMTT.TO_TASK_ID
, MMTT.SOURCE_TASK_ID
, MMTT.PROJECT_ID
, MMTT.SOURCE_PROJECT_ID
, MMTT.PA_EXPENDITURE_ORG_ID
, MMTT.TO_PROJECT_ID
, MMTT.EXPENDITURE_TYPE
, MMTT.FINAL_COMPLETION_FLAG
, MMTT.TRANSFER_PERCENTAGE
, MMTT.TRANSACTION_SEQUENCE_ID
, MMTT.MATERIAL_ACCOUNT
, MMTT.MATERIAL_OVERHEAD_ACCOUNT
, MMTT.RESOURCE_ACCOUNT
, MMTT.OUTSIDE_PROCESSING_ACCOUNT
, MMTT.OVERHEAD_ACCOUNT
, MMTT.FLOW_SCHEDULE
, MMTT.COST_GROUP_ID
, MMTT.DEMAND_CLASS
, MMTT.QA_COLLECTION_ID
, MMTT.KANBAN_CARD_ID
, MMTT.OVERCOMPLETION_TRANSACTION_ID
, MMTT.OVERCOMPLETION_PRIMARY_QTY
, MMTT.OVERCOMPLETION_TRANSACTION_QTY
, MMTT.END_ITEM_UNIT_NUMBER
, MMTT.SCHEDULED_PAYBACK_DATE
, MMTT.LINE_TYPE_CODE
, MMTT.PARENT_TRANSACTION_TEMP_ID
, MMTT.PUT_AWAY_STRATEGY_ID
, MMTT.PUT_AWAY_RULE_ID
, MMTT.PICK_STRATEGY_ID
, MMTT.PICK_RULE_ID
, MMTT.COMMON_BOM_SEQ_ID
, MMTT.COMMON_ROUTING_SEQ_ID
, MMTT.COST_TYPE_ID
, MMTT.ORG_COST_GROUP_ID
, MMTT.MOVE_ORDER_LINE_ID
, MMTT.TASK_GROUP_ID
, MMTT.PICK_SLIP_NUMBER
, MMTT.RESERVATION_ID
, MMTT.TRANSACTION_STATUS
, MSS.LOCATOR_TYPE
, MSS1.LOCATOR_TYPE
, CPLL.PICKLIST_LINE_ID
, CPLL.PICKLIST_LINE_NUMBER
, CPLL.PICKLIST_HEADER_ID
, CPLL.UOM_CODE
, CPLL.QUANTITY_PICKED
, MMTT.STANDARD_OPERATION_ID
, MMTT.TASK_PRIORITY
, MMTT.WMS_TASK_TYPE
, MMTT.PARENT_LINE_ID
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, MTL_SECONDARY_INVENTORIES MSS
, MTL_SECONDARY_INVENTORIES MSS1
, CSP_PICKLIST_LINES CPLL
, CSP_PICKLIST_HEADERS CPLH
WHERE MMTT.TRANSACTION_TEMP_ID = CPLL.TRANSACTION_TEMP_ID
AND MSS.SECONDARY_INVENTORY_NAME(+) = MMTT.SUBINVENTORY_CODE
AND MSS.ORGANIZATION_ID(+) = MMTT.ORGANIZATION_ID
AND MSS1.SECONDARY_INVENTORY_NAME(+) = MMTT.TRANSFER_SUBINVENTORY
AND MSS1.ORGANIZATION_ID(+) = MMTT.ORGANIZATION_ID
AND CPLL.PICKLIST_HEADER_ID = CPLH.PICKLIST_HEADER_ID
AND MMTT.ORGANIZATION_ID = CPLH.ORGANIZATION_ID