Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT MS.TRANSACTION_ID
, MS.ITEM_ID
, MS.TO_ORGANIZATION_ID
, MS.REQ_HEADER_ID
, PVV.VENDOR_ID
, MS.NEED_BY_DATE
, PRH.SEGMENT1
, NVL(MS.QUANTITY
, 0) * PD.REQ_LINE_QUANTITY / PRL.QUANTITY
, NVL(MS.TO_ORG_PRIMARY_QUANTITY
, 0) * PD.REQ_LINE_QUANTITY / PRL.QUANTITY
, 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
, MSI.SHRINKAGE_RATE
, MS.RN RN3
, MSI.RN RN2
, MP.RN RN1
FROM PO_VENDORS_VIEW PVV
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSI
, MRP_AP_PO_REQDIST_SN PD
, MRP_AP_PO_REQLINE_SN PRL
, PO_REQUISITION_HEADERS_ALL PRH
, MRP_AP_SUPPLY_SN MS
WHERE MS.SUPPLY_TYPE_CODE = 'REQ'
AND MP.ORGANIZATION_ID= MS.TO_ORGANIZATION_ID
AND MSI.ORGANIZATION_ID= MS.TO_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID= MS.ITEM_ID
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 PVV.VENDOR_NAME (+)= PRL.SUGGESTED_VENDOR_NAME
AND PRL.LINE_NUM IS NOT NULL
AND MS.REQ_LINE_ID IS NOT NULL