APPS.CTO_AUTO_PROCURE_PK dependencies on BOM_CALENDAR_DATES

Line 357: from bom_calendar_dates cal, mtl_parameters mp

353: -- rkaza. Need to consider the manufacturing calendar while
354: -- determining need by date
355:
356: select CAL.CALENDAR_DATE into x_need_by_date
357: from bom_calendar_dates cal, mtl_parameters mp
358: where mp.organization_id = p_org_id
359: and cal.calendar_code = mp.calendar_code
360: and cal.exception_set_id = mp.calendar_exception_set_id
361: and cal.seq_num = (select cal2.prior_seq_num - nvl(l_offset_days, 0)

Line 362: from bom_calendar_dates cal2

358: where mp.organization_id = p_org_id
359: and cal.calendar_code = mp.calendar_code
360: and cal.exception_set_id = mp.calendar_exception_set_id
361: and cal.seq_num = (select cal2.prior_seq_num - nvl(l_offset_days, 0)
362: from bom_calendar_dates cal2
363: where cal2.calendar_code = mp.calendar_code
364: and cal2.exception_set_id = mp.calendar_exception_set_id
365: and cal2.calendar_date= trunc(p_schedule_ship_date)
366: );

Line 4101: from bom_calendar_dates cal,

4097: and ((p_offset_days is null)
4098: /* Bug 5520934 begin: We need to honour bom calendar in offset days calculation */
4099: -- or (oel.schedule_ship_date <= trunc( sysdate + p_offset_days)))
4100: or (sysdate >= (select cal.calendar_date
4101: from bom_calendar_dates cal,
4102: mtl_parameters mp
4103: where mp.organization_id = oel.ship_from_org_id
4104: and cal.calendar_code = mp.calendar_code
4105: and cal.exception_set_id = mp.calendar_exception_set_id

Line 4107: from bom_calendar_dates cal2

4103: where mp.organization_id = oel.ship_from_org_id
4104: and cal.calendar_code = mp.calendar_code
4105: and cal.exception_set_id = mp.calendar_exception_set_id
4106: and cal.seq_num = (select cal2.prior_seq_num - nvl(p_offset_days, 0)
4107: from bom_calendar_dates cal2
4108: where cal2.calendar_code = mp.calendar_code
4109: and cal2.exception_set_id = mp.calendar_exception_set_id
4110: and cal2.calendar_date = trunc(oel.schedule_ship_date)))))
4111: -- end bugfix 5520934

Line 4880: from bom_calendar_dates cal,

4876: drive_mark := drive_mark + 8;
4877: --sql_stmt := sql_stmt ||' and oel.schedule_ship_date <= trunc( sysdate + :p_offset_days) ';
4878: /* Bug 5520934 : We need to honour bom_calendar in offset days calculation */
4879: sql_stmt := sql_stmt ||' and sysdate >= (select cal.calendar_date
4880: from bom_calendar_dates cal,
4881: mtl_parameters mp
4882: where mp.organization_id = oel.ship_from_org_id
4883: and cal.calendar_code = mp.calendar_code
4884: and cal.exception_set_id = mp.calendar_exception_set_id

Line 4886: from bom_calendar_dates cal2

4882: where mp.organization_id = oel.ship_from_org_id
4883: and cal.calendar_code = mp.calendar_code
4884: and cal.exception_set_id = mp.calendar_exception_set_id
4885: and cal.seq_num = (select cal2.prior_seq_num - nvl(:p_offset_days, 0)
4886: from bom_calendar_dates cal2
4887: where cal2.calendar_code = mp.calendar_code
4888: and cal2.exception_set_id = mp.calendar_exception_set_id
4889: and cal2.calendar_date = trunc(oel.schedule_ship_date))) ';
4890: end if;