[Home] [Help] [Dependency Information]
Object Name: | IC_TXN_REQUEST_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.IC_TXN_REQUEST_LINES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A public view which may be useful for custom reporting or other data
requirements.
This view is used in the OPM Transact Process Move Orders form (ICTOTRX.fmb) to get the Move Order Lines data based on the entered criteria.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | Yes | ||
REQUEST_NUMBER | VARCHAR2 | (30) | Yes | |
MOVE_ORDER_TYPE | NUMBER | |||
MOVE_ORDER_TYPE_NAME | VARCHAR2 | (80) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
HEADER_ID | NUMBER | Yes | ||
TRANSACTION_SOURCE_TYPE_ID | NUMBER | |||
TRANSACTION_TYPE_ID | NUMBER | Yes | ||
TRANSACTION_TYPE_NAME | VARCHAR2 | (80) | ||
TRANSACTION_ACTION_ID | NUMBER | |||
LINE_NUMBER | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
FROM_SUBINVENTORY_ID | NUMBER | |||
FROM_SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
FROM_LOCATOR_ID | NUMBER | |||
TO_SUBINVENTORY_ID | NUMBER | |||
TO_SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
TO_LOCATOR_ID | NUMBER | |||
TO_ACCOUNT_ID | NUMBER | |||
SHIP_TO_LOCATION_ID | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (32) | ||
SUBLOT_NO | VARCHAR2 | (32) | ||
UOM_CODE | VARCHAR2 | (3) | Yes | |
QUANTITY | NUMBER | Yes | ||
QUANTITY_DELIVERED | NUMBER | |||
QUANTITY_DETAILED | NUMBER | |||
DATE_REQUIRED | DATE | Yes | ||
REASON_ID | NUMBER | |||
REFERENCE | VARCHAR2 | (240) | ||
REFERENCE_TYPE_CODE | NUMBER | |||
REFERENCE_ID | NUMBER | |||
TRANSACTION_HEADER_ID | NUMBER | |||
LINE_STATUS | NUMBER | Yes | ||
STATUS_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
TXN_SOURCE_ID | NUMBER | |||
TXN_SOURCE_LINE_ID | NUMBER | |||
TXN_SOURCE_LINE_DETAIL_ID | NUMBER | |||
PRIMARY_QUANTITY | NUMBER | |||
TO_ORGANIZATION_ID | NUMBER | |||
PICK_STRATEGY_ID | NUMBER | |||
PUT_AWAY_STRATEGY_ID | NUMBER | |||
UNIT_NUMBER | VARCHAR2 | (30) | ||
QC_GRADE | VARCHAR2 | (4) | ||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | ||
SECONDARY_QUANTITY | NUMBER | |||
SECONDARY_QUANTITY_DELIVERED | NUMBER | |||
SECONDARY_QUANTITY_DETAILED | NUMBER | |||
ALLOC_CLASS | VARCHAR2 | (8) | ||
ITEM_NO | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (70) | Yes | |
LOT_CTL | NUMBER | (5) | Yes | |
LOCT_CTL | NUMBER | (5) | Yes | |
SHIP_SET_ID | NUMBER | SHIP SET ID FOR MOVE ORDER LINE |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ID
, REQUEST_NUMBER
, MOVE_ORDER_TYPE
, MOVE_ORDER_TYPE_NAME
, DESCRIPTION
, HEADER_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_TYPE_ID
, TRANSACTION_TYPE_NAME
, TRANSACTION_ACTION_ID
, LINE_NUMBER
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, FROM_SUBINVENTORY_ID
, FROM_SUBINVENTORY_CODE
, FROM_LOCATOR_ID
, TO_SUBINVENTORY_ID
, TO_SUBINVENTORY_CODE
, TO_LOCATOR_ID
, TO_ACCOUNT_ID
, SHIP_TO_LOCATION_ID
, LOT_NUMBER
, SUBLOT_NO
, UOM_CODE
, QUANTITY
, QUANTITY_DELIVERED
, QUANTITY_DETAILED
, DATE_REQUIRED
, REASON_ID
, REFERENCE
, REFERENCE_TYPE_CODE
, REFERENCE_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
, PRIMARY_QUANTITY
, TO_ORGANIZATION_ID
, PICK_STRATEGY_ID
, PUT_AWAY_STRATEGY_ID
, UNIT_NUMBER
, QC_GRADE
, SECONDARY_UOM_CODE
, SECONDARY_QUANTITY
, SECONDARY_QUANTITY_DELIVERED
, SECONDARY_QUANTITY_DETAILED
, ALLOC_CLASS
, ITEM_NO
, ITEM_DESCRIPTION
, LOT_CTL
, LOCT_CTL
, SHIP_SET_ID
FROM APPS.IC_TXN_REQUEST_LINES_V;
APPS.IC_TXN_REQUEST_LINES_V is not referenced by any database object
|
|
|