VIEW: INV.MTL_TXN_REQUEST_LINES#

Source

View Text - Preformatted

select LINE_ID LINE_ID, HEADER_ID HEADER_ID, LINE_NUMBER LINE_NUMBER, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, REVISION REVISION, FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE, FROM_LOCATOR_ID FROM_LOCATOR_ID, TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE, TO_LOCATOR_ID TO_LOCATOR_ID, TO_ACCOUNT_ID TO_ACCOUNT_ID, LOT_NUMBER LOT_NUMBER, SERIAL_NUMBER_START SERIAL_NUMBER_START, SERIAL_NUMBER_END SERIAL_NUMBER_END, UOM_CODE UOM_CODE, QUANTITY QUANTITY, QUANTITY_DELIVERED QUANTITY_DELIVERED, QUANTITY_DETAILED QUANTITY_DETAILED, DATE_REQUIRED DATE_REQUIRED, REASON_ID REASON_ID, REFERENCE REFERENCE, REFERENCE_TYPE_CODE REFERENCE_TYPE_CODE, REFERENCE_ID REFERENCE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, LINE_STATUS LINE_STATUS, STATUS_DATE STATUS_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, TXN_SOURCE_ID TXN_SOURCE_ID, TXN_SOURCE_LINE_ID TXN_SOURCE_LINE_ID, TXN_SOURCE_LINE_DETAIL_ID TXN_SOURCE_LINE_DETAIL_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, PRIMARY_QUANTITY PRIMARY_QUANTITY, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID, PICK_STRATEGY_ID PICK_STRATEGY_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, UNIT_NUMBER UNIT_NUMBER, REFERENCE_DETAIL_ID REFERENCE_DETAIL_ID, ASSIGNMENT_ID ASSIGNMENT_ID, FROM_COST_GROUP_ID FROM_COST_GROUP_ID, TO_COST_GROUP_ID TO_COST_GROUP_ID, LPN_ID LPN_ID, TO_LPN_ID TO_LPN_ID, PICK_SLIP_NUMBER PICK_SLIP_NUMBER, PICK_SLIP_DATE PICK_SLIP_DATE, FROM_SUBINVENTORY_ID FROM_SUBINVENTORY_ID, TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID, INSPECTION_STATUS INSPECTION_STATUS, PICK_METHODOLOGY_ID PICK_METHODOLOGY_ID, CONTAINER_ITEM_ID CONTAINER_ITEM_ID, CARTON_GROUPING_ID CARTON_GROUPING_ID, BACKORDER_DELIVERY_DETAIL_ID BACKORDER_DELIVERY_DETAIL_ID, WMS_PROCESS_FLAG WMS_PROCESS_FLAG, SHIP_SET_ID SHIP_SET_ID, SHIP_MODEL_ID SHIP_MODEL_ID, MODEL_QUANTITY MODEL_QUANTITY, CROSSDOCK_TYPE CROSSDOCK_TYPE, REQUIRED_QUANTITY REQUIRED_QUANTITY, GRADE_CODE GRADE_CODE, SECONDARY_QUANTITY SECONDARY_QUANTITY, SECONDARY_QUANTITY_DELIVERED SECONDARY_QUANTITY_DELIVERED, SECONDARY_QUANTITY_DETAILED SECONDARY_QUANTITY_DETAILED, SECONDARY_REQUIRED_QUANTITY SECONDARY_REQUIRED_QUANTITY, SECONDARY_UOM_CODE SECONDARY_UOM_CODE, WIP_ENTITY_ID WIP_ENTITY_ID, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE from "INV"."MTL_TXN_REQUEST_LINES"

View Text - HTML Formatted

SELECT LINE_ID LINE_ID
, HEADER_ID HEADER_ID
, LINE_NUMBER LINE_NUMBER
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, REVISION REVISION
, FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, FROM_LOCATOR_ID FROM_LOCATOR_ID
, TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE
, TO_LOCATOR_ID TO_LOCATOR_ID
, TO_ACCOUNT_ID TO_ACCOUNT_ID
, LOT_NUMBER LOT_NUMBER
, SERIAL_NUMBER_START SERIAL_NUMBER_START
, SERIAL_NUMBER_END SERIAL_NUMBER_END
, UOM_CODE UOM_CODE
, QUANTITY QUANTITY
, QUANTITY_DELIVERED QUANTITY_DELIVERED
, QUANTITY_DETAILED QUANTITY_DETAILED
, DATE_REQUIRED DATE_REQUIRED
, REASON_ID REASON_ID
, REFERENCE REFERENCE
, REFERENCE_TYPE_CODE REFERENCE_TYPE_CODE
, REFERENCE_ID REFERENCE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, LINE_STATUS LINE_STATUS
, STATUS_DATE STATUS_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TXN_SOURCE_ID TXN_SOURCE_ID
, TXN_SOURCE_LINE_ID TXN_SOURCE_LINE_ID
, TXN_SOURCE_LINE_DETAIL_ID TXN_SOURCE_LINE_DETAIL_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID
, PICK_STRATEGY_ID PICK_STRATEGY_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, UNIT_NUMBER UNIT_NUMBER
, REFERENCE_DETAIL_ID REFERENCE_DETAIL_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, FROM_COST_GROUP_ID FROM_COST_GROUP_ID
, TO_COST_GROUP_ID TO_COST_GROUP_ID
, LPN_ID LPN_ID
, TO_LPN_ID TO_LPN_ID
, PICK_SLIP_NUMBER PICK_SLIP_NUMBER
, PICK_SLIP_DATE PICK_SLIP_DATE
, FROM_SUBINVENTORY_ID FROM_SUBINVENTORY_ID
, TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID
, INSPECTION_STATUS INSPECTION_STATUS
, PICK_METHODOLOGY_ID PICK_METHODOLOGY_ID
, CONTAINER_ITEM_ID CONTAINER_ITEM_ID
, CARTON_GROUPING_ID CARTON_GROUPING_ID
, BACKORDER_DELIVERY_DETAIL_ID BACKORDER_DELIVERY_DETAIL_ID
, WMS_PROCESS_FLAG WMS_PROCESS_FLAG
, SHIP_SET_ID SHIP_SET_ID
, SHIP_MODEL_ID SHIP_MODEL_ID
, MODEL_QUANTITY MODEL_QUANTITY
, CROSSDOCK_TYPE CROSSDOCK_TYPE
, REQUIRED_QUANTITY REQUIRED_QUANTITY
, GRADE_CODE GRADE_CODE
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, SECONDARY_QUANTITY_DELIVERED SECONDARY_QUANTITY_DELIVERED
, SECONDARY_QUANTITY_DETAILED SECONDARY_QUANTITY_DETAILED
, SECONDARY_REQUIRED_QUANTITY SECONDARY_REQUIRED_QUANTITY
, SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, WIP_ENTITY_ID WIP_ENTITY_ID
, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
FROM "INV"."MTL_TXN_REQUEST_LINES"