[Home] [Help] [Dependency Information]
Object Name: | GME_INV_TXN_LOTS_POSTED_ERES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GME.GME_INV_TXN_LOTS_POSTED_ERES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Transaction line identifier used to join to lot or serial table when under these controls | ||
LOT_NUMBER | VARCHAR2 | (80) | Yes | Lot Number |
PARENT_LOT_NUMBER | VARCHAR2 | (80) | Parent lot Number | |
GRADE_CODE | VARCHAR2 | (150) | Grade code | |
LOT_STATUS_ID | NUMBER | Lot status identifier | ||
LOT_STATUS | VARCHAR2 | (80) | Lot status | |
TRANSACTION_QUANTITY | NUMBER | Yes | Quantity entered at transaction time | |
LOT_EXPIRATION_DATE | DATE | Lot expiration date | ||
LOT_EXPIRATION_DISPLAY_DATE | VARCHAR2 | (4000) | Lot expiration date | |
SECONDARY_TRANSACTION_QUANTITY | NUMBER | Secondary quantity | ||
PRIMARY_QUANTITY | NUMBER | Yes | Transaction quantity in terms of the primary uom of the item |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, LOT_NUMBER
, PARENT_LOT_NUMBER
, GRADE_CODE
, LOT_STATUS_ID
, LOT_STATUS
, TRANSACTION_QUANTITY
, LOT_EXPIRATION_DATE
, LOT_EXPIRATION_DISPLAY_DATE
, SECONDARY_TRANSACTION_QUANTITY
, PRIMARY_QUANTITY
FROM APPS.GME_INV_TXN_LOTS_POSTED_ERES_V;
APPS.GME_INV_TXN_LOTS_POSTED_ERES_V is not referenced by any database object
|
|
|