APPS.CTO_CONFIG_BOM_PK dependencies on BOM_CALENDAR_DATES

Line 567: from bom_calendar_dates cal,

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

Line 580: from bom_calendar_dates cal2

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