[Home] [Help] [Dependency Information]
Object Name: | MTL_TXN_REQUEST_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_TXN_REQUEST_HEADERS |
Subobject Name: | |
Status: | VALID |
This table stores all of the move order headers. The headers contain all information which pertains to entire move orders, including the transaction type of the move order, the move order type, the move order status, and the request number of the move order.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_TXN_REQUEST_HEADERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | HEADER_ID |
MTL_TXN_REQUEST_HEADERS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REQUEST_NUMBER
ORGANIZATION_ID |
MTL_TXN_REQUEST_HEADERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_TYPE_ID |
MTL_TXN_REQUEST_HEADERS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FROM_SUBINVENTORY_CODE
ORGANIZATION_ID |
MTL_TXN_REQUEST_HEADERS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TO_SUBINVENTORY_CODE
ORGANIZATION_ID |
MTL_TXN_REQUEST_HEADERS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MOVE_ORDER_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | Header identifier | |
REQUEST_NUMBER | VARCHAR2 | (30) | Yes | Request number of the move order |
TRANSACTION_TYPE_ID | NUMBER | Transaction type identifier | ||
MOVE_ORDER_TYPE | NUMBER | Type of move order | ||
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
DESCRIPTION | VARCHAR2 | (240) | Move order description | |
DATE_REQUIRED | DATE | Standard Who column | ||
FROM_SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory to transact from | |
TO_SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory to transact to | |
TO_ACCOUNT_ID | NUMBER | Account identifier to transact to | ||
HEADER_STATUS | NUMBER | Header status | ||
STATUS_DATE | DATE | Date of last status change | ||
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 | 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 | ||
GROUPING_RULE_ID | NUMBER | Grouping rule to use when assigning pick slip numbers | ||
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 | |
SHIP_TO_LOCATION_ID | NUMBER | Ship to Location Id | ||
FREIGHT_CODE | VARCHAR2 | (25) | Freight Code | |
SHIPMENT_METHOD | VARCHAR2 | (30) | Shipment Method | |
AUTO_RECEIPT_FLAG | VARCHAR2 | (1) | Auto Receipt Flag | |
REFERENCE_ID | NUMBER | Reference Id | ||
REFERENCE_DETAIL_ID | NUMBER | Reference Detail Id | ||
ASSIGNMENT_ID | VARCHAR2 | (240) | Assignment Id |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, REQUEST_NUMBER
, TRANSACTION_TYPE_ID
, MOVE_ORDER_TYPE
, ORGANIZATION_ID
, DESCRIPTION
, DATE_REQUIRED
, FROM_SUBINVENTORY_CODE
, TO_SUBINVENTORY_CODE
, TO_ACCOUNT_ID
, HEADER_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
, GROUPING_RULE_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SHIP_TO_LOCATION_ID
, FREIGHT_CODE
, SHIPMENT_METHOD
, AUTO_RECEIPT_FLAG
, REFERENCE_ID
, REFERENCE_DETAIL_ID
, ASSIGNMENT_ID
FROM INV.MTL_TXN_REQUEST_HEADERS;
INV.MTL_TXN_REQUEST_HEADERS does not reference any database object
INV.MTL_TXN_REQUEST_HEADERS is referenced by following:
|
|
|