396: D.DEMAND_CLASS,
397: 2, -- supply
398: NULL
399: FROM BOM_CALENDAR_DATES C ,
400: WIP_DISCRETE_JOBS D,
401: MTL_ATP_RULES R ,
402: MTL_PARAMETERS P ,
403: MTL_SYSTEM_ITEMS I
404: WHERE I.ATP_FLAG in ('C', 'Y')
460: D.DEMAND_CLASS,
461: 2, -- supply
462: NULL
463: FROM BOM_CALENDAR_DATES C ,
464: WIP_DISCRETE_JOBS D,
465: WIP_REQUIREMENT_OPERATIONS O ,
466: MTL_ATP_RULES R ,
467: MTL_PARAMETERS P ,
468: MTL_SYSTEM_ITEMS I
665: D.DEMAND_CLASS,
666: 1, -- demand
667: I.PRODUCT_FAMILY_ITEM_ID
668: FROM BOM_CALENDAR_DATES C ,
669: WIP_DISCRETE_JOBS D,
670: WIP_REQUIREMENT_OPERATIONS O ,
671: MTL_ATP_RULES R ,
672: MTL_PARAMETERS P ,
673: MTL_SYSTEM_ITEMS I