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_HEADERS_V

Object Details

Object Name:	GMF_LC_ADJ_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GMF_LC_ADJ_HEADERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View used to store LC adjustments will be populated by LCM tables

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARENT_SHIP_LINE_ID	NUMBER			Parent Shipment Line Identifier
ADJUSTMENT_NUM	NUMBER		Yes	Adjustment Number
SHIP_HEADER_ID	NUMBER		Yes	LCM Shipment Header Identifier
SHIP_LINE_GROUP_ID	NUMBER		Yes	Shipment Line Group Identifier
SHIP_LINE_ID	NUMBER		Yes	LCM Shipment Line Identifier
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
INVENTORY_ITEM_ID	NUMBER			Inventory Item Identifier
PRIOR_LANDED_COST	VARCHAR2	(40)		Prior Landed Cost
LANDED_COST	NUMBER			Landed Cost
ALLOCATION_PERCENT	NUMBER			Allocation Percentage
COMPONENT_TYPE	VARCHAR2	(10)		Component Type- System defined
COMPONENT_NAME	VARCHAR2	(80)		Component Name User defined
CHARGE_LINE_TYPE_ID	NUMBER			Charge Line Type Identifier
CHARGE_LINE_TYPE_CODE	VARCHAR2	(30)		Charge Line type Code or Cost factor code
COST_ACQUISITION_FLAG	VARCHAR2	(1)		Cost Acquisition Flag
PARENT_TABLE_NAME	VARCHAR2	(16)		Parent Table name
PARENT_TABLE_ID	NUMBER			Parent Table Identifier
COST_CMPNTCLS_ID	NUMBER			Cost Component Class Identifier
COST_ANALYSIS_CODE	VARCHAR2	(4)		Cost Analysis Code
TRANSACTION_DATE	DATE		Yes	Transaction Date
TRANSACTION_QUANTITY	NUMBER			Transaction Quantity
TRANSACTION_UOM_CODE	VARCHAR2	(3)		Transaction UOM Code
PRIMARY_QUANTITY	NUMBER			Primary Quantity
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary UOM code
LC_ADJUSTMENT_FLAG	NUMBER			Landed Cost Adjustment Flag: 0 - Indicates ELC, 1 - Indicates ALC
RCV_TRANSACTION_ID	NUMBER		Yes	RCV Transaction Identifier
RCV_TRANSACTION_TYPE	VARCHAR2	(25)	Yes	Receipt Transaction Type
LC_SHIP_NUM	VARCHAR2	(25)	Yes	LCM Shipment number
LC_SHIP_LINE_NUM	NUMBER		Yes	LCM Shipment Line Number
RECEIPT_NUM	VARCHAR2	(30)		Receipt Number
ORG_ID	NUMBER		Yes	Operating Unit Id

Query Text

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


SELECT PARENT_SHIP_LINE_ID
,      ADJUSTMENT_NUM
,      SHIP_HEADER_ID
,      SHIP_LINE_GROUP_ID
,      SHIP_LINE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      PRIOR_LANDED_COST
,      LANDED_COST
,      ALLOCATION_PERCENT
,      COMPONENT_TYPE
,      COMPONENT_NAME
,      CHARGE_LINE_TYPE_ID
,      CHARGE_LINE_TYPE_CODE
,      COST_ACQUISITION_FLAG
,      PARENT_TABLE_NAME
,      PARENT_TABLE_ID
,      COST_CMPNTCLS_ID
,      COST_ANALYSIS_CODE
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM_CODE
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      LC_ADJUSTMENT_FLAG
,      RCV_TRANSACTION_ID
,      RCV_TRANSACTION_TYPE
,      LC_SHIP_NUM
,      LC_SHIP_LINE_NUM
,      RECEIPT_NUM
,      ORG_ID
FROM APPS.GMF_LC_ADJ_HEADERS_V;

Dependencies

[top of page]

APPS.GMF_LC_ADJ_HEADERS_V references the following:

APPS: INL_DET_LANDED_COSTS_V; INL_SHIP_HEADERS_ALL; MTL_UNITS_OF_MEASURE; PON_PRICE_ELEMENT_TYPES; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.GMF_LC_ADJ_HEADERS_V is referenced by following:

APPS: GMF_LC_ADJ_TRANSACTIONS_PKG - show dependent code