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 3482: from bom_calendar_dates cal,

3478: (trunc (greatest(nvl(cal.calendar_date,SYSDATE),
3479: SYSDATE),'MI')+1/(60*24) )
3480: )
3481:
3482: from bom_calendar_dates cal,
3483: mtl_parameters mp,
3484: wip_parameters wp,
3485: mtl_system_items msi
3486: where mp.organization_id = l_ship_org

Line 3498: from bom_calendar_dates cal2

3494: (ceil(nvl(msi.fixed_lead_time,0) +
3495: nvl(msi.variable_lead_time,0) *
3496: l_mlsupply_items(l_index).needed_item_qty --bugfix 2074290: this is in primary uom
3497: ))))
3498: from bom_calendar_dates cal2
3499: where cal2.calendar_code = mp.calendar_code
3500: and cal2.exception_set_id =
3501: mp.calendar_exception_set_id
3502: and cal2.calendar_date =

Line 3629: from bom_calendar_dates cal,

3625: null),
3626: decode(nvl(wp.use_finite_scheduler,2), 1,
3627: l_mlsupply_items(l_index).job_start_date,
3628: null)
3629: from bom_calendar_dates cal,
3630: mtl_parameters mp,
3631: wip_parameters wp,
3632: mtl_system_items msi
3633: where mp.organization_id = l_ship_org

Line 3645: from bom_calendar_dates cal2

3641: (ceil(nvl(msi.fixed_lead_time,0) +
3642: nvl(msi.variable_lead_time,0) *
3643: l_mlsupply_items(l_index).needed_item_qty --bugfix 2074290: this is in primary uom
3644: ))))
3645: from bom_calendar_dates cal2
3646: where cal2.calendar_code = mp.calendar_code
3647: and cal2.exception_set_id =
3648: mp.calendar_exception_set_id
3649: and cal2.calendar_date =