eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.GMF_LC_ADJ_DETAILS_V

Object Details

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

View Type

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

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.GMF_LC_ADJ_DETAILS_V references the following:

APPS: AP_INVOICES_ALL; AP_INVOICE_DISTRIBUTIONS_ALL; AP_INVOICE_LINES_ALL; INL_ALLOCATIONS; INL_CHARGE_LINES; INL_MATCHES; INL_SHIP_LINES_ALL; INL_TAX_LINES

APPS.GMF_LC_ADJ_DETAILS_V is not referenced by any database object