DBA Data[Home] [Help]

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on MTL_PARAMETERS

Line 446: MTL_PARAMETERS MP

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
450: AND BCD1.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID

Line 458: MTL_PARAMETERS MP

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
462: AND BCD1.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID

Line 3446: mtl_parameters mp,

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
3450: and wp.organization_id = mp.organization_id

Line 3594: mtl_parameters mp,

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
3598: and wp.organization_id = mp.organization_id