eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 3483: mtl_parameters mp,

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

Line 3630: mtl_parameters mp,

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