Product: | BOM - Bills of Material |
---|---|
Description: | View on the landed cost adjustment interface transactions |
Implementation/DBA Data: | APPS.CST_LC_ADJ_INTERFACE_V |
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