View: RCV_RECEIVING_VALUE_VIEW

Product:	PO - Purchasing
Description:	Receiving Value Report
Implementation/DBA Data:	APPS.RCV_RECEIVING_VALUE_VIEW

View Text

SELECT 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.RECEIPT_DATE
, RSH.RECEIPT_NUM
, RSH.SHIPMENT_NUM
, RSH.SHIPPED_DATE
, RSH.FREIGHT_CARRIER_CODE
, RSL.QUANTITY_SHIPPED
, RS.DESTINATION_TYPE_CODE
, NVL(RSL.PACKING_SLIP
, RSH.PACKING_SLIP)
, RSL.SOURCE_DOCUMENT_CODE
, DECODE(RSL.SOURCE_DOCUMENT_CODE
, 'INV'
, 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
, 'INV'
, RSH.SHIPMENT_NUM
, 'PO'
, PH.SEGMENT1
, 'REQ'
, PRH.SEGMENT1) SOURCE_DOCUMENT
, DECODE(RSL.SOURCE_DOCUMENT_CODE
, 'INV'
, RSL.LINE_NUM
, 'PO'
, PL.LINE_NUM
, 'REQ'
, PRL.LINE_NUM) DOCUMENT_LINE_NUM
, DECODE(RSL.SOURCE_DOCUMENT_CODE
, 'INV'
, (RSL.SHIPMENT_UNIT_PRICE * NVL(PH.RATE
, 1)) * (RCT.SOURCE_DOC_QUANTITY/RCT.PRIMARY_QUANTITY)
, 'PO'
, (PLL.PRICE_OVERRIDE *NVL(PH.RATE
, 1)) * (RCT.SOURCE_DOC_QUANTITY/RCT.PRIMARY_QUANTITY)
, 'REQ'
, PRL.UNIT_PRICE * (RCT.SOURCE_DOC_QUANTITY / RCT.PRIMARY_QUANTITY)) ACTUAL_PRICE
, RSH.VENDOR_ID
, RS.RCV_TRANSACTION_ID
, PD.BOM_RESOURCE_ID
, PD.WIP_ENTITY_ID
, PD.WIP_RESOURCE_SEQ_NUM
, PD.WIP_OPERATION_SEQ_NUM
, PD.WIP_REPETITIVE_SCHEDULE_ID
FROM MTL_SUPPLY RS
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_HEADERS PH
, PO_LINES PL
, PO_LINE_LOCATIONS PLL
, PO_DISTRIBUTIONS PD
, PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, RCV_TRANSACTIONS RCT
WHERE 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 PD.PO_DISTRIBUTION_ID (+) = RS.PO_DISTRIBUTION_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 RS.SUPPLY_TYPE_CODE = 'RECEIVING'

Columns