[Home] [Help] [Dependency Information]
Object Name: | GME_INV_TXNS_ERES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GME.GME_INV_TXNS_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 |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
TRANSACTION_SOURCE_TYPE_ID | NUMBER | Transaction source type identifier | ||
TRANSACTION_SOURCE_ID | NUMBER | Transaction source idenfier. For GME batches this is the batch_id | ||
TRANSACTION_ACTION_ID | NUMBER | Transaction action identifier | ||
TRANSACTION_TYPE_ID | NUMBER | Transaction type identifier | ||
TRANSACTION_SOURCE_NAME | VARCHAR2 | (80) | Transaction source identifier | |
TRX_SOURCE_LINE_ID | NUMBER | Line level transaction source identifier. For GME Batches this is material_detail_id | ||
TRANSACTION_TEMP_ID | NUMBER | Transaction line identifier used to join to lot or serial table when under these controls | ||
TRANSACTION_ID | NUMBER | Transaction line identifier used to join to lot or serial table when under these controls | ||
REVISION | VARCHAR2 | (3) | Inventory item revision code | |
LOT_NUMBER | VARCHAR2 | (80) | 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 | |
SUBINVENTORY | VARCHAR2 | (10) | Subinventory name | |
LOCATOR_ID | NUMBER | Locator identifier | ||
LOCATOR | CHAR | (1) | Locator | |
TRANSACTION_QUANTITY | NUMBER | Quantity entered at transaction time | ||
TRANSACTION_UOM | VARCHAR2 | (3) | UOM used at the time of transaction | |
TRANSACTION_DATE | DATE | Transaction date | ||
TRANSACTION_DISPLAY_DATE | VARCHAR2 | (4000) | Transaction date | |
REASON_ID | NUMBER | Transaction reason identifier | ||
REASON_NAME | VARCHAR2 | (30) | Transaction reason | |
LOT_EXPIRATION_DATE | DATE | Lot expiration date | ||
LOT_EXPIRATION_DISPLAY_DATE | VARCHAR2 | (4000) | Lot expiration date | |
SECONDARY_UOM_CODE | VARCHAR2 | (240) | Secondary unit of measure that may have been used to do the material transaction | |
SECONDARY_TRANSACTION_QUANTITY | NUMBER | Secondary quantity | ||
PRIMARY_QUANTITY | NUMBER | Transaction quantity in terms of the primary uom of the item | ||
ORIGINAL_TRANSACTION_TEMP_ID | NUMBER | Used to stores the transaction_temp_id in mtl_material_transactions | ||
SOURCE_LINE_ID | NUMBER | Source line identifier | ||
TRANSACTION_TYPE | VARCHAR2 | (80) |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_SOURCE_ID
, TRANSACTION_ACTION_ID
, TRANSACTION_TYPE_ID
, TRANSACTION_SOURCE_NAME
, TRX_SOURCE_LINE_ID
, TRANSACTION_TEMP_ID
, TRANSACTION_ID
, REVISION
, LOT_NUMBER
, PARENT_LOT_NUMBER
, GRADE_CODE
, LOT_STATUS_ID
, LOT_STATUS
, SUBINVENTORY
, LOCATOR_ID
, LOCATOR
, TRANSACTION_QUANTITY
, TRANSACTION_UOM
, TRANSACTION_DATE
, TRANSACTION_DISPLAY_DATE
, REASON_ID
, REASON_NAME
, LOT_EXPIRATION_DATE
, LOT_EXPIRATION_DISPLAY_DATE
, SECONDARY_UOM_CODE
, SECONDARY_TRANSACTION_QUANTITY
, PRIMARY_QUANTITY
, ORIGINAL_TRANSACTION_TEMP_ID
, SOURCE_LINE_ID
, TRANSACTION_TYPE
FROM APPS.GME_INV_TXNS_ERES_V;
APPS.GME_INV_TXNS_ERES_V is not referenced by any database object
|
|
|