[Home] [Help] [Dependency Information]
Object Name: | GMF_LC_ADJ_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMF.GMF_LC_ADJ_DETAILS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
LC Adjustment details view will contain detailed information for each actual LC adjustment
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_SHIP_LINE_ID | NUMBER | Parent Shipment Line identifier | ||
ADJUSTMENT_NUM | NUMBER | Yes | Adjustment Number | |
CURRENT_ADJUSTMENT_FLAG | VARCHAR2 | (1) | Current Adjustment Flag | |
SHIP_HEADER_ID | NUMBER | Yes | LCM Shipment Header Identifier | |
SHIP_LINE_GROUP_ID | NUMBER | Yes | Shipment Line Group Identifier | |
SHIP_LINE_ID | NUMBER | LCM Shipment Line Identifier | ||
MATCH_ID | NUMBER | Yes | Inl Matches table Match Identifier | |
ADJ_GROUP_DATE | DATE | Adjustment Group date | ||
FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | From Parent table name | |
FROM_PARENT_TABLE_ID | NUMBER | From Parent table Identifier | ||
INVOICE_NUM | VARCHAR2 | (50) | Yes | Invoice Number |
INVOICE_DATE | DATE | Invoice Date | ||
PARTY_ID | NUMBER | (15) | Party Identifier | |
PARTY_SITE_ID | NUMBER | (15) | Party Site Identifier | |
INVOICE_LINE_NUMBER | NUMBER | Yes | Invoice Line Number | |
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Yes | Invoice Distribution Identifier |
INVOICE_DISTR_AMT | NUMBER | Invoice distribution Amount | ||
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Invoice Currency Code |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_SHIP_LINE_ID
, ADJUSTMENT_NUM
, CURRENT_ADJUSTMENT_FLAG
, SHIP_HEADER_ID
, SHIP_LINE_GROUP_ID
, SHIP_LINE_ID
, MATCH_ID
, ADJ_GROUP_DATE
, FROM_PARENT_TABLE_NAME
, FROM_PARENT_TABLE_ID
, INVOICE_NUM
, INVOICE_DATE
, PARTY_ID
, PARTY_SITE_ID
, INVOICE_LINE_NUMBER
, INVOICE_DISTRIBUTION_ID
, INVOICE_DISTR_AMT
, INVOICE_CURRENCY_CODE
FROM APPS.GMF_LC_ADJ_DETAILS_V;
APPS.GMF_LC_ADJ_DETAILS_V is not referenced by any database object
|
|
|