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.MRP_HORIZONTAL_PLAN_SC dependencies on MRP_GET_PROJECT

Line 251: 3,nvl(mrp_get_project.planning_group(jobs.project_id),'-23453'),

247: WHERE (arg_res_level = 1
248: OR (arg_res_level = 2
249: AND jobs.project_id is NULL)
250: OR (DECODE(arg_res_level,
251: 3,nvl(mrp_get_project.planning_group(jobs.project_id),'-23453'),
252: 4,nvl(to_char(jobs.project_id), '-23453'))
253: = nvl(arg_resval1,'-23453'))
254: OR (arg_res_level = 5
255: AND nvl(to_char(jobs.project_id), '-23453')

Line 301: 3,nvl(mrp_get_project.planning_group(jobs.project_id),'-23453'),

297: WHERE (arg_res_level = 1
298: OR (arg_res_level = 2
299: AND jobs.project_id is NULL)
300: OR (DECODE(arg_res_level,
301: 3,nvl(mrp_get_project.planning_group(jobs.project_id),'-23453'),
302: 4,nvl(to_char(jobs.project_id), '-23453'))
303: = nvl(arg_resval1,'-23453'))
304: OR (arg_res_level = 5
305: AND nvl(to_char(jobs.project_id), '-23453')

Line 355: 3,nvl(mrp_get_project.planning_group(jobs.project_id),'-23453'),

351: WHERE (arg_res_level = 1
352: OR (arg_res_level = 2
353: AND jobs.project_id is NULL)
354: OR (DECODE(arg_res_level,
355: 3,nvl(mrp_get_project.planning_group(jobs.project_id),'-23453'),
356: 4,nvl(to_char(jobs.project_id), '-23453'))
357: = nvl(arg_resval1,'-23453'))
358: OR (arg_res_level = 5
359: AND nvl(to_char(jobs.project_id), '-23453')

Line 417: 3,nvl(mrp_get_project.planning_group(flow_sched.project_id),'-23453'),

413: WHERE (arg_res_level = 1
414: OR (arg_res_level = 2
415: AND flow_sched.project_id is NULL)
416: OR (DECODE(arg_res_level,
417: 3,nvl(mrp_get_project.planning_group(flow_sched.project_id),'-23453'),
418: 4,nvl(to_char(flow_sched.project_id), '-23453'))
419: = nvl(arg_resval1,'-23453'))
420: OR (arg_res_level = 5
421: AND nvl(to_char(flow_sched.project_id), '-23453')

Line 476: 3,nvl(mrp_get_project.planning_group(fs.project_id),'-23453'),

472: WHERE (arg_res_level = 1
473: OR (arg_res_level = 2
474: AND fs.project_id is NULL)
475: OR (DECODE(arg_res_level,
476: 3,nvl(mrp_get_project.planning_group(fs.project_id),'-23453'),
477: 4,nvl(to_char(fs.project_id), '-23453'))
478: = nvl(arg_resval1,'-23453'))
479: OR (arg_res_level = 5
480: AND nvl(to_char(fs.project_id), '-23453')

Line 559: 3,nvl(mrp_get_project.planning_group(fs.project_id),'-23453'),

555: WHERE (arg_res_level = 1
556: OR (arg_res_level = 2
557: AND fs.project_id is NULL)
558: OR (DECODE(arg_res_level,
559: 3,nvl(mrp_get_project.planning_group(fs.project_id),'-23453'),
560: 4,nvl(to_char(fs.project_id), '-23453'))
561: = nvl(arg_resval1,'-23453'))
562: OR (arg_res_level = 5
563: AND nvl(to_char(fs.project_id), '-23453')

Line 636: 3,nvl(mrp_get_project.planning_group(flow_sched.project_id),'-23453'),

632: WHERE (arg_res_level = 1
633: OR (arg_res_level = 2
634: AND flow_sched.project_id is NULL)
635: OR (DECODE(arg_res_level,
636: 3,nvl(mrp_get_project.planning_group(flow_sched.project_id),'-23453'),
637: 4,nvl(to_char(flow_sched.project_id), '-23453'))
638: = nvl(arg_resval1,'-23453'))
639: OR (arg_res_level = 5
640: AND nvl(to_char(flow_sched.project_id), '-23453')

Line 876: 3,nvl(mrp_get_project.planning_group(sched.project_id),'-23453'),

872: WHERE (arg_res_level = 1
873: OR (arg_res_level = 2
874: AND sched.project_id is NULL)
875: OR (DECODE(arg_res_level,
876: 3,nvl(mrp_get_project.planning_group(sched.project_id),'-23453'),
877: 4,nvl(to_char(sched.project_id), '-23453'))
878: = nvl(arg_resval1,'-23453'))
879: OR (arg_res_level = 5
880: AND nvl(to_char(sched.project_id), '-23453')

Line 960: 3,nvl(mrp_get_project.planning_group(fcst.project_id),'-23453'),

956: WHERE (arg_res_level = 1
957: OR (arg_res_level = 2
958: AND fcst.project_id is NULL)
959: OR (DECODE(arg_res_level,
960: 3,nvl(mrp_get_project.planning_group(fcst.project_id),'-23453'),
961: 4,nvl(to_char(fcst.project_id), '-23453'))
962: = nvl(arg_resval1,'-23453'))
963: OR (arg_res_level = 5
964: AND nvl(to_char(fcst.project_id), '-23453')

Line 1046: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),

1042: WHERE (arg_res_level = 1
1043: OR (arg_res_level = 2
1044: AND pd.project_id is NULL)
1045: OR (DECODE(arg_res_level,
1046: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),
1047: 4,nvl(to_char(pd.project_id), '-23453'))
1048: = nvl(arg_resval1,'-23453'))
1049: OR (arg_res_level = 5
1050: AND nvl(to_char(pd.project_id), '-23453')

Line 1104: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),

1100: WHERE (arg_res_level = 1
1101: OR (arg_res_level = 2
1102: AND pd.project_id is NULL)
1103: OR (DECODE(arg_res_level,
1104: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),
1105: 4,nvl(to_char(pd.project_id), '-23453'))
1106: = nvl(arg_resval1,'-23453'))
1107: OR (arg_res_level = 5
1108: AND nvl(to_char(pd.project_id), '-23453')

Line 1155: 3,nvl(mrp_get_project.planning_group(msub.project_id),'-23453'),

1151: WHERE (arg_res_level = 1
1152: OR (arg_res_level = 2
1153: AND msub.project_id is NULL)
1154: OR (DECODE(arg_res_level,
1155: 3,nvl(mrp_get_project.planning_group(msub.project_id),'-23453'),
1156: 4,nvl(to_char(msub.project_id), '-23453'))
1157: = nvl(arg_resval1,'-23453'))
1158: OR (arg_res_level = 5
1159: AND nvl(to_char(msub.project_id), '-23453')

Line 1212: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),

1208: WHERE (arg_res_level = 1
1209: OR (arg_res_level = 2
1210: AND pd.project_id is NULL)
1211: OR (DECODE(arg_res_level,
1212: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),
1213: 4,nvl(to_char(pd.project_id), '-23453'))
1214: = nvl(arg_resval1,'-23453'))
1215: OR (arg_res_level = 5
1216: AND nvl(to_char(pd.project_id), '-23453')

Line 1275: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),

1271: WHERE (arg_res_level = 1
1272: OR (arg_res_level = 2
1273: AND pd.project_id is NULL)
1274: OR (DECODE(arg_res_level,
1275: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),
1276: 4,nvl(to_char(pd.project_id), '-23453'))
1277: = nvl(arg_resval1,'-23453'))
1278: OR (arg_res_level = 5
1279: AND nvl(to_char(pd.project_id), '-23453')

Line 1328: 3,nvl(mrp_get_project.planning_group(msub.project_id),'-23453'),

1324: WHERE (arg_res_level = 1
1325: OR (arg_res_level = 2
1326: AND msub.project_id is NULL)
1327: OR (DECODE(arg_res_level,
1328: 3,nvl(mrp_get_project.planning_group(msub.project_id),'-23453'),
1329: 4,nvl(to_char(msub.project_id), '-23453'))
1330: = nvl(arg_resval1,'-23453'))
1331: OR (arg_res_level = 5
1332: AND nvl(to_char(msub.project_id), '-23453')

Line 1382: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),

1378: WHERE (arg_res_level = 1
1379: OR (arg_res_level = 2
1380: AND pd.project_id is NULL)
1381: OR (DECODE(arg_res_level,
1382: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),
1383: 4,nvl(to_char(pd.project_id), '-23453'))
1384: = nvl(arg_resval1,'-23453'))
1385: OR (arg_res_level = 5
1386: AND nvl(to_char(pd.project_id), '-23453')

Line 1439: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),

1435: WHERE (arg_res_level = 1
1436: OR (arg_res_level = 2
1437: AND pd.project_id is NULL)
1438: OR (DECODE(arg_res_level,
1439: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),
1440: 4,nvl(to_char(pd.project_id), '-23453'))
1441: = nvl(arg_resval1,'-23453'))
1442: OR (arg_res_level = 5
1443: AND nvl(to_char(pd.project_id), '-23453')

Line 1496: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),

1492: WHERE (arg_res_level = 1
1493: OR (arg_res_level = 2
1494: AND pd.project_id is NULL)
1495: OR (DECODE(arg_res_level,
1496: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),
1497: 4,nvl(to_char(pd.project_id), '-23453'))
1498: = nvl(arg_resval1,'-23453'))
1499: OR (arg_res_level = 5
1500: AND nvl(to_char(pd.project_id), '-23453')

Line 1548: 3,nvl(mrp_get_project.planning_group(msub.project_id),'-23453'),

1544: WHERE (arg_res_level = 1
1545: OR (arg_res_level = 2
1546: AND msub.project_id is NULL)
1547: OR (DECODE(arg_res_level,
1548: 3,nvl(mrp_get_project.planning_group(msub.project_id),'-23453'),
1549: 4,nvl(to_char(msub.project_id), '-23453'))
1550: = nvl(arg_resval1,'-23453'))
1551: OR (arg_res_level = 5
1552: AND nvl(to_char(msub.project_id), '-23453')

Line 1603: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),

1599: WHERE (arg_res_level = 1
1600: OR (arg_res_level = 2
1601: AND pd.project_id is NULL)
1602: OR (DECODE(arg_res_level,
1603: 3,nvl(mrp_get_project.planning_group(pd.project_id),'-23453'),
1604: 4,nvl(to_char(pd.project_id), '-23453'))
1605: = nvl(arg_resval1,'-23453'))
1606: OR (arg_res_level = 5
1607: AND nvl(to_char(pd.project_id), '-23453')

Line 2096: 3,nvl(mrp_get_project.planning_group(sl.project_id),'-23453'),

2092: WHERE (arg_res_level = 1
2093: OR (arg_res_level = 2
2094: AND sl.project_id is NULL)
2095: OR (DECODE(arg_res_level,
2096: 3,nvl(mrp_get_project.planning_group(sl.project_id),'-23453'),
2097: 4,nvl(to_char(sl.project_id), '-23453'))
2098: = nvl(arg_resval1,'-23453'))
2099: OR (arg_res_level = 5
2100: AND nvl(to_char(sl.project_id), '-23453')

Line 2181: 3,nvl(mrp_get_project.planning_group(mil.project_id),'-23453'),

2177: WHERE (arg_res_level = 1
2178: OR (arg_res_level = 2
2179: AND mil.project_id is NULL)
2180: OR (DECODE(arg_res_level,
2181: 3,nvl(mrp_get_project.planning_group(mil.project_id),'-23453'),
2182: 4,nvl(to_char(mil.project_id), '-23453'))
2183: = nvl(arg_resval1,'-23453'))
2184: OR (arg_res_level = 5
2185: AND nvl(to_char(mil.project_id), '-23453')

Line 2247: 3,nvl(mrp_get_project.planning_group(mil.project_id),'-23453'),

2243: WHERE (arg_res_level = 1
2244: OR (arg_res_level = 2
2245: AND mil.project_id is NULL)
2246: OR (DECODE(arg_res_level,
2247: 3,nvl(mrp_get_project.planning_group(mil.project_id),'-23453'),
2248: 4,nvl(to_char(mil.project_id), '-23453')) = nvl(arg_resval1,'-23453'))
2249: OR (arg_res_level = 5
2250: AND nvl(to_char(mil.project_id), '-23453')
2251: = nvl(arg_resval1,'-23453')

Line 2325: 3,nvl(mrp_get_project.planning_group(mil.project_id),'-23453'),

2321: (arg_res_level = 1
2322: OR (arg_res_level = 2
2323: AND mil.project_id is NULL)
2324: OR (DECODE(arg_res_level,
2325: 3,nvl(mrp_get_project.planning_group(mil.project_id),'-23453'),
2326: 4,nvl(to_char(mil.project_id), '-23453')) = nvl(arg_resval1,'-23453'))
2327: OR (arg_res_level = 5
2328: AND nvl(to_char(mil.project_id), '-23453')
2329: = nvl(arg_resval1,'-23453')

Line 2379: 3,nvl(mrp_get_project.planning_group(mmtt.project_id),'-23453'),

2375: (arg_res_level = 1
2376: OR (arg_res_level = 2
2377: AND mmtt.project_id is NULL)
2378: OR (DECODE(arg_res_level,
2379: 3,nvl(mrp_get_project.planning_group(mmtt.project_id),'-23453'),
2380: 4,nvl(to_char(mmtt.project_id), '-23453'))
2381: = nvl(arg_resval1,'-23453'))
2382: OR (arg_res_level = 5
2383: AND nvl(to_char(mmtt.project_id), '-23453')

Line 2446: OR(DECODE(arg_res_level,3,nvl(mrp_get_project.planning_group(mmtt.project_id),'-23453'),

2442: mrp_form_query list
2443: WHERE
2444: (arg_res_level = 1
2445: OR(arg_res_level = 2 AND mmtt.project_id is NULL)
2446: OR(DECODE(arg_res_level,3,nvl(mrp_get_project.planning_group(mmtt.project_id),'-23453'),
2447: 4,nvl(to_char(mmtt.project_id), '-23453')) = nvl(arg_resval1,'-23453'))
2448: OR (arg_res_level = 5 AND nvl(to_char(mmtt.project_id), '-23453') = nvl(arg_resval1,'-23453')
2449: AND nvl(mmtt.task_id, -23453) = nvl(arg_resval2, -23453)))
2450: AND EXISTS

Line 2514: OR(DECODE(arg_res_level,3,nvl(mrp_get_project.planning_group(mmtt.project_id),'-23453'),

2510: mrp_form_query list
2511: WHERE
2512: (arg_res_level = 1
2513: OR(arg_res_level = 2 AND mmtt.project_id is NULL)
2514: OR(DECODE(arg_res_level,3,nvl(mrp_get_project.planning_group(mmtt.project_id),'-23453'),
2515: 4,nvl(to_char(mmtt.project_id), '-23453')) = nvl(arg_resval1,'-23453'))
2516: OR (arg_res_level = 5 AND nvl(to_char(mmtt.project_id), '-23453') = nvl(arg_resval1,'-23453')
2517: AND nvl(mmtt.task_id, -23453) = nvl(arg_resval2, -23453)))
2518: AND EXISTS

Line 2585: OR(DECODE(arg_res_level,3,nvl(mrp_get_project.planning_group(MTRL.project_id),'-23453'),

2581: MRP_FORM_QUERY list
2582: where
2583: (arg_res_level = 1
2584: OR(arg_res_level = 2 AND MTRL.project_id is NULL)
2585: OR(DECODE(arg_res_level,3,nvl(mrp_get_project.planning_group(MTRL.project_id),'-23453'),
2586: 4,nvl(to_char(MTRL.project_id), '-23453')) = nvl(arg_resval1,'-23453'))
2587: OR (arg_res_level = 5 AND nvl(to_char(MTRL.project_id), '-23453') = nvl(arg_resval1,'-23453')
2588: AND nvl(MTRL.task_id, -23453) = nvl(arg_resval2, -23453)))
2589: AND ITEMS.ORGANIZATION_ID = ORG.PLANNED_ORGANIZATION