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.

[Home] [Help]

View: CST_LC_ADJ_INTERFACE_V

Product:	BOM - Bills of Material
Description:	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.
Implementation/DBA Data:	APPS.CST_LC_ADJ_INTERFACE_V

View Text

SELECT CLAI.ROWID
, CLAI.TRANSACTION_ID
, CLAI.RCV_TRANSACTION_ID
, CLAI.ORGANIZATION_ID
, CLAI.INVENTORY_ITEM_ID
, CLAI.TRANSACTION_DATE
, CLAI.PRIOR_LANDED_COST
, CLAI.NEW_LANDED_COST
, CLAI.PROCESS_STATUS
, CLAI.PROCESS_PHASE
, CLAI.GROUP_ID
, CLAI.CREATION_DATE
, CLAI.CREATED_BY
, CLAI.LAST_UPDATE_DATE
, CLAI.LAST_UPDATED_BY
, CLAI.LAST_UPDATE_LOGIN
, CLAI.REQUEST_ID
, CLAI.PROGRAM_APPLICATION_ID
, CLAI.PROGRAM_ID
, CLAI.PROGRAM_UPDATE_DATE
, ML5.MEANING PROCESS_PHASE_MEANING
, ML6.MEANING PROCESS_STATUS_MEANING
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, COD.ORGANIZATION_NAME ORGANIZATION_NAME
, RT.PO_HEADER_ID
, POH.SEGMENT1 PO_NUMBER
, RT.PO_LINE_ID PO_LINE_ID
, POL.LINE_NUM PO_LINE_NUM
, RSH.RECEIPT_NUM RECEIPT_NUM
, RT.PO_LINE_LOCATION_ID LINE_LOCATION_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, RSL.LINE_NUM RECEIPT_LINE_NUM
, RSH.SHIPMENT_HEADER_ID
, RSL.SHIPMENT_LINE_ID
FROM CST_LC_ADJ_INTERFACE CLAI
, RCV_TRANSACTIONS RT
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, MTL_SYSTEM_ITEMS_VL MSI
, CST_ORGANIZATION_DEFINITIONS COD
, MTL_PARAMETERS MP
, MFG_LOOKUPS ML5
, MFG_LOOKUPS ML6
WHERE CLAI.RCV_TRANSACTION_ID = RT.TRANSACTION_ID
AND CLAI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND CLAI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = COD.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RSL.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND POH.PO_HEADER_ID = RT.PO_HEADER_ID
AND POL.PO_LINE_ID = RT.PO_LINE_ID
AND ML5.LOOKUP_TYPE = 'LANDED_COST_ADJ_PROCESS_PHASE'
AND ML5.LOOKUP_CODE = CLAI.PROCESS_PHASE
AND ML6.LOOKUP_TYPE = 'LANDED_COST_ADJ_PROCESS_STATUS'
AND ML6.LOOKUP_CODE = CLAI.PROCESS_STATUS

Columns

Name
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