DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GME_INV_TXN_LOTS_TEMP_ERES_V

Object Details
Object Name: GME_INV_TXN_LOTS_TEMP_ERES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGME.GME_INV_TXN_LOTS_TEMP_ERES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_HEADER_ID NUMBER

Transaction group identifier
TRANSACTION_TEMP_ID NUMBER
Yes 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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GROUP_HEADER_ID
,      TRANSACTION_TEMP_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_TEMP_ERES_V;

Dependencies

[top of page]

APPS.GME_INV_TXN_LOTS_TEMP_ERES_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
SynonymMTL_LOT_NUMBERS
SynonymMTL_MATERIAL_STATUSES_TL
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_TRANSACTION_LOTS_TEMP

APPS.GME_INV_TXN_LOTS_TEMP_ERES_V is not referenced by any database object