DBA Data[Home] [Help]

APPS.CTO_WIP_UTIL dependencies on BOM_CALENDAR_DATES

Line 322: from bom_calendar_dates cal,

318: oel.inventory_item_id,
319: (trunc (greatest(nvl(cal.calendar_date,SYSDATE),
320: SYSDATE),'MI')+1/(60*24) )
321: ) /* 2620282 : Insert bom revision info */
322: from bom_calendar_dates cal,
323: mtl_parameters mp,
324: wip_parameters wp,
325: mtl_system_items msi,
326: oe_order_lines_all oel

Line 340: from bom_calendar_dates cal2

336: (ceil(nvl(msi.fixed_lead_time,0) +
337: nvl(msi.variable_lead_time,0) *
338: l_partial_qty --bugfix 2074290: this is in primary uom
339: ))))
340: from bom_calendar_dates cal2
341: where cal2.calendar_code = mp.calendar_code
342: and cal2.exception_set_id =
343: mp.calendar_exception_set_id
344: and cal2.calendar_date =

Line 549: from bom_calendar_dates cal,

545: oel.inventory_item_id,
546: (trunc (greatest(nvl(cal.calendar_date,SYSDATE),
547: SYSDATE),'MI')+1/(60*24) )
548: ) /* 2620282 : Insert bom revision info */
549: from bom_calendar_dates cal,
550: mtl_parameters mp,
551: wip_parameters wp,
552: mtl_system_items msi,
553: oe_order_lines_all oel

Line 574: from bom_calendar_dates cal2

570: msi.primary_uom_code,
571: null,
572: null)
573: ))))
574: from bom_calendar_dates cal2
575: where cal2.calendar_code = mp.calendar_code
576: and cal2.exception_set_id =
577: mp.calendar_exception_set_id
578: and cal2.calendar_date =