DBA Data[Home] [Help]

APPS.CTO_MATCH_AND_RESERVE dependencies on BOM_CALENDAR_DATES

Line 1336: from bom_calendar_dates cal,

1332: l_stmt_num := 139;
1333: select trunc(greatest(nvl(cal.calendar_date,SYSDATE), SYSDATE),
1334: 'MI')+1/(60*24)
1335: into l_rev_date
1336: from bom_calendar_dates cal,
1337: mtl_parameters mp,
1338: -- 4162494 wip_parameters wp,
1339: mtl_system_items msi,
1340: oe_order_lines_all oel

Line 1354: from bom_calendar_dates cal2

1350: (ceil(nvl(msi.fixed_lead_time,0) +
1351: nvl(msi.variable_lead_time,0) *
1352: p_quantity_to_reserve
1353: ))))
1354: from bom_calendar_dates cal2
1355: where cal2.calendar_code = mp.calendar_code
1356: and cal2.exception_set_id =
1357: mp.calendar_exception_set_id
1358: and cal2.calendar_date =