VIEW: APPS.MRP_BOM_PLAN_NAME_LOV_V

Source

View Text - Preformatted

SELECT MSI.COMPILE_DESIGNATOR PLAN_NAME, MD.DESCRIPTION, MP2.PLAN_COMPLETION_DATE COMPLETION_DATE, MIF.ITEM_NUMBER ITEM, MSI.INVENTORY_USE_UP_DATE, MSI.INVENTORY_ITEM_ID, MSI.ORGANIZATION_ID FROM MTL_ITEM_FLEXFIELDS MIF, MRP_SYSTEM_ITEMS MSI, MRP_PLAN_ORGANIZATIONS MP, MRP_DESIGNATORS_VIEW MD, MRP_PLANS MP2 WHERE MIF.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIF.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND TRUNC(MSI.INVENTORY_USE_UP_DATE) >= TRUNC(SYSDATE) AND MSI.COMPILE_DESIGNATOR = MP2.COMPILE_DESIGNATOR AND MSI.ORGANIZATION_ID = NVL(MP.PLANNED_ORGANIZATION, MP2.ORGANIZATION_ID) AND MP.PLAN_LEVEL (+) = 2 AND MP.ORGANIZATION_ID (+) = MP2.ORGANIZATION_ID AND MP.COMPILE_DESIGNATOR (+) = MP2.COMPILE_DESIGNATOR AND MD.DESIGNATOR = MP2.COMPILE_DESIGNATOR AND MD.ORGANIZATION_ID = MP2.ORGANIZATION_ID AND MP2.EXPLOSION_COMPLETION_DATE <= MP2.DATA_COMPLETION_DATE AND MP2.DATA_COMPLETION_DATE <= MP2.PLAN_COMPLETION_DATE AND MP2.PLAN_TYPE IN (1,2,3,4)

View Text - HTML Formatted

SELECT MSI.COMPILE_DESIGNATOR PLAN_NAME
, MD.DESCRIPTION
, MP2.PLAN_COMPLETION_DATE COMPLETION_DATE
, MIF.ITEM_NUMBER ITEM
, MSI.INVENTORY_USE_UP_DATE
, MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
FROM MTL_ITEM_FLEXFIELDS MIF
, MRP_SYSTEM_ITEMS MSI
, MRP_PLAN_ORGANIZATIONS MP
, MRP_DESIGNATORS_VIEW MD
, MRP_PLANS MP2
WHERE MIF.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIF.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND TRUNC(MSI.INVENTORY_USE_UP_DATE) >= TRUNC(SYSDATE)
AND MSI.COMPILE_DESIGNATOR = MP2.COMPILE_DESIGNATOR
AND MSI.ORGANIZATION_ID = NVL(MP.PLANNED_ORGANIZATION
, MP2.ORGANIZATION_ID)
AND MP.PLAN_LEVEL (+) = 2
AND MP.ORGANIZATION_ID (+) = MP2.ORGANIZATION_ID
AND MP.COMPILE_DESIGNATOR (+) = MP2.COMPILE_DESIGNATOR
AND MD.DESIGNATOR = MP2.COMPILE_DESIGNATOR
AND MD.ORGANIZATION_ID = MP2.ORGANIZATION_ID
AND MP2.EXPLOSION_COMPLETION_DATE <= MP2.DATA_COMPLETION_DATE
AND MP2.DATA_COMPLETION_DATE <= MP2.PLAN_COMPLETION_DATE
AND MP2.PLAN_TYPE IN (1
, 2
, 3
, 4)