DBA Data[Home] [Help] [Dependency Information]


TABLE: INV.MTL_TXN_REQUEST_LINES

Object Details
Object Name: MTL_TXN_REQUEST_LINES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_TXN_REQUEST_LINES
Subobject Name:
Status: VALID


The table MTL_TXN_REQUEST_LINES stores all of the move order lines. The lines are requests to move some quantity of an item from a source location to a destination location or account. Each move order line must be tied to a specific move order header.
When a line is detailed or pick released, the quantity detailed is updated appropriately and transaction lines are created in MTL_MATERIAL_TRANSACTIONS_TEMP. When the transaction lines are transacted, the quantity delivered is updated.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_TXN_REQUEST_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
MTL_TXN_REQUEST_LINES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnLINE_NUMBER
MTL_TXN_REQUEST_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnTXN_SOURCE_ID
MTL_TXN_REQUEST_LINES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnLINE_STATUS
MTL_TXN_REQUEST_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnLINE_STATUS
ColumnFROM_SUBINVENTORY_CODE
ColumnTO_SUBINVENTORY_CODE
MTL_TXN_REQUEST_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTO_ORGANIZATION_ID
ColumnTO_SUBINVENTORY_CODE
MTL_TXN_REQUEST_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_TYPE_ID
ColumnTRANSACTION_SOURCE_TYPE_ID
ColumnTXN_SOURCE_ID
MTL_TXN_REQUEST_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPICK_SLIP_NUMBER
MTL_TXN_REQUEST_LINES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBACKORDER_DELIVERY_DETAIL_ID
MTL_TXN_REQUEST_LINES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLPN_ID
MTL_TXN_REQUEST_LINES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnREFERENCE_ID
MTL_TXN_REQUEST_LINES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnREPETITIVE_SCHEDULE_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Yes Line identifier
HEADER_ID NUMBER
Yes Header identifier
LINE_NUMBER NUMBER
Yes Line number
ORGANIZATION_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
REVISION VARCHAR2 (3)
Inventory item revision code
FROM_SUBINVENTORY_CODE VARCHAR2 (10)
From subinventory code
FROM_LOCATOR_ID NUMBER

From locator identifier
TO_SUBINVENTORY_CODE VARCHAR2 (10)
To subinventory code
TO_LOCATOR_ID NUMBER

To locator identifier
TO_ACCOUNT_ID NUMBER

To account identifier
LOT_NUMBER VARCHAR2 (80)
Lot number
SERIAL_NUMBER_START VARCHAR2 (30)
First serial number in range
SERIAL_NUMBER_END VARCHAR2 (30)
Last serial number in range
UOM_CODE VARCHAR2 (3) Yes Unit of measure for quantities
QUANTITY NUMBER
Yes Quantity requested
QUANTITY_DELIVERED NUMBER

Quantity which has been delivered
QUANTITY_DETAILED NUMBER

Quantity which has a detailed sourcing location
DATE_REQUIRED DATE
Yes Date required
REASON_ID NUMBER

Reason identifier
REFERENCE VARCHAR2 (240)
Move order creator reference
REFERENCE_TYPE_CODE NUMBER

Move order creator code
REFERENCE_ID NUMBER

Move order creator identifier
PROJECT_ID NUMBER

Project identifier
TASK_ID NUMBER

Task identifier
TRANSACTION_HEADER_ID NUMBER

Transaction header identifier
LINE_STATUS NUMBER
Yes Line status
STATUS_DATE DATE
Yes Last date status was changed
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE
Yes Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
TXN_SOURCE_ID NUMBER

Transaction source identifier
TXN_SOURCE_LINE_ID NUMBER

Transaction source line identifier
TXN_SOURCE_LINE_DETAIL_ID NUMBER

Transaction source line detail identifier
TRANSACTION_TYPE_ID NUMBER
Yes Transaction type identifier
TRANSACTION_SOURCE_TYPE_ID NUMBER

Transaction source type identifier
PRIMARY_QUANTITY NUMBER

Quantity requested, in primary unit of measure
TO_ORGANIZATION_ID NUMBER

To Organization identifier
PUT_AWAY_STRATEGY_ID NUMBER

Put Away strategy identifier - used by WMS only
PICK_STRATEGY_ID NUMBER

Picking strategy identifier - used by WMS only
SHIP_TO_LOCATION_ID NUMBER

Ship To Location identifier
UNIT_NUMBER VARCHAR2 (30)
Unit Number
REFERENCE_DETAIL_ID NUMBER

Reference Detail Id
ASSIGNMENT_ID NUMBER

Assignment Id
FROM_COST_GROUP_ID NUMBER

From Cost Group Identifier - used by WMS only
TO_COST_GROUP_ID NUMBER

To Cost Group Identifier - used by WMS only
LPN_ID NUMBER

License Plate Number Identifier - used by WMS only
TO_LPN_ID NUMBER

Transfer License Plate Number Identifier - used by WMS only
PICK_SLIP_NUMBER NUMBER

Pick Slip Number
PICK_SLIP_DATE DATE

Pick Slip Date
FROM_SUBINVENTORY_ID NUMBER

Not currently used
TO_SUBINVENTORY_ID NUMBER

Not currently used
INSPECTION_STATUS NUMBER

Inspection Status
PICK_METHODOLOGY_ID NUMBER

Pick Methodology ID
CONTAINER_ITEM_ID NUMBER

Container Item Id - used by WMS only
CARTON_GROUPING_ID NUMBER

Carton Grouping Id - used by WMS only
BACKORDER_DELIVERY_DETAIL_ID NUMBER

The delivery detail Id for the backorder lines
WMS_PROCESS_FLAG NUMBER

Flag to indicate processing status for putaways. 1 means Ok to process,2 means Do not Allocate, 3 means Allocate but do not process. To be used by Receiving and WIP
SHIP_SET_ID NUMBER

Ship Set Identifier
SHIP_MODEL_ID NUMBER

Ship Model Identifier
MODEL_QUANTITY NUMBER

Quantity of the Top Model for Ship Model Complete items
CROSSDOCK_TYPE NUMBER

Cross dock type
REQUIRED_QUANTITY NUMBER

Required quantity for the sales order
GRADE_CODE VARCHAR2 (150)
Grade Code for Move Order Line
SECONDARY_QUANTITY NUMBER

Secondary Quantity for Move Order Line
SECONDARY_QUANTITY_DELIVERED NUMBER

Secondary Quantity Delivered for Move Order Line
SECONDARY_QUANTITY_DETAILED NUMBER

Secondary Quantity Detailed for Move Order Line
SECONDARY_REQUIRED_QUANTITY NUMBER

Secondary Required Quantity for Move Order Line
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure for Move Order Line
WIP_ENTITY_ID NUMBER

WIP Entity identifier
REPETITIVE_SCHEDULE_ID NUMBER

Repetitive Schedule identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number
WIP_SUPPLY_TYPE NUMBER

WIP supply type
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

INV.MTL_TXN_REQUEST_LINES does not reference any database object

INV.MTL_TXN_REQUEST_LINES is referenced by following:

SchemaINV
ViewMTL_TXN_REQUEST_LINES#