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]

TABLE: BOM.CST_LC_ADJ_TRANSACTIONS

Object Details

Object Name:	CST_LC_ADJ_TRANSACTIONS
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_LC_ADJ_TRANSACTIONS
Subobject Name:
Status:	VALID

CST_LC_ADJ_TRANSACTIONS stores the landed cost adjustment transactions. These transactions are created every time the landed cost of an LCM shipment is recalculated. The transaction is created for the corresponding parent receipt transaction (rcv_transaction_id) and the previous and the new landed cost. The transaction_date is the date of the recalculation of the landed cost.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_LC_ADJ_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
CST_LC_ADJ_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCV_TRANSACTION_ID TRANSACTION_DATE ORGANIZATION_ID
CST_LC_ADJ_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID TRANSACTION_DATE CREATION_DATE

Columns

Name	Datatype	Mandatory	Comments
TRANSACTION_ID	NUMBER	Yes	Landed cost adjustment unique transaction identifier
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 identifier
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
GROUP_ID	NUMBER	Yes	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

Query Text

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


SELECT TRANSACTION_ID
,      RCV_TRANSACTION_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      PRIOR_LANDED_COST
,      NEW_LANDED_COST
,      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
FROM BOM.CST_LC_ADJ_TRANSACTIONS;

Dependencies

[top of page]

BOM.CST_LC_ADJ_TRANSACTIONS does not reference any database object

BOM.CST_LC_ADJ_TRANSACTIONS is referenced by following:

APPS: CST_LC_ADJ_TRANSACTIONS