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_JSI_VALIDATOR dependencies on MTL_PARAMETERS

Line 555: from wip_parameters wp, mtl_parameters mp, org_organization_definitions ood

551: -- sugupta 26th-May-2006
552: /*
553: select ood.disable_date
554: into l_disable_date
555: from wip_parameters wp, mtl_parameters mp, org_organization_definitions ood
556: where wp.organization_id = mp.organization_id
557: and wp.organization_id = ood.organization_id
558: and wp.organization_id = wjsi_row.organization_id;
559: */

Line 563: mtl_parameters mp ,

559: */
560: SELECT ood.date_to disable_date
561: INTO l_disable_date
562: FROM wip_parameters wp,
563: mtl_parameters mp ,
564: hr_organization_units ood
565: WHERE wp.organization_id = mp.organization_id
566: and wp.organization_id = ood.organization_id
567: and wp.organization_id = wjsi_row.organization_id;

Line 1320: from pjm_projects_v mpv, pjm_project_parameters ppp, mtl_parameters mp

1316: -- Bug 4890215. Performance Fix
1317: -- sugupta 26th-May-2006
1318: select mpv.project_id --this query will return multiple rows if the project has tasks
1319: into g_dummy
1320: from pjm_projects_v mpv, pjm_project_parameters ppp, mtl_parameters mp
1321: where mpv.project_id = ppp.project_id
1322: and mpv.project_id = wjsi_row.project_id
1323: and ppp.organization_id = wjsi_row.organization_id
1324: and ppp.organization_id = mp.organization_id

Line 1433: from bom_calendar_dates bcd, mtl_parameters mp

1429: end if;
1430: if(wjsi_row.first_unit_start_date is not null) then
1431: select 1
1432: into g_dummy
1433: from bom_calendar_dates bcd, mtl_parameters mp
1434: where mp.organization_id = wjsi_row.organization_id
1435: and mp.calendar_code = bcd.calendar_code
1436: and mp.calendar_exception_set_id = bcd.exception_set_id
1437: and bcd.calendar_date = trunc(wjsi_row.first_unit_start_date);

Line 1442: from bom_calendar_dates bcd, mtl_parameters mp

1438: end if;
1439: if(wjsi_row.last_unit_completion_date is not null) then
1440: select 1
1441: into g_dummy
1442: from bom_calendar_dates bcd, mtl_parameters mp
1443: where mp.organization_id = wjsi_row.organization_id
1444: and mp.calendar_code = bcd.calendar_code
1445: and mp.calendar_exception_set_id = bcd.exception_set_id
1446: and bcd.calendar_date = trunc(wjsi_row.last_unit_completion_date);

Line 1536: from bom_calendar_dates bcd, mtl_parameters mp

1532: -- sugupta 26th-May-2006
1533: /*
1534: select calendar_date
1535: into wjsi_row.first_unit_start_date
1536: from bom_calendar_dates bcd, mtl_parameters mp
1537: where mp.organization_id = wjsi_row.organization_id
1538: and bcd.exception_set_id = mp.calendar_exception_set_id
1539: and bcd.calendar_code = mp.calendar_code
1540: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 1549: mtl_parameters mp,

1545: */
1546: SELECT bcd.calendar_date
1547: INTO wjsi_row.first_unit_start_date
1548: FROM bom_calendar_dates bcd,
1549: mtl_parameters mp,
1550: bom_calendar_dates b2
1551: WHERE mp.organization_id = wjsi_row.organization_id
1552: and bcd.exception_set_id = mp.calendar_exception_set_id
1553: and bcd.calendar_code = mp.calendar_code

Line 1564: from bom_calendar_dates bcd, mtl_parameters mp

1560: -- sugupta 26th-May-2006
1561: /*
1562: select calendar_date
1563: into wjsi_row.last_unit_start_date
1564: from bom_calendar_dates bcd, mtl_parameters mp
1565: where mp.organization_id = wjsi_row.organization_id
1566: and bcd.exception_set_id = mp.calendar_exception_set_id
1567: and bcd.calendar_code = mp.calendar_code
1568: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 1577: mtl_parameters mp,

1573: */
1574: SELECT bcd.calendar_date
1575: INTO wjsi_row.last_unit_start_date
1576: FROM bom_calendar_dates bcd,
1577: mtl_parameters mp,
1578: bom_calendar_dates b2
1579: WHERE mp.organization_id = wjsi_row.organization_id
1580: and bcd.exception_set_id = mp.calendar_exception_set_id
1581: and bcd.calendar_code = mp.calendar_code

Line 1592: from bom_calendar_dates bcd, mtl_parameters mp

1588: -- sugupta 26th-May-2006
1589: /*
1590: select calendar_date
1591: into wjsi_row.first_unit_completion_date
1592: from bom_calendar_dates bcd, mtl_parameters mp
1593: where mp.organization_id = wjsi_row.organization_id
1594: and bcd.exception_set_id = mp.calendar_exception_set_id
1595: and bcd.calendar_code = mp.calendar_code
1596: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 1605: mtl_parameters mp,

1601: */
1602: SELECT bcd.calendar_date
1603: INTO wjsi_row.first_unit_completion_date
1604: FROM bom_calendar_dates bcd,
1605: mtl_parameters mp,
1606: bom_calendar_dates b2
1607: WHERE mp.organization_id = wjsi_row.organization_id
1608: and bcd.exception_set_id = mp.calendar_exception_set_id
1609: and bcd.calendar_code = mp.calendar_code

Line 1620: from bom_calendar_dates bcd, mtl_parameters mp

1616: -- sugupta 26th-May-2006
1617: /*
1618: select calendar_date
1619: into wjsi_row.last_unit_completion_date
1620: from bom_calendar_dates bcd, mtl_parameters mp
1621: where mp.organization_id = wjsi_row.organization_id
1622: and bcd.exception_set_id = mp.calendar_exception_set_id
1623: and bcd.calendar_code = mp.calendar_code
1624: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 1633: mtl_parameters mp,

1629: */
1630: SELECT bcd.calendar_date
1631: INTO wjsi_row.last_unit_completion_date
1632: FROM bom_calendar_dates bcd,
1633: mtl_parameters mp,
1634: bom_calendar_dates b2
1635: WHERE mp.organization_id = wjsi_row.organization_id
1636: and bcd.exception_set_id = mp.calendar_exception_set_id
1637: and bcd.calendar_code = mp.calendar_code

Line 1859: from mtl_secondary_inventories sub, mtl_parameters mp

1855: wjsi_row.completion_subinventory is not null) then
1856: l_msg := 'WIP_ML_INVALID_LOCATOR';
1857: select sub.locator_type, mp.stock_locator_control_code
1858: into l_sub_loc_control, l_org_loc_control
1859: from mtl_secondary_inventories sub, mtl_parameters mp
1860: where sub.secondary_inventory_name = wjsi_row.completion_subinventory
1861: and sub.organization_id = wjsi_row.organization_id
1862: and mp.organization_id = wjsi_row.organization_id;
1863:

Line 1954: mtl_parameters mp

1950: begin
1951: select 1
1952: into g_dummy
1953: from pjm_unit_numbers_lov_v pun,
1954: mtl_parameters mp
1955: where pun.unit_number = wjsi_row.end_item_unit_number
1956: and mp.organization_id = wjsi_row.organization_id
1957: and mp.master_organization_id = pun.master_organization_id;
1958: exception

Line 2108: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp

2104: select 1
2105: into g_dummy
2106: from dual
2107: where exists(select 1
2108: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2109: where ccwac.class_code = wjsi_row.class_code
2110: and ccwac.organization_id = wjsi_row.organization_id
2111: and ccwac.class_type = wip_constants.discrete
2112: and mp.organization_id = wjsi_row.organization_id

Line 2145: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp

2141: select 1
2142: into g_dummy
2143: from dual
2144: where exists(select 1
2145: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2146: where ccwac.class_code = wjsi_row.class_code
2147: and ccwac.organization_id = wjsi_row.organization_id
2148: and ccwac.class_type = wip_constants.eam
2149: and mp.organization_id = wjsi_row.organization_id