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.CST_LC_ADJ_INTERFACE_V

Object Details

Object Name:	CST_LC_ADJ_INTERFACE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_LC_ADJ_INTERFACE_V
Subobject Name:
Status:	VALID

View on the landed cost adjustment transactions' interface table. Selects information related to the landed cost adjustment transaction along with details of the inventory organization, purchase order document, shipment and item involved.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
TRANSACTION_ID	NUMBER			Landed cost adjustment transaction id
RCV_TRANSACTION_ID	NUMBER		Yes	Parent receipt transaction for LCM shipment
ORGANIZATION_ID	NUMBER		Yes	Destination inventory organization id
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item id
TRANSACTION_DATE	DATE		Yes	Landed cost adjustment transaction date
PRIOR_LANDED_COST	NUMBER		Yes	Prior landed cost
NEW_LANDED_COST	NUMBER		Yes	New landed cost
PROCESS_STATUS	NUMBER		Yes	Process status: 1-Pending, 2-Validated, 3-Errored
PROCESS_PHASE	NUMBER		Yes	Process phase: 1-Pending, 2-Processing
GROUP_ID	NUMBER			Landed cost adjustment processor group id
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
PROCESS_PHASE_MEANING	VARCHAR2	(80)	Yes	Process phase: 1-Pending, 2-Processing
PROCESS_STATUS_MEANING	VARCHAR2	(80)	Yes	Process status: 1-Pending, 2-Validated, 3-Errored
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization Name
PO_HEADER_ID	NUMBER			Purchase order identifier
PO_NUMBER	VARCHAR2	(20)	Yes	Purchase order number
PO_LINE_ID	NUMBER			Purchase order line identifier
PO_LINE_NUM	NUMBER		Yes	Purchase order line number
RECEIPT_NUM	VARCHAR2	(30)		Receipt number
LINE_LOCATION_ID	NUMBER			Purchase order shipment identifier
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
RECEIPT_LINE_NUM	NUMBER		Yes	Shipment line number
SHIPMENT_HEADER_ID	NUMBER		Yes	Receipt header unique identifier
SHIPMENT_LINE_ID	NUMBER		Yes	Shipment line unique identifier

Query Text

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


SELECT ROW_ID
,      TRANSACTION_ID
,      RCV_TRANSACTION_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      PRIOR_LANDED_COST
,      NEW_LANDED_COST
,      PROCESS_STATUS
,      PROCESS_PHASE
,      GROUP_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROCESS_PHASE_MEANING
,      PROCESS_STATUS_MEANING
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUM
,      RECEIPT_NUM
,      LINE_LOCATION_ID
,      ITEM_DESCRIPTION
,      RECEIPT_LINE_NUM
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
FROM APPS.CST_LC_ADJ_INTERFACE_V;

Dependencies

[top of page]

APPS.CST_LC_ADJ_INTERFACE_V references the following:

APPS: CST_LC_ADJ_INTERFACE; CST_ORGANIZATION_DEFINITIONS; MFG_LOOKUPS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_VL; PO_HEADERS_ALL; PO_LINES_ALL; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.CST_LC_ADJ_INTERFACE_V is not referenced by any database object