[Home] [Help] [Dependency Information]
Object Name: | GME_INV_TXNS_POSTED_ERES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GME.GME_INV_TXNS_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 |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
TRANSACTION_SOURCE_TYPE_ID | NUMBER | Yes | Transaction source type identifier | |
TRANSACTION_SOURCE_ID | NUMBER | Transaction source idenfier. For GME batches this is the batch_id | ||
TRANSACTION_ACTION_ID | NUMBER | Yes | Transaction action identifier | |
TRANSACTION_TYPE_ID | NUMBER | Yes | 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_ID | NUMBER | Yes | Transaction line identifier used to join to lot or serial table when under these controls | |
REVISION | VARCHAR2 | (3) | Inventory item revision code | |
SUBINVENTORY | VARCHAR2 | (10) | Subinventory name | |
LOCATOR_ID | NUMBER | Locator identifier | ||
LOCATOR | CHAR | (1) | Locator | |
TRANSACTION_QUANTITY | NUMBER | Yes | Quantity entered at transaction time | |
TRANSACTION_UOM | VARCHAR2 | (3) | Yes | UOM used at the time of transaction |
TRANSACTION_DATE | DATE | Yes | Transaction date | |
TRANSACTION_DISPLAY_DATE | VARCHAR2 | (4000) | Transaction date | |
REASON_ID | NUMBER | Transaction reason identifier | ||
REASON_NAME | VARCHAR2 | (30) | Transaction reason | |
SECONDARY_UOM_CODE | VARCHAR2 | (3) | Secondary unit of measure that may have been used to do the material transaction | |
SECONDARY_TRANSACTION_QUANTITY | NUMBER | Secondary quantity | ||
PRIMARY_QUANTITY | NUMBER | Yes | 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) | Yes |
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_ID
, REVISION
, SUBINVENTORY
, LOCATOR_ID
, LOCATOR
, TRANSACTION_QUANTITY
, TRANSACTION_UOM
, TRANSACTION_DATE
, TRANSACTION_DISPLAY_DATE
, REASON_ID
, REASON_NAME
, SECONDARY_UOM_CODE
, SECONDARY_TRANSACTION_QUANTITY
, PRIMARY_QUANTITY
, ORIGINAL_TRANSACTION_TEMP_ID
, SOURCE_LINE_ID
, TRANSACTION_TYPE
FROM APPS.GME_INV_TXNS_POSTED_ERES_V;
APPS.GME_INV_TXNS_POSTED_ERES_V is not referenced by any database object
|
|
|