eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_CALENDAR_DATES

Line 1209: from bom_calendar_dates cal,

1205: lStmtNum := 20;
1206: BEGIN
1207: select CAL.CALENDAR_DATE
1208: into lEstRelDate
1209: from bom_calendar_dates cal,
1210: mtl_system_items msi,
1211: bom_cto_order_lines_upg bcolu,
1212: mtl_parameters mp
1213: where msi.organization_id = pOrgId

Line 1222: from bom_calendar_dates cal2

1218: and cal.calendar_code = mp.calendar_code
1219: and cal.exception_set_id = mp.calendar_exception_set_id
1220: and cal.seq_num =
1221: (select cal2.prior_seq_num - pLeadTime
1222: from bom_calendar_dates cal2
1223: where cal2.calendar_code = mp.calendar_code
1224: and cal2.exception_set_id = mp.calendar_exception_set_id
1225: and cal2.calendar_date = trunc(bcolu.schedule_ship_date));
1226: EXCEPTION