Product: | CSP - Spares Management |
---|---|
Description: | Material Transactions and Picklist information |
Implementation/DBA Data: | APPS.CSP_PICK_TRANSACTIONS_V |
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