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 414: from mtl_parameters ood

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

Line 446: from mtl_parameters ood

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

Line 467: mtl_parameters mp,

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

Line 2992: mtl_parameters mp

2988: (wjsi.first_unit_start_date is null and wjsi.last_unit_completion_date is not null))) */
2989: or (wjsi.first_unit_start_date is not null and
2990: not exists (select 1
2991: from bom_calendar_dates bcd,
2992: mtl_parameters mp
2993: where mp.organization_id = wjsi.organization_id
2994: and mp.calendar_code = bcd.calendar_code
2995: and mp.calendar_exception_set_id = bcd.exception_set_id
2996: and bcd.calendar_date = trunc(wjsi.first_unit_start_date)))

Line 3000: mtl_parameters mp

2996: and bcd.calendar_date = trunc(wjsi.first_unit_start_date)))
2997: or (wjsi.last_unit_completion_date is not null and
2998: not exists (select 1
2999: from bom_calendar_dates bcd,
3000: mtl_parameters mp
3001: where mp.organization_id = wjsi.organization_id
3002: and mp.calendar_code = bcd.calendar_code
3003: and mp.calendar_exception_set_id = bcd.exception_set_id
3004: and bcd.calendar_date = trunc(wjsi.last_unit_completion_date))))

Line 3141: mtl_parameters mp,

3137: /*
3138: select ood.operating_unit
3139: into l_operatingUnit
3140: from wip_parameters wp,
3141: mtl_parameters mp,
3142: org_organization_definitions ood
3143: where wp.organization_id = mp.organization_id
3144: and wp.organization_id = ood.organization_id
3145: and wp.organization_id = wjsi_row.organization_id

Line 3155: mtl_parameters mp,

3151: to_number(hoi.org_information3), to_number(null)) operating_unit
3152: INTO l_operatingUnit
3153: FROM hr_organization_units hou,
3154: wip_parameters wp,
3155: mtl_parameters mp,
3156: hr_organization_information hoi
3157: WHERE hou.organization_id = hoi.organization_id
3158: and ( hoi.org_information_context || '') = 'Accounting Information'
3159: and wp.organization_id = mp.organization_id

Line 3564: mtl_parameters mp

3560: select mpv.project_id --this query will return multiple rows if the project has tasks
3561: into l_dummy
3562: from pjm_projects_v mpv,
3563: pjm_project_parameters ppp,
3564: mtl_parameters mp
3565: where mpv.project_id = ppp.project_id
3566: and mpv.project_id = wjsi_row.project_id
3567: and ppp.organization_id = wjsi_row.organization_id
3568: and ppp.organization_id = mp.organization_id

Line 3725: from cst_cg_wip_acct_classes_v ccwac,mtl_parameters mp

3721:
3722: select 1 into l_dummy
3723: from
3724: ( SELECT DISTINCT ccwac.class_code
3725: from cst_cg_wip_acct_classes_v ccwac,mtl_parameters mp
3726: where ccwac.class_code = wjsi_row.class_code
3727: and ccwac.organization_id = wjsi_row.organization_id
3728: and ccwac.class_type = wip_constants.discrete
3729: AND ccwac.organization_id=mp.organization_id

Line 3732: FROM cst_cg_wip_acct_classes_v ccwac2 ,mtl_parameters mp

3728: and ccwac.class_type = wip_constants.discrete
3729: AND ccwac.organization_id=mp.organization_id
3730: AND ( not exists
3731: (SELECT 1
3732: FROM cst_cg_wip_acct_classes_v ccwac2 ,mtl_parameters mp
3733: WHERE mp.organization_id=wjsi_row.organization_id
3734: AND ccwac2.cost_group_id = mp.default_cost_group_id
3735: AND ccwac2.organization_id = mp.organization_id
3736: AND ccwac2.class_type=wip_constants.discrete

Line 3745: mtl_parameters mp

3741: select 1 into l_dummy
3742: from dual
3743: where exists(select 1
3744: from cst_cg_wip_acct_classes_v ccwac,
3745: mtl_parameters mp
3746: where ccwac.class_code = wjsi_row.class_code
3747: and ccwac.organization_id = wjsi_row.organization_id
3748: and ccwac.class_type = wip_constants.discrete
3749: and mp.organization_id = wjsi_row.organization_id

Line 4143: mtl_parameters mp

4139: begin
4140: select 1
4141: into l_dummy
4142: from pjm_unit_numbers_lov_v pun,
4143: mtl_parameters mp
4144: where pun.unit_number = wjsi_row.end_item_unit_number
4145: and mp.organization_id = wjsi_row.organization_id
4146: and mp.master_organization_id = pun.master_organization_id;
4147: exception

Line 4360: mtl_parameters mp

4356: /*
4357: select calendar_date
4358: into wjsi_row.first_unit_start_date
4359: from bom_calendar_dates bcd,
4360: mtl_parameters mp
4361: where mp.organization_id = wjsi_row.organization_id
4362: and bcd.exception_set_id = mp.calendar_exception_set_id
4363: and bcd.calendar_code = mp.calendar_code
4364: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 4373: mtl_parameters mp,

4369: */
4370: SELECT bcd.calendar_date
4371: INTO wjsi_row.first_unit_start_date
4372: FROM bom_calendar_dates bcd,
4373: mtl_parameters mp,
4374: bom_calendar_dates b2
4375: WHERE mp.organization_id = wjsi_row.organization_id
4376: and bcd.exception_set_id = mp.calendar_exception_set_id
4377: and bcd.calendar_code = mp.calendar_code

Line 4391: mtl_parameters mp

4387: /*
4388: select calendar_date
4389: into wjsi_row.last_unit_start_date
4390: from bom_calendar_dates bcd,
4391: mtl_parameters mp
4392: where mp.organization_id = wjsi_row.organization_id
4393: and bcd.exception_set_id = mp.calendar_exception_set_id
4394: and bcd.calendar_code = mp.calendar_code
4395: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 4404: mtl_parameters mp,

4400: */
4401: SELECT bcd.calendar_date
4402: INTO wjsi_row.last_unit_start_date
4403: FROM bom_calendar_dates bcd,
4404: mtl_parameters mp,
4405: bom_calendar_dates b2
4406: WHERE mp.organization_id = wjsi_row.organization_id
4407: and bcd.exception_set_id = mp.calendar_exception_set_id
4408: and bcd.calendar_code = mp.calendar_code

Line 4422: mtl_parameters mp

4418: /*
4419: select calendar_date
4420: into wjsi_row.first_unit_completion_date
4421: from bom_calendar_dates bcd,
4422: mtl_parameters mp
4423: where mp.organization_id = wjsi_row.organization_id
4424: and bcd.exception_set_id = mp.calendar_exception_set_id
4425: and bcd.calendar_code = mp.calendar_code
4426: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 4436: mtl_parameters mp,

4432:
4433: SELECT bcd.calendar_date
4434: INTO wjsi_row.first_unit_completion_date
4435: FROM bom_calendar_dates bcd,
4436: mtl_parameters mp,
4437: bom_calendar_dates b2
4438: WHERE mp.organization_id = wjsi_row.organization_id
4439: and bcd.exception_set_id = mp.calendar_exception_set_id
4440: and bcd.calendar_code = mp.calendar_code

Line 4453: from bom_calendar_dates bcd, mtl_parameters mp

4449: -- saugupta 25th-May-2006
4450: /*
4451: select calendar_date
4452: into wjsi_row.last_unit_completion_date
4453: from bom_calendar_dates bcd, mtl_parameters mp
4454: where mp.organization_id = wjsi_row.organization_id
4455: and bcd.exception_set_id = mp.calendar_exception_set_id
4456: and bcd.calendar_code = mp.calendar_code
4457: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 4467: mtl_parameters mp,

4463:
4464: SELECT bcd.calendar_date
4465: INTO wjsi_row.last_unit_completion_date
4466: FROM bom_calendar_dates bcd,
4467: mtl_parameters mp,
4468: bom_calendar_dates b2
4469: WHERE mp.organization_id = wjsi_row.organization_id
4470: and bcd.exception_set_id = mp.calendar_exception_set_id
4471: and bcd.calendar_code = mp.calendar_code

Line 4720: mtl_parameters mp

4716:
4717: select sub.locator_type, mp.stock_locator_control_code
4718: into l_subLocCtl, l_orgLocCtl
4719: from mtl_secondary_inventories sub,
4720: mtl_parameters mp
4721: where sub.secondary_inventory_name = wjsi_row.completion_subinventory
4722: and sub.organization_id = wjsi_row.organization_id
4723: and mp.organization_id = wjsi_row.organization_id;
4724: