DBA Data[Home] [Help]

APPS.CTO_WIP_UTIL dependencies on BOM_CALENDAR_DATES

Line 338: from bom_calendar_dates cal,

334: oel.inventory_item_id,
335: (trunc (greatest(nvl(cal.calendar_date,SYSDATE),
336: SYSDATE),'MI')+1/(60*24) )
337: ) /* 2620282 : Insert bom revision info */
338: from bom_calendar_dates cal,
339: mtl_parameters mp,
340: wip_parameters wp,
341: mtl_system_items msi,
342: oe_order_lines_all oel

Line 356: from bom_calendar_dates cal2

352: (ceil(nvl(msi.fixed_lead_time,0) +
353: nvl(msi.variable_lead_time,0) *
354: l_partial_qty --bugfix 2074290: this is in primary uom
355: ))))
356: from bom_calendar_dates cal2
357: where cal2.calendar_code = mp.calendar_code
358: and cal2.exception_set_id =
359: mp.calendar_exception_set_id
360: and cal2.calendar_date =

Line 567: from bom_calendar_dates cal,

563: oel.inventory_item_id,
564: (trunc (greatest(nvl(cal.calendar_date,SYSDATE),
565: SYSDATE),'MI')+1/(60*24) )
566: ) /* 2620282 : Insert bom revision info */
567: from bom_calendar_dates cal,
568: mtl_parameters mp,
569: wip_parameters wp,
570: mtl_system_items msi,
571: oe_order_lines_all oel

Line 592: from bom_calendar_dates cal2

588: msi.primary_uom_code,
589: null,
590: null)
591: ))))
592: from bom_calendar_dates cal2
593: where cal2.calendar_code = mp.calendar_code
594: and cal2.exception_set_id =
595: mp.calendar_exception_set_id
596: and cal2.calendar_date =