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 4511: from bom_calendar_dates cal,

4507: and ((p_offset_days is null)
4508: /* Bug 5520934 begin: We need to honour bom calendar in offset days calculation */
4509: -- or (oel.schedule_ship_date <= trunc( sysdate + p_offset_days)))
4510: or (sysdate >= (select cal.calendar_date
4511: from bom_calendar_dates cal,
4512: mtl_parameters mp
4513: where mp.organization_id = oel.ship_from_org_id
4514: and cal.calendar_code = mp.calendar_code
4515: and cal.exception_set_id = mp.calendar_exception_set_id

Line 4517: from bom_calendar_dates cal2

4513: where mp.organization_id = oel.ship_from_org_id
4514: and cal.calendar_code = mp.calendar_code
4515: and cal.exception_set_id = mp.calendar_exception_set_id
4516: and cal.seq_num = (select cal2.prior_seq_num - nvl(p_offset_days, 0)
4517: from bom_calendar_dates cal2
4518: where cal2.calendar_code = mp.calendar_code
4519: and cal2.exception_set_id = mp.calendar_exception_set_id
4520: and cal2.calendar_date = trunc(oel.schedule_ship_date)))))
4521: -- end bugfix 5520934

Line 5301: from bom_calendar_dates cal,

5297: drive_mark := drive_mark + 8;
5298: --sql_stmt := sql_stmt ||' and oel.schedule_ship_date <= trunc( sysdate + :p_offset_days) ';
5299: /* Bug 5520934 : We need to honour bom_calendar in offset days calculation */
5300: sql_stmt := sql_stmt ||' and sysdate >= (select cal.calendar_date
5301: from bom_calendar_dates cal,
5302: mtl_parameters mp
5303: where mp.organization_id = oel.ship_from_org_id
5304: and cal.calendar_code = mp.calendar_code
5305: and cal.exception_set_id = mp.calendar_exception_set_id

Line 5307: from bom_calendar_dates cal2

5303: where mp.organization_id = oel.ship_from_org_id
5304: and cal.calendar_code = mp.calendar_code
5305: and cal.exception_set_id = mp.calendar_exception_set_id
5306: and cal.seq_num = (select cal2.prior_seq_num - nvl(:p_offset_days, 0)
5307: from bom_calendar_dates cal2
5308: where cal2.calendar_code = mp.calendar_code
5309: and cal2.exception_set_id = mp.calendar_exception_set_id
5310: and cal2.calendar_date = trunc(oel.schedule_ship_date))) ';
5311: end if;