APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on BOM_CALENDAR_DATES

Line 444: FROM BOM_CALENDAR_DATES BCD1,

440:
441: l_stmt_num := 10;
442:
443: SELECT BCD1.CALENDAR_DATE into l_new_date
444: FROM BOM_CALENDAR_DATES BCD1,
445: BOM_CALENDAR_DATES BCD2,
446: MTL_PARAMETERS MP
447: WHERE MP.ORGANIZATION_ID = porgid
448: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE

Line 445: BOM_CALENDAR_DATES BCD2,

441: l_stmt_num := 10;
442:
443: SELECT BCD1.CALENDAR_DATE into l_new_date
444: FROM BOM_CALENDAR_DATES BCD1,
445: BOM_CALENDAR_DATES BCD2,
446: MTL_PARAMETERS MP
447: WHERE MP.ORGANIZATION_ID = porgid
448: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
449: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE

Line 456: FROM BOM_CALENDAR_DATES BCD1,

452: AND BCD2.CALENDAR_DATE = TRUNC(Pdate)
453: AND BCD1.SEQ_NUM = NVL(BCD2.SEQ_NUM, BCD2.PRIOR_SEQ_NUM) - pleadtime;
454: ELSIF(pdirection = 'F') THEN
455: SELECT BCD1.CALENDAR_DATE into l_new_date
456: FROM BOM_CALENDAR_DATES BCD1,
457: BOM_CALENDAR_DATES BCD2,
458: MTL_PARAMETERS MP
459: WHERE MP.ORGANIZATION_ID = porgid
460: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE

Line 457: BOM_CALENDAR_DATES BCD2,

453: AND BCD1.SEQ_NUM = NVL(BCD2.SEQ_NUM, BCD2.PRIOR_SEQ_NUM) - pleadtime;
454: ELSIF(pdirection = 'F') THEN
455: SELECT BCD1.CALENDAR_DATE into l_new_date
456: FROM BOM_CALENDAR_DATES BCD1,
457: BOM_CALENDAR_DATES BCD2,
458: MTL_PARAMETERS MP
459: WHERE MP.ORGANIZATION_ID = porgid
460: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
461: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE

Line 3445: from bom_calendar_dates cal,

3441: (trunc (greatest(nvl(cal.calendar_date,SYSDATE),
3442: SYSDATE),'MI')+1/(60*24) )
3443: )
3444:
3445: from bom_calendar_dates cal,
3446: mtl_parameters mp,
3447: wip_parameters wp,
3448: mtl_system_items msi
3449: where mp.organization_id = l_ship_org

Line 3461: from bom_calendar_dates cal2

3457: (ceil(nvl(msi.fixed_lead_time,0) +
3458: nvl(msi.variable_lead_time,0) *
3459: l_mlsupply_items(l_index).needed_item_qty --bugfix 2074290: this is in primary uom
3460: ))))
3461: from bom_calendar_dates cal2
3462: where cal2.calendar_code = mp.calendar_code
3463: and cal2.exception_set_id =
3464: mp.calendar_exception_set_id
3465: and cal2.calendar_date =

Line 3593: from bom_calendar_dates cal,

3589: null),
3590: decode(nvl(wp.use_finite_scheduler,2), 1,
3591: l_mlsupply_items(l_index).job_start_date,
3592: null)
3593: from bom_calendar_dates cal,
3594: mtl_parameters mp,
3595: wip_parameters wp,
3596: mtl_system_items msi
3597: where mp.organization_id = l_ship_org

Line 3609: from bom_calendar_dates cal2

3605: (ceil(nvl(msi.fixed_lead_time,0) +
3606: nvl(msi.variable_lead_time,0) *
3607: l_mlsupply_items(l_index).needed_item_qty --bugfix 2074290: this is in primary uom
3608: ))))
3609: from bom_calendar_dates cal2
3610: where cal2.calendar_code = mp.calendar_code
3611: and cal2.exception_set_id =
3612: mp.calendar_exception_set_id
3613: and cal2.calendar_date =