View: MRP_BOM_PLAN_NAME_LOV_V

Product:	MRP - Master Scheduling/MRP
Description:	Plan name list of values view
Implementation/DBA Data:	APPS.MRP_BOM_PLAN_NAME_LOV_V

View Text

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)

Columns