[Home] [Help] [Dependency Information]
Object Name: | CST_LC_ADJ_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_LC_ADJ_INTERFACE |
Subobject Name: | |
Status: | VALID |
The CST_LCM_ADJ_INTERFACE table is an interface table that is populated every time the landed cost of an LCM shipment is recalculated. The interface 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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CST_LC_ADJ_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
GROUP_ID
ORGANIZATION_ID PROCESS_STATUS |
CST_LC_ADJ_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PROCESS_STATUS PROCESS_PHASE |
CST_LC_ADJ_INTERFACE_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
TRANSACTION_DATE |
CST_LC_ADJ_INTERFACE_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID TRANSACTION_DATE |
CST_LC_ADJ_INTERFACE_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RCV_TRANSACTION_ID
TRANSACTION_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Unique landed cost 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 | |
PROCESS_STATUS | NUMBER | Yes | Process phase: 1-Pending, 2-Running | |
PROCESS_PHASE | NUMBER | Yes | Process status: 1-Pending, 2-Validated, 3-Errored | |
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 |
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
, 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
FROM BOM.CST_LC_ADJ_INTERFACE;
BOM.CST_LC_ADJ_INTERFACE does not reference any database object
BOM.CST_LC_ADJ_INTERFACE is referenced by following:
|
|
|