[Home] [Help]
| Product: | MRP - Master Scheduling/MRP |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT /*+ ORDERED */ MS.TRANSACTION_ID
, MS.ITEM_ID
, MS.TO_ORGANIZATION_ID
, MS.PO_HEADER_ID
, PH.VENDOR_ID
, MS.NEED_BY_DATE
, DECODE(MS.PO_RELEASE_ID
, NULL
, PH.SEGMENT1
, PH.SEGMENT1||'('||TO_CHAR(PR.RELEASE_NUM)||')')
, MS.QUANTITY
, MS.TO_ORG_PRIMARY_QUANTITY
, PLL.PRICE_OVERRIDE
, PL.LINE_NUM
, MS.DESTINATION_TYPE_CODE
, DECODE(MS.PO_RELEASE_ID
, NULL
, PH.PRINTED_DATE
, PR.PRINTED_DATE)
, DECODE(MS.PO_RELEASE_ID
, NULL
, PH.REVISION_NUM
, PR.REVISION_NUM)
, PH.FIRM_DATE
, NVL(PH.FIRM_STATUS_LOOKUP_CODE
, 'N')
, PLL.FIRM_DATE
, NVL(PLL.FIRM_STATUS_LOOKUP_CODE
, 'N')
, MS.MRP_EXPECTED_DELIVERY_DATE
, MS.MRP_PRIMARY_QUANTITY
, MS.MRP_PRIMARY_UOM
, MS.MRP_DESTINATION_TYPE_CODE
, MS.MRP_TO_ORGANIZATION_ID
, MS.MRP_TO_SUBINVENTORY
, MS.PO_LINE_ID
, MS.PO_LINE_LOCATION_ID
, MS.PO_DISTRIBUTION_ID
, PL.ITEM_REVISION
, MS.EXPECTED_DELIVERY_DATE
, MS.TO_ORG_PRIMARY_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 MRP_AP_SUPPLY_SN MS
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSI
, PO_HEADERS_ALL PH
, MRP_AP_PO_LINE_SN PL
, MRP_AP_PO_LLOCS_SN PLL
, MRP_AP_PO_DISTS_SN PD
, MRP_AP_PO_RELEASE_SN PR
WHERE (MS.SUPPLY_TYPE_CODE = 'PO' OR MS.SUPPLY_TYPE_CODE = 'ASN')
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 PH.PO_HEADER_ID = MS.PO_HEADER_ID
AND PR.PO_RELEASE_ID(+) = MS.PO_RELEASE_ID
AND PL.PO_LINE_ID = MS.PO_LINE_ID
AND PLL.LINE_LOCATION_ID = MS.PO_LINE_LOCATION_ID
AND PD.PO_DISTRIBUTION_ID = MS.PO_DISTRIBUTION_ID
AND MS.PO_LINE_ID IS NOT NULL
AND PL.LINE_NUM IS NOT NULL