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.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 34: SELECT A.RELATED_GROUP_ID FROM JTF_RS_GRP_RELATIONS A

30: p_start_date JTF_RS_GROUPS_DENORM.start_date_active%TYPE,
31: p_end_date JTF_RS_GROUPS_DENORM.end_date_active%TYPE) RETURN NUMBER
32: IS
33: CURSOR prnt_cur IS
34: SELECT A.RELATED_GROUP_ID FROM JTF_RS_GRP_RELATIONS A
35: WHERE A.GROUP_ID = P_GROUP_ID
36: AND NVL(A.DELETE_FLAG, 'N') <> 'Y'
37: AND A.START_DATE_ACTIVE <= P_START_DATE
38: AND NVL(P_END_DATE, P_START_DATE) <= NVL(A.END_DATE_ACTIVE,

Line 459: FROM jtf_rs_grp_relations rel

455: rel.start_date_active,
456: rel.end_date_active,
457: rel.delete_flag,
458: level
459: FROM jtf_rs_grp_relations rel
460: WHERE relation_type = 'PARENT_GROUP'
461: CONNECT BY rel.group_id = prior rel.related_group_id
462: AND NVL(rel.delete_flag, 'N') <> 'Y'
463: AND rel.related_group_id <> x_group_id

Line 503: FROM jtf_rs_grp_relations rel

499: rel.related_group_id,
500: rel.start_date_active,
501: rel.end_date_active,
502: level
503: FROM jtf_rs_grp_relations rel
504: WHERE relation_type = 'PARENT_GROUP'
505: CONNECT BY rel.related_group_id = prior rel.group_id
506: AND NVL(rel.delete_flag, 'N') <> 'Y'
507: AND rel.group_id <> x_group_id

Line 1232: FROM jtf_rs_grp_relations rel

1228: SELECT rel.group_id,
1229: rel.related_group_id,
1230: rel.start_date_active,
1231: rel.end_date_active
1232: FROM jtf_rs_grp_relations rel
1233: WHERE relation_type = 'PARENT_GROUP'
1234: CONNECT BY rel.related_group_id = prior rel.group_id
1235: AND NVL(rel.delete_flag, 'N') <> 'Y'
1236: AND rel.group_id <> x_group_id

Line 1440: from jtf_rs_grp_relations

1436: select group_id,
1437: related_group_id,
1438: start_date_active,
1439: end_date_active
1440: from jtf_rs_grp_relations
1441: where relation_type = 'PARENT_GROUP'
1442: connect by related_group_id = prior group_id
1443: and nvl(delete_flag, 'N') <> 'Y'
1444: -- and group_id <> l_group_id

Line 1469: FROM jtf_rs_grp_relations rel

1465: SELECT rel.group_id,
1466: rel.related_group_id,
1467: rel.start_date_active,
1468: rel.end_date_active
1469: FROM jtf_rs_grp_relations rel
1470: WHERE relation_type = 'PARENT_GROUP'
1471: AND related_group_id = l_related_group_id
1472: CONNECT BY rel.group_id = prior rel.related_group_id
1473: AND NVL(rel.delete_flag, 'N') <> 'Y'

Line 1486: FROM jtf_rs_grp_relations rel

1482: SELECT rel.group_id,
1483: rel.related_group_id,
1484: rel.start_date_active,
1485: rel.end_date_active
1486: FROM jtf_rs_grp_relations rel
1487: WHERE relation_type = 'PARENT_GROUP'
1488: CONNECT BY rel.group_id = prior rel.related_group_id
1489: AND NVL(rel.delete_flag, 'N') <> 'Y'
1490: --AND rel.related_group_id <> p_related_group_id

Line 1888: FROM jtf_rs_grp_relations rel

1884: rel.start_date_active,
1885: rel.end_date_active,
1886: rel.delete_flag,
1887: level
1888: FROM jtf_rs_grp_relations rel
1889: WHERE relation_type = 'PARENT_GROUP'
1890: CONNECT BY rel.group_id = prior rel.related_group_id
1891: AND NVL(rel.delete_flag, 'N') <> 'Y'
1892: AND rel.related_group_id <> x_group_id

Line 2308: FROM jtf_rs_grp_relations rel

2304: SELECT rel.group_id,
2305: rel.related_group_id,
2306: rel.start_date_active,
2307: rel.end_date_active
2308: FROM jtf_rs_grp_relations rel
2309: WHERE relation_type = 'PARENT_GROUP'
2310: CONNECT BY rel.related_group_id = prior rel.group_id
2311: AND NVL(rel.delete_flag, 'N') <> 'Y'
2312: AND rel.group_id <> x_group_id

Line 2526: FROM jtf_rs_grp_relations rel

2522: Value , NULL = Value
2523: Value1 , Value2 = least(value1, value2) */
2524: trunc(least(nvl(rel.end_date_active, p_least_end_date),
2525: nvl(p_least_end_date, rel.end_date_active))) least_end_date
2526: FROM jtf_rs_grp_relations rel
2527: WHERE relation_type = 'PARENT_GROUP'
2528: AND rel.group_id = p_group_id
2529: AND NVL(rel.delete_flag, 'N') <> 'Y'
2530: AND least(nvl(end_date_active, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR')),

Line 2583: FROM jtf_rs_grp_relations rel

2579: Value , NULL = Value
2580: Value1 , Value2 = least(value1, value2) */
2581: trunc(least(nvl(rel.end_date_active, p_least_end_date),
2582: nvl(p_least_end_date, rel.end_date_active))) least_end_date
2583: FROM jtf_rs_grp_relations rel
2584: WHERE relation_type = 'PARENT_GROUP'
2585: AND rel.related_group_id = p_group_id
2586: AND NVL(rel.delete_flag, 'N') <> 'Y'
2587: AND least(nvl(end_date_active, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR')),

Line 3511: FROM jtf_rs_grp_relations rel

3507: SELECT rel.group_id,
3508: rel.related_group_id,
3509: rel.start_date_active,
3510: rel.end_date_active
3511: FROM jtf_rs_grp_relations rel
3512: WHERE relation_type = 'PARENT_GROUP'
3513: AND related_group_id = l_related_group_id
3514: CONNECT BY rel.group_id = prior rel.related_group_id
3515: AND NVL(rel.delete_flag, 'N') <> 'Y'