APPS.CTO_BOM_RTG_PK dependencies on BOM_CALENDAR_DATES

Line 806: from bom_calendar_dates cal,

802: lStmtNum := 114;
803: begin
804: select CAL.CALENDAR_DATE
805: into lEstRelDate
806: from bom_calendar_dates cal,
807: mtl_system_items msi,
808: bom_cto_order_lines bcol,
809: mtl_parameters mp
810: where msi.organization_id = lNextRec.organization_id

Line 819: from bom_calendar_dates cal2

815: and cal.calendar_code = mp.calendar_code
816: and cal.exception_set_id = mp.calendar_exception_set_id
817: and cal.seq_num =
818: (select cal2.prior_seq_num - lLeadTime
819: from bom_calendar_dates cal2
820: where cal2.calendar_code = mp.calendar_code
821: and cal2.exception_set_id = mp.calendar_exception_set_id
822: and cal2.calendar_date = trunc(bcol.schedule_ship_date));
823: exception