View: CST_PAC_RECEIVING_VALUES_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_PAC_RECEIVING_VALUES_V

View Text

SELECT RCT.TRANSACTION_ID
, RCT.TRANSACTION_DATE
, RCT.ORGANIZATION_ID
, CCG.LEGAL_ENTITY
, CCG.COST_GROUP_ID
, MSI.ORGANIZATION_ID
, MSI.PRIMARY_UOM_CODE
, RS.ITEM_ID
, RS.ITEM_REVISION
, RSL.ITEM_DESCRIPTION
, RS.UNIT_OF_MEASURE
, RS.LOCATION_ID
, RS.TO_ORGANIZATION_ID
, RS.TO_ORG_PRIMARY_QUANTITY
, RS.TO_ORG_PRIMARY_UOM
, RS.RECEIPT_DATE
, RSH.RECEIPT_NUM
, RSH.SHIPMENT_NUM
, RSH.SHIPPED_DATE
, RSH.FREIGHT_CARRIER_CODE
, RSL.QUANTITY_SHIPPED
, RSL.DESTINATION_TYPE_CODE
, NVL(RSL.PACKING_SLIP
, RSH.PACKING_SLIP)
, RSL.SOURCE_DOCUMENT_CODE
, DECODE(RSL.SOURCE_DOCUMENT_CODE
, 'INVENTORY'
, RSL.DELIVER_TO_LOCATION_ID
, 'PO'
, PD.DELIVER_TO_LOCATION_ID
, 'REQ'
, PRL.DELIVER_TO_LOCATION_ID) DELIVER_TO_LOCATION_ID
, DECODE(RSL.SOURCE_DOCUMENT_CODE
, 'INVENTORY'
, RSH.SHIPMENT_NUM
, 'PO'
, PH.SEGMENT1
, 'REQ'
, PRH.SEGMENT1) SOURCE_DOCUMENT
, DECODE(RSL.SOURCE_DOCUMENT_CODE
, 'INVENTORY'
, RSL.LINE_NUM
, 'PO'
, PL.LINE_NUM
, 'REQ'
, PRL.LINE_NUM) DOCUMENT_LINE_NUM
, CRAC.ACQUISITION_COST
, RSH.VENDOR_ID
, RS.RCV_TRANSACTION_ID
, CRAC.PERIOD_ID
FROM CST_RCV_ACQ_COSTS CRAC
, RCV_SUPPLY RS
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_HEADERS_ALL PH
, PO_LINES_ALL PL
, PO_LINE_LOCATIONS_ALL PLL
, PO_DISTRIBUTIONS_ALL PD
, PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES_ALL PRL
, RCV_TRANSACTIONS RCT
, CST_COST_GROUPS CCG
, MTL_SYSTEM_ITEMS MSI
WHERE CRAC.RCV_TRANSACTION_ID = RCT.TRANSACTION_ID
AND NVL(RCT.CONSIGNED_FLAG
, 'N') = 'N'
AND RSH.SHIPMENT_HEADER_ID = RS.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = RS.SHIPMENT_LINE_ID
AND PH.PO_HEADER_ID (+) = RS.PO_HEADER_ID
AND PL.PO_LINE_ID (+) = RS.PO_LINE_ID
AND PLL.LINE_LOCATION_ID (+) = RS.PO_LINE_LOCATION_ID
AND PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
AND PRH.REQUISITION_HEADER_ID (+) = RS.REQ_HEADER_ID
AND PRL.REQUISITION_LINE_ID (+) = RS.REQ_LINE_ID
AND RS.RCV_TRANSACTION_ID = RCT.TRANSACTION_ID
AND UPPER(RS.SUPPLY_TYPE_CODE) = 'RECEIVING'
AND (CCG.LEGAL_ENTITY
, CCG.COST_GROUP_ID) IN (SELECT DISTINCT CCG1.LEGAL_ENTITY
, CCGA.COST_GROUP_ID
FROM CST_COST_GROUP_ASSIGNMENTS CCGA
, CST_COST_GROUPS CCG1
WHERE CCG1.COST_GROUP_ID = CCGA.COST_GROUP_ID
AND CCGA.ORGANIZATION_ID = RCT.ORGANIZATION_ID)
AND MSI.INVENTORY_ITEM_ID = RS.ITEM_ID
AND MSI.ORGANIZATION_ID = (SELECT DISTINCT MP.MASTER_ORGANIZATION_ID
FROM MTL_PARAMETERS MP
WHERE MP.ORGANIZATION_ID = RCT.ORGANIZATION_ID) ORDER BY RS.RCV_TRANSACTION_ID
, RS.ITEM_ID

Columns