APPS.CTO_CONFIG_BOM_PK dependencies on BOM_CALENDAR_DATES

Line 565: from bom_calendar_dates cal,

561:
562: begin --Bugfix 2374246
563: select CAL.CALENDAR_DATE
564: into lEstRelDate
565: from bom_calendar_dates cal,
566: mtl_system_items msi,
567: bom_cto_order_lines bcol,
568: mtl_parameters mp
569: where msi.organization_id = pOrgId

Line 578: from bom_calendar_dates cal2

574: and cal.calendar_code = mp.calendar_code
575: and cal.exception_set_id = mp.calendar_exception_set_id
576: and cal.seq_num =
577: (select cal2.prior_seq_num - lTotLeadTime
578: from bom_calendar_dates cal2
579: where cal2.calendar_code = mp.calendar_code
580: and cal2.exception_set_id = mp.calendar_exception_set_id
581: and cal2.calendar_date = trunc(bcol.schedule_ship_date));
582: -- Bugfix 2374246