APPS.MRP_ATP_COLLECTION dependencies on BOM_CALENDAR_DATES

Line 169: FROM BOM_CALENDAR_DATES C ,

165: FND_GLOBAL.USER_ID,
166: D1.DEMAND_CLASS,
167: 2, -- supply
168: DECODE(I.BOM_ITEM_TYPE, 5, I.INVENTORY_ITEM_ID, NULL)
169: FROM BOM_CALENDAR_DATES C ,
170: MTL_ATP_RULES R ,
171: MTL_PARAMETERS P ,
172: MTL_SYSTEM_ITEMS I,
173: MRP_SCHEDULE_DATES D2,

Line 234: FROM BOM_CALENDAR_DATES C,

230: FND_GLOBAL.USER_ID,
231: U.DEMAND_CLASS,
232: 2, -- supply
233: NULL
234: FROM BOM_CALENDAR_DATES C,
235: MTL_ATP_RULES R ,
236: MTL_PARAMETERS P ,
237: MTL_SYSTEM_ITEMS I ,
238: MTL_USER_SUPPLY U

Line 307: FROM BOM_CALENDAR_DATES C ,

303: FND_GLOBAL.USER_ID,
304: NULL,
305: 2, -- supply
306: NULL
307: FROM BOM_CALENDAR_DATES C ,
308: MTL_SUPPLY S,
309: MTL_ATP_RULES R ,
310: MTL_PARAMETERS P ,
311: MTL_SYSTEM_ITEMS I

Line 399: FROM BOM_CALENDAR_DATES C ,

395: FND_GLOBAL.USER_ID,
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

Line 463: FROM BOM_CALENDAR_DATES C ,

459: FND_GLOBAL.USER_ID,
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 ,

Line 537: FROM BOM_CALENDAR_DATES C ,

533: FND_GLOBAL.USER_ID,
534: WRS.DEMAND_CLASS,
535: 2, -- supply
536: NULL
537: FROM BOM_CALENDAR_DATES C ,
538: BOM_CALENDAR_DATES C1 ,
539: WIP_REPETITIVE_SCHEDULES WRS ,
540: WIP_REPETITIVE_ITEMS WRI,
541: MTL_ATP_RULES R ,

Line 538: BOM_CALENDAR_DATES C1 ,

534: WRS.DEMAND_CLASS,
535: 2, -- supply
536: NULL
537: FROM BOM_CALENDAR_DATES C ,
538: BOM_CALENDAR_DATES C1 ,
539: WIP_REPETITIVE_SCHEDULES WRS ,
540: WIP_REPETITIVE_ITEMS WRI,
541: MTL_ATP_RULES R ,
542: MTL_PARAMETERS P ,

Line 611: FROM BOM_CALENDAR_DATES C ,

607: FND_GLOBAL.USER_ID,
608: D.DEMAND_CLASS,
609: 2, -- supply
610: NULL
611: FROM BOM_CALENDAR_DATES C ,
612: WIP_FLOW_SCHEDULES D,
613: MTL_PARAMETERS P ,
614: MTL_ATP_RULES R,
615: MTL_SYSTEM_ITEMS I

Line 668: FROM BOM_CALENDAR_DATES C ,

664: FND_GLOBAL.USER_ID,
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 ,

Line 746: FROM BOM_CALENDAR_DATES C ,

742: FND_GLOBAL.USER_ID,
743: WRS.DEMAND_CLASS,
744: 1, -- demand
745: I.PRODUCT_FAMILY_ITEM_ID
746: FROM BOM_CALENDAR_DATES C ,
747: BOM_CALENDAR_DATES C1 ,
748: WIP_REPETITIVE_SCHEDULES WRS ,
749: WIP_REQUIREMENT_OPERATIONS WRO,
750: MTL_ATP_RULES R ,

Line 747: BOM_CALENDAR_DATES C1 ,

743: WRS.DEMAND_CLASS,
744: 1, -- demand
745: I.PRODUCT_FAMILY_ITEM_ID
746: FROM BOM_CALENDAR_DATES C ,
747: BOM_CALENDAR_DATES C1 ,
748: WIP_REPETITIVE_SCHEDULES WRS ,
749: WIP_REQUIREMENT_OPERATIONS WRO,
750: MTL_ATP_RULES R ,
751: MTL_PARAMETERS P ,

Line 818: FROM BOM_CALENDAR_DATES C,

814: FND_GLOBAL.USER_ID,
815: U.DEMAND_CLASS,
816: 1, -- demand
817: I.PRODUCT_FAMILY_ITEM_ID
818: FROM BOM_CALENDAR_DATES C,
819: MTL_ATP_RULES R ,
820: MTL_PARAMETERS P ,
821: MTL_SYSTEM_ITEMS I ,
822: MTL_USER_DEMAND U

Line 879: BOM_CALENDAR_DATES C ,

875: I.PRODUCT_FAMILY_ITEM_ID
876: FROM WIP_FLOW_SCHEDULES F,
877: BOM_BILL_OF_MATERIALS BOM ,
878: BOM_INVENTORY_COMPONENTS BIC ,
879: BOM_CALENDAR_DATES C ,
880: MTL_PARAMETERS P ,
881: MTL_ATP_RULES R,
882: MTL_SYSTEM_ITEMS I
883: WHERE I.ATP_FLAG in ('C', 'Y')

Line 952: FROM BOM_CALENDAR_DATES C ,

948: FND_GLOBAL.USER_ID,
949: D.DEMAND_CLASS,
950: 1, -- demand
951: I.PRODUCT_FAMILY_ITEM_ID
952: FROM BOM_CALENDAR_DATES C ,
953: MTL_DEMAND D,
954: MTL_ATP_RULES R ,
955: MTL_PARAMETERS P ,
956: MTL_SYSTEM_ITEMS I

Line 1024: FROM BOM_CALENDAR_DATES C ,

1020: FND_GLOBAL.USER_ID,
1021: L.DEMAND_CLASS_CODE,
1022: 1, -- demand
1023: I.PRODUCT_FAMILY_ITEM_ID
1024: FROM BOM_CALENDAR_DATES C ,
1025: OE_ORDER_LINES L,
1026: MTL_ATP_RULES R ,
1027: MTL_PARAMETERS P ,
1028: MTL_SYSTEM_ITEMS I