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 560: from wip_parameters wp, mtl_parameters mp, org_organization_definitions ood

556: -- sugupta 26th-May-2006
557: /*
558: select ood.disable_date
559: into l_disable_date
560: from wip_parameters wp, mtl_parameters mp, org_organization_definitions ood
561: where wp.organization_id = mp.organization_id
562: and wp.organization_id = ood.organization_id
563: and wp.organization_id = wjsi_row.organization_id;
564: */

Line 568: mtl_parameters mp ,

564: */
565: SELECT ood.date_to disable_date
566: INTO l_disable_date
567: FROM wip_parameters wp,
568: mtl_parameters mp ,
569: hr_organization_units ood
570: WHERE wp.organization_id = mp.organization_id
571: and wp.organization_id = ood.organization_id
572: and wp.organization_id = wjsi_row.organization_id;

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

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

Line 1438: from bom_calendar_dates bcd, mtl_parameters mp

1434: end if;
1435: if(wjsi_row.first_unit_start_date is not null) then
1436: select 1
1437: into g_dummy
1438: from bom_calendar_dates bcd, mtl_parameters mp
1439: where mp.organization_id = wjsi_row.organization_id
1440: and mp.calendar_code = bcd.calendar_code
1441: and mp.calendar_exception_set_id = bcd.exception_set_id
1442: and bcd.calendar_date = trunc(wjsi_row.first_unit_start_date);

Line 1447: from bom_calendar_dates bcd, mtl_parameters mp

1443: end if;
1444: if(wjsi_row.last_unit_completion_date is not null) then
1445: select 1
1446: into g_dummy
1447: from bom_calendar_dates bcd, mtl_parameters mp
1448: where mp.organization_id = wjsi_row.organization_id
1449: and mp.calendar_code = bcd.calendar_code
1450: and mp.calendar_exception_set_id = bcd.exception_set_id
1451: and bcd.calendar_date = trunc(wjsi_row.last_unit_completion_date);

Line 1541: from bom_calendar_dates bcd, mtl_parameters mp

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

Line 1554: mtl_parameters mp,

1550: */
1551: SELECT bcd.calendar_date
1552: INTO wjsi_row.first_unit_start_date
1553: FROM bom_calendar_dates bcd,
1554: mtl_parameters mp,
1555: bom_calendar_dates b2
1556: WHERE mp.organization_id = wjsi_row.organization_id
1557: and bcd.exception_set_id = mp.calendar_exception_set_id
1558: and bcd.calendar_code = mp.calendar_code

Line 1569: from bom_calendar_dates bcd, mtl_parameters mp

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

Line 1582: mtl_parameters mp,

1578: */
1579: SELECT bcd.calendar_date
1580: INTO wjsi_row.last_unit_start_date
1581: FROM bom_calendar_dates bcd,
1582: mtl_parameters mp,
1583: bom_calendar_dates b2
1584: WHERE mp.organization_id = wjsi_row.organization_id
1585: and bcd.exception_set_id = mp.calendar_exception_set_id
1586: and bcd.calendar_code = mp.calendar_code

Line 1597: from bom_calendar_dates bcd, mtl_parameters mp

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

Line 1610: mtl_parameters mp,

1606: */
1607: SELECT bcd.calendar_date
1608: INTO wjsi_row.first_unit_completion_date
1609: FROM bom_calendar_dates bcd,
1610: mtl_parameters mp,
1611: bom_calendar_dates b2
1612: WHERE mp.organization_id = wjsi_row.organization_id
1613: and bcd.exception_set_id = mp.calendar_exception_set_id
1614: and bcd.calendar_code = mp.calendar_code

Line 1625: from bom_calendar_dates bcd, mtl_parameters mp

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

Line 1638: mtl_parameters mp,

1634: */
1635: SELECT bcd.calendar_date
1636: INTO wjsi_row.last_unit_completion_date
1637: FROM bom_calendar_dates bcd,
1638: mtl_parameters mp,
1639: bom_calendar_dates b2
1640: WHERE mp.organization_id = wjsi_row.organization_id
1641: and bcd.exception_set_id = mp.calendar_exception_set_id
1642: and bcd.calendar_code = mp.calendar_code

Line 1864: from mtl_secondary_inventories sub, mtl_parameters mp

1860: wjsi_row.completion_subinventory is not null) then
1861: l_msg := 'WIP_ML_INVALID_LOCATOR';
1862: select sub.locator_type, mp.stock_locator_control_code
1863: into l_sub_loc_control, l_org_loc_control
1864: from mtl_secondary_inventories sub, mtl_parameters mp
1865: where sub.secondary_inventory_name = wjsi_row.completion_subinventory
1866: and sub.organization_id = wjsi_row.organization_id
1867: and mp.organization_id = wjsi_row.organization_id;
1868:

Line 1959: mtl_parameters mp

1955: begin
1956: select 1
1957: into g_dummy
1958: from pjm_unit_numbers_lov_v pun,
1959: mtl_parameters mp
1960: where pun.unit_number = wjsi_row.end_item_unit_number
1961: and mp.organization_id = wjsi_row.organization_id
1962: and mp.master_organization_id = pun.master_organization_id;
1963: exception

Line 2113: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp

2109: select 1
2110: into g_dummy
2111: from dual
2112: where exists(select 1
2113: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2114: where ccwac.class_code = wjsi_row.class_code
2115: and ccwac.organization_id = wjsi_row.organization_id
2116: and ccwac.class_type = wip_constants.discrete
2117: and mp.organization_id = wjsi_row.organization_id

Line 2150: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp

2146: select 1
2147: into g_dummy
2148: from dual
2149: where exists(select 1
2150: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2151: where ccwac.class_code = wjsi_row.class_code
2152: and ccwac.organization_id = wjsi_row.organization_id
2153: and ccwac.class_type = wip_constants.eam
2154: and mp.organization_id = wjsi_row.organization_id