DBA Data[Home] [Help]

APPS.CTO_MATCH_AND_RESERVE dependencies on BOM_CALENDAR_DATES

Line 1329: from bom_calendar_dates cal,

1325: l_stmt_num := 139;
1326: select trunc(greatest(nvl(cal.calendar_date,SYSDATE), SYSDATE),
1327: 'MI')+1/(60*24)
1328: into l_rev_date
1329: from bom_calendar_dates cal,
1330: mtl_parameters mp,
1331: -- 4162494 wip_parameters wp,
1332: mtl_system_items msi,
1333: oe_order_lines_all oel

Line 1347: from bom_calendar_dates cal2

1343: (ceil(nvl(msi.fixed_lead_time,0) +
1344: nvl(msi.variable_lead_time,0) *
1345: p_quantity_to_reserve
1346: ))))
1347: from bom_calendar_dates cal2
1348: where cal2.calendar_code = mp.calendar_code
1349: and cal2.exception_set_id =
1350: mp.calendar_exception_set_id
1351: and cal2.calendar_date =