View: PO_REQ_SUPPLY_VIEW

Product:	PO - Purchasing
Description:	Requisition supply
Implementation/DBA Data:	APPS.PO_REQ_SUPPLY_VIEW

View Text

SELECT MS.ITEM_ID
, MS.TO_ORGANIZATION_ID
, MS.REQ_HEADER_ID
, PRL.SUGGESTED_VENDOR_NAME
, PRL.SUGGESTED_VENDOR_LOCATION
, MS.NEED_BY_DATE
, PRH.SEGMENT1
, NVL(MS.QUANTITY
, 0) * PD.REQ_LINE_QUANTITY / PRL.QUANTITY
, MUOM.UOM_CODE
, NVL(MS.TO_ORG_PRIMARY_QUANTITY
, 0) * PD.REQ_LINE_QUANTITY / PRL.QUANTITY
, MS.TO_ORG_PRIMARY_UOM
, PRL.UNIT_PRICE
, PRL.LINE_NUM
, MS.DESTINATION_TYPE_CODE
, MS.MRP_EXPECTED_DELIVERY_DATE
, NVL(MS.MRP_PRIMARY_QUANTITY
, 0) * PD.REQ_LINE_QUANTITY / PRL.QUANTITY
, MS.MRP_PRIMARY_UOM
, MS.MRP_DESTINATION_TYPE_CODE
, MS.MRP_TO_ORGANIZATION_ID
, MS.MRP_TO_SUBINVENTORY
, MS.REQ_LINE_ID
, MS.ITEM_REVISION
, MS.EXPECTED_DELIVERY_DATE
, NVL(MS.TO_ORG_PRIMARY_QUANTITY
, 0) * PD.REQ_LINE_QUANTITY / PRL.QUANTITY
, MS.TO_ORGANIZATION_ID
, PD.PROJECT_ID
, PD.TASK_ID
, PD.END_ITEM_UNIT_NUMBER
, MS.TO_SUBINVENTORY
, PRH.TRANSFERRED_TO_OE_FLAG
, MS.FROM_ORGANIZATION_ID
FROM MTL_UNITS_OF_MEASURE MUOM
, MTL_SUPPLY MS
, PO_REQ_DISTRIBUTIONS_ALL PD
, PO_REQUISITION_LINES_ALL PRL
, PO_REQUISITION_HEADERS_ALL PRH
WHERE MS.SUPPLY_TYPE_CODE = 'REQ'
AND PD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
AND PRL.REQUISITION_LINE_ID = MS.REQ_LINE_ID
AND PRH.REQUISITION_HEADER_ID = MS.REQ_HEADER_ID
AND PRL.QUANTITY > 0
AND MUOM.UNIT_OF_MEASURE = MS.UNIT_OF_MEASURE

Columns