[Home] [Help] [Dependency Information]
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.
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 |
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;
APPS.CST_LC_ADJ_INTERFACE_V is not referenced by any database object
|
|
|