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.

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on MTL_PARAMETERS

Line 413: from mtl_parameters ood

409: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
410: and wjsi.organization_code is not null
411: and wjsi.organization_id is null
412: and not exists (select 1
413: from mtl_parameters ood
414: where ood.organization_code = wjsi.organization_code)
415: returning wjsi.interface_id bulk collect into l_interfaceTbl;
416:
417: if ( sql%rowcount > 0 ) then

Line 445: from mtl_parameters ood

441: -- Bug 4890514. Performance Fix
442: -- saugupta 25th-May-2006
443: update wip_job_schedule_interface wjsi
444: set wjsi.organization_id = (select ood.organization_id
445: from mtl_parameters ood
446: where ood.organization_code = wjsi.organization_code),
447: wjsi.last_update_date = sysdate
448: where wjsi.group_id = p_groupID
449: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 466: mtl_parameters mp,

462: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
463: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
464: and not exists (select 1
465: from wip_parameters wp,
466: mtl_parameters mp,
467: hr_organization_units ood
468: where wp.organization_id = mp.organization_id
469: and wp.organization_id = ood.organization_id
470: and wp.organization_id = wjsi.organization_id

Line 2963: mtl_parameters mp

2959: (wjsi.first_unit_start_date is null and wjsi.last_unit_completion_date is not null)))
2960: or (wjsi.first_unit_start_date is not null and
2961: not exists (select 1
2962: from bom_calendar_dates bcd,
2963: mtl_parameters mp
2964: where mp.organization_id = wjsi.organization_id
2965: and mp.calendar_code = bcd.calendar_code
2966: and mp.calendar_exception_set_id = bcd.exception_set_id
2967: and bcd.calendar_date = trunc(wjsi.first_unit_start_date)))

Line 2971: mtl_parameters mp

2967: and bcd.calendar_date = trunc(wjsi.first_unit_start_date)))
2968: or (wjsi.last_unit_completion_date is not null and
2969: not exists (select 1
2970: from bom_calendar_dates bcd,
2971: mtl_parameters mp
2972: where mp.organization_id = wjsi.organization_id
2973: and mp.calendar_code = bcd.calendar_code
2974: and mp.calendar_exception_set_id = bcd.exception_set_id
2975: and bcd.calendar_date = trunc(wjsi.last_unit_completion_date))))

Line 3112: mtl_parameters mp,

3108: /*
3109: select ood.operating_unit
3110: into l_operatingUnit
3111: from wip_parameters wp,
3112: mtl_parameters mp,
3113: org_organization_definitions ood
3114: where wp.organization_id = mp.organization_id
3115: and wp.organization_id = ood.organization_id
3116: and wp.organization_id = wjsi_row.organization_id

Line 3126: mtl_parameters mp,

3122: to_number(hoi.org_information3), to_number(null)) operating_unit
3123: INTO l_operatingUnit
3124: FROM hr_organization_units hou,
3125: wip_parameters wp,
3126: mtl_parameters mp,
3127: hr_organization_information hoi
3128: WHERE hou.organization_id = hoi.organization_id
3129: and ( hoi.org_information_context || '') = 'Accounting Information'
3130: and wp.organization_id = mp.organization_id

Line 3483: mtl_parameters mp

3479: select mpv.project_id --this query will return multiple rows if the project has tasks
3480: into l_dummy
3481: from pjm_projects_v mpv,
3482: pjm_project_parameters ppp,
3483: mtl_parameters mp
3484: where mpv.project_id = ppp.project_id
3485: and mpv.project_id = wjsi_row.project_id
3486: and ppp.organization_id = wjsi_row.organization_id
3487: and ppp.organization_id = mp.organization_id

Line 3639: mtl_parameters mp

3635: select 1 into l_dummy
3636: from dual
3637: where exists(select 1
3638: from cst_cg_wip_acct_classes_v ccwac,
3639: mtl_parameters mp
3640: where ccwac.class_code = wjsi_row.class_code
3641: and ccwac.organization_id = wjsi_row.organization_id
3642: and ccwac.class_type = wip_constants.discrete
3643: and mp.organization_id = wjsi_row.organization_id

Line 4014: mtl_parameters mp

4010: begin
4011: select 1
4012: into l_dummy
4013: from pjm_unit_numbers_lov_v pun,
4014: mtl_parameters mp
4015: where pun.unit_number = wjsi_row.end_item_unit_number
4016: and mp.organization_id = wjsi_row.organization_id
4017: and mp.master_organization_id = pun.master_organization_id;
4018: exception

Line 4231: mtl_parameters mp

4227: /*
4228: select calendar_date
4229: into wjsi_row.first_unit_start_date
4230: from bom_calendar_dates bcd,
4231: mtl_parameters mp
4232: where mp.organization_id = wjsi_row.organization_id
4233: and bcd.exception_set_id = mp.calendar_exception_set_id
4234: and bcd.calendar_code = mp.calendar_code
4235: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 4244: mtl_parameters mp,

4240: */
4241: SELECT bcd.calendar_date
4242: INTO wjsi_row.first_unit_start_date
4243: FROM bom_calendar_dates bcd,
4244: mtl_parameters mp,
4245: bom_calendar_dates b2
4246: WHERE mp.organization_id = wjsi_row.organization_id
4247: and bcd.exception_set_id = mp.calendar_exception_set_id
4248: and bcd.calendar_code = mp.calendar_code

Line 4262: mtl_parameters mp

4258: /*
4259: select calendar_date
4260: into wjsi_row.last_unit_start_date
4261: from bom_calendar_dates bcd,
4262: mtl_parameters mp
4263: where mp.organization_id = wjsi_row.organization_id
4264: and bcd.exception_set_id = mp.calendar_exception_set_id
4265: and bcd.calendar_code = mp.calendar_code
4266: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 4275: mtl_parameters mp,

4271: */
4272: SELECT bcd.calendar_date
4273: INTO wjsi_row.last_unit_start_date
4274: FROM bom_calendar_dates bcd,
4275: mtl_parameters mp,
4276: bom_calendar_dates b2
4277: WHERE mp.organization_id = wjsi_row.organization_id
4278: and bcd.exception_set_id = mp.calendar_exception_set_id
4279: and bcd.calendar_code = mp.calendar_code

Line 4293: mtl_parameters mp

4289: /*
4290: select calendar_date
4291: into wjsi_row.first_unit_completion_date
4292: from bom_calendar_dates bcd,
4293: mtl_parameters mp
4294: where mp.organization_id = wjsi_row.organization_id
4295: and bcd.exception_set_id = mp.calendar_exception_set_id
4296: and bcd.calendar_code = mp.calendar_code
4297: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 4307: mtl_parameters mp,

4303:
4304: SELECT bcd.calendar_date
4305: INTO wjsi_row.first_unit_completion_date
4306: FROM bom_calendar_dates bcd,
4307: mtl_parameters mp,
4308: bom_calendar_dates b2
4309: WHERE mp.organization_id = wjsi_row.organization_id
4310: and bcd.exception_set_id = mp.calendar_exception_set_id
4311: and bcd.calendar_code = mp.calendar_code

Line 4324: from bom_calendar_dates bcd, mtl_parameters mp

4320: -- saugupta 25th-May-2006
4321: /*
4322: select calendar_date
4323: into wjsi_row.last_unit_completion_date
4324: from bom_calendar_dates bcd, mtl_parameters mp
4325: where mp.organization_id = wjsi_row.organization_id
4326: and bcd.exception_set_id = mp.calendar_exception_set_id
4327: and bcd.calendar_code = mp.calendar_code
4328: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 4338: mtl_parameters mp,

4334:
4335: SELECT bcd.calendar_date
4336: INTO wjsi_row.last_unit_completion_date
4337: FROM bom_calendar_dates bcd,
4338: mtl_parameters mp,
4339: bom_calendar_dates b2
4340: WHERE mp.organization_id = wjsi_row.organization_id
4341: and bcd.exception_set_id = mp.calendar_exception_set_id
4342: and bcd.calendar_code = mp.calendar_code

Line 4591: mtl_parameters mp

4587:
4588: select sub.locator_type, mp.stock_locator_control_code
4589: into l_subLocCtl, l_orgLocCtl
4590: from mtl_secondary_inventories sub,
4591: mtl_parameters mp
4592: where sub.secondary_inventory_name = wjsi_row.completion_subinventory
4593: and sub.organization_id = wjsi_row.organization_id
4594: and mp.organization_id = wjsi_row.organization_id;
4595: