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.GMP_CALENDAR_PKG dependencies on GMP_RESOURCE_INSTANCES

Line 369: ||' gmp_resource_instances'||p_db_link||' gri, '

365: ||' gri.eff_start_date, '
366: ||' gri.eff_end_date, '
367: ||' 2 '
368: ||' FROM '
369: ||' gmp_resource_instances'||p_db_link||' gri, '
370: ||' cr_rsrc_dtl'||p_db_link||' c, '
371: ||' hr_organization_units'||p_db_link||' hr, '
372: ||' mtl_parameters'||p_db_link||' m '
373: ||' WHERE '

Line 712: || ' gmp_resource_instances'||p_db_link||' gri, '

708: || ' gra.to_time, '
709: || ' ((gra.organization_id*2)+1) department_id, '/* encoded */
710: || ' :instance_id '
711: || ' FROM '
712: || ' gmp_resource_instances'||p_db_link||' gri, '
713: || ' gmp_resource_avail'||p_db_link||' gra, '
714: || ' mtl_parameters'||p_db_link||' m, '
715: || ' cr_rsrc_dtl'||p_db_link||' crd '
716: || ' WHERE gri.resource_id = gra.resource_id '

Line 1313: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;

1309:
1310: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;
1311: resource_id rsrc_id ;
1312:
1313: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
1314: instance_id inst_id ;
1315:
1316: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
1317: instance_number inst_num ;

Line 1316: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;

1312:
1313: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
1314: instance_id inst_id ;
1315:
1316: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
1317: instance_number inst_num ;
1318:
1319: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
1320: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;

Line 1393: || ' gmp_resource_instances'||p_db_link||' gri '

1389: || ' un.to_date, '
1390: || ' 1 resource_units'
1391: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1392: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1393: || ' gmp_resource_instances'||p_db_link||' gri '
1394: || ' WHERE crd.resource_id = un.resource_id '
1395: || ' AND crd.resource_id = gri.resource_id '
1396: || ' AND un.instance_id = gri.instance_id '
1397: || ' AND crd.schedule_ind = 2 '

Line 1416: || ' gmp_resource_instances'||p_db_link||' gri '

1412: || ' un.to_date, '
1413: || ' 1 resource_units'
1414: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1415: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1416: || ' gmp_resource_instances'||p_db_link||' gri '
1417: || ' WHERE crd.resource_id = un.resource_id '
1418: || ' AND crd.resource_id = gri.resource_id '
1419: || ' AND crd.delete_mark = 0 '
1420: || ' AND crd.schedule_ind = 2 '

Line 1432: || ' FROM gmp_resource_instances'||p_db_link||' tgri '

1428:
1429: sql_stmt1 := sql_stmt1
1430: || ' AND gri.instance_number in '
1431: || ' ( select tgri.instance_number '
1432: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
1433: || ' WHERE tgri.resource_id = crd.resource_id '
1434: || ' AND rownum <= un.resource_units '
1435: || ' ) '
1436: || ' UNION ALL '

Line 1456: || ' FROM gmp_resource_instances'||p_db_link||' gri '

1452:
1453: sql_stmt1 := sql_stmt1
1454: || ' AND NOT EXISTS '
1455: || ' (SELECT 1 '
1456: || ' FROM gmp_resource_instances'||p_db_link||' gri '
1457: || ' WHERE gri.resource_id = un.resource_id ) '
1458: || ' ) '
1459: || ' ) u, '
1460: || ' ( '

Line 1490: || ' gmp_resource_instances'||p_db_link||' gri '

1486: || ' un.from_date interval_date, '
1487: || ' crd.assigned_qty assigned_qty '
1488: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1489: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1490: || ' gmp_resource_instances'||p_db_link||' gri '
1491: || ' WHERE crd.resource_id = un.resource_id '
1492: || ' AND crd.resource_id = gri.resource_id '
1493: || ' AND un.instance_id = gri.instance_id '
1494: || ' AND crd.schedule_ind = 2 '

Line 1514: || ' gmp_resource_instances'||p_db_link||' gri '

1510: || ' un.to_date interval_date, '
1511: || ' crd.assigned_qty assigned_qty '
1512: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1513: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1514: || ' gmp_resource_instances'||p_db_link||' gri '
1515: || ' WHERE crd.resource_id = un.resource_id '
1516: || ' AND crd.resource_id = gri.resource_id '
1517: || ' AND un.instance_id = gri.instance_id '
1518: || ' AND crd.schedule_ind = 2 '

Line 1538: || ' gmp_resource_instances'||p_db_link||' gri '

1534: || ' un.from_date interval_date, '
1535: || ' crd.assigned_qty assigned_qty '
1536: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1537: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1538: || ' gmp_resource_instances'||p_db_link||' gri '
1539: || ' WHERE crd.resource_id = un.resource_id '
1540: || ' AND crd.resource_id = gri.resource_id '
1541: || ' AND crd.schedule_ind = 2 '
1542: || ' AND crd.delete_mark = 0 '

Line 1554: || ' FROM gmp_resource_instances'||p_db_link||' tgri '

1550:
1551: sql_stmt1 := sql_stmt1
1552: || ' AND gri.instance_number in '
1553: || ' ( select tgri.instance_number '
1554: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
1555: || ' WHERE tgri.resource_id = crd.resource_id '
1556: || ' AND rownum <= un.resource_units '
1557: || ' ) '
1558: || ' UNION ALL '

Line 1567: || ' gmp_resource_instances'||p_db_link||' gri '

1563: || ' un.to_date interval_date, '
1564: || ' crd.assigned_qty assigned_qty '
1565: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1566: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1567: || ' gmp_resource_instances'||p_db_link||' gri '
1568: || ' WHERE crd.resource_id = un.resource_id '
1569: || ' AND crd.resource_id = gri.resource_id '
1570: || ' AND crd.delete_mark = 0 '
1571: || ' AND crd.schedule_ind = 2 '

Line 1583: || ' FROM gmp_resource_instances'||p_db_link||' tgri '

1579:
1580: sql_stmt1 := sql_stmt1
1581: || ' AND gri.instance_number in '
1582: || ' ( select tgri.instance_number '
1583: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
1584: || ' WHERE tgri.resource_id = crd.resource_id '
1585: || ' AND rownum <= un.resource_units '
1586: || ' ) '
1587: || ' UNION ALL '

Line 1608: || ' FROM gmp_resource_instances'||p_db_link||' gri '

1604:
1605: sql_stmt1 := sql_stmt1
1606: || ' AND NOT EXISTS '
1607: || ' (SELECT 1 '
1608: || ' FROM gmp_resource_instances'||p_db_link||' gri '
1609: || ' WHERE gri.resource_id = un.resource_id ) '
1610: || ' UNION ALL '
1611: || ' SELECT un.resource_id, '
1612: || ' 0 instance_number, '

Line 1631: || ' FROM gmp_resource_instances'||p_db_link||' gri '

1627:
1628: sql_stmt1 := sql_stmt1
1629: || ' AND NOT EXISTS '
1630: || ' (SELECT 1 '
1631: || ' FROM gmp_resource_instances'||p_db_link||' gri '
1632: || ' WHERE gri.resource_id = un.resource_id ) '
1633: || ' ) cmd, '
1634: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1635: || ' WHERE exp.calendar_code = :CAL91 '

Line 2153: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;

2149:
2150: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;
2151: resource_id rsrc_id ;
2152:
2153: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
2154: instance_id inst_id ;
2155:
2156: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
2157: instance_number inst_num ;

Line 2156: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;

2152:
2153: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
2154: instance_id inst_id ;
2155:
2156: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
2157: instance_number inst_num ;
2158:
2159: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
2160: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;

Line 2228: || ' gmp_resource_instances'||p_db_link||' gri '

2224: || ' un.to_date, '
2225: || ' 1 resource_units'
2226: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2227: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2228: || ' gmp_resource_instances'||p_db_link||' gri '
2229: || ' WHERE crd.resource_id = un.resource_id '
2230: || ' AND crd.resource_id = gri.resource_id '
2231: || ' AND un.instance_id = gri.instance_id '
2232: || ' AND crd.organization_id = :orgn_id1 '

Line 2251: || ' gmp_resource_instances'||p_db_link||' gri '

2247: || ' un.to_date, '
2248: || ' 1 resource_units'
2249: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2250: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2251: || ' gmp_resource_instances'||p_db_link||' gri '
2252: || ' WHERE crd.resource_id = un.resource_id '
2253: || ' AND crd.resource_id = gri.resource_id '
2254: || ' AND crd.organization_id = :orgn_id2 '
2255: || ' AND nvl(crd.calendar_code,:g_default_cal_code2)=:l_cal_code2'

Line 2267: || ' FROM gmp_resource_instances'||p_db_link||' tgri '

2263:
2264: sql_stmt1 := sql_stmt1
2265: || ' AND gri.instance_number in '
2266: || ' ( select tgri.instance_number '
2267: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
2268: || ' WHERE tgri.resource_id = crd.resource_id '
2269: || ' AND rownum <= un.resource_units '
2270: || ' ) '
2271: || ' ) '

Line 2304: || ' gmp_resource_instances'||p_db_link||' gri '

2300: || ' 1 resource_count,'
2301: || ' un.from_date interval_date '
2302: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2303: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2304: || ' gmp_resource_instances'||p_db_link||' gri '
2305: || ' WHERE crd.resource_id = un.resource_id '
2306: || ' AND crd.resource_id = gri.resource_id '
2307: || ' AND un.instance_id = gri.instance_id '
2308: || ' AND crd.organization_id = :orgn_id3 '

Line 2327: || ' gmp_resource_instances'||p_db_link||' gri '

2323: || ' 1 resource_count,'
2324: || ' un.to_date interval_date '
2325: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2326: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2327: || ' gmp_resource_instances'||p_db_link||' gri '
2328: || ' WHERE crd.resource_id = un.resource_id '
2329: || ' AND crd.resource_id = gri.resource_id '
2330: || ' AND un.instance_id = gri.instance_id '
2331: || ' AND crd.organization_id = :orgn_id4 '

Line 2350: || ' gmp_resource_instances'||p_db_link||' gri '

2346: || ' 1 resource_count,'
2347: || ' un.from_date interval_date '
2348: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2349: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2350: || ' gmp_resource_instances'||p_db_link||' gri '
2351: || ' WHERE crd.resource_id = un.resource_id '
2352: || ' AND crd.resource_id = gri.resource_id '
2353: || ' AND crd.organization_id = :orgn_id5 '
2354: || ' AND nvl(crd.calendar_code,:g_default_cal_code5)=:l_cal_code5'

Line 2366: || ' FROM gmp_resource_instances'||p_db_link||' tgri '

2362:
2363: sql_stmt1 := sql_stmt1
2364: || ' AND gri.instance_number in '
2365: || ' ( select tgri.instance_number '
2366: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
2367: || ' WHERE tgri.resource_id = crd.resource_id '
2368: || ' AND rownum <= un.resource_units '
2369: || ' ) '
2370: || ' UNION ALL '

Line 2378: || ' gmp_resource_instances'||p_db_link||' gri '

2374: || ' 1 resource_count,'
2375: || ' un.to_date interval_date '
2376: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2377: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2378: || ' gmp_resource_instances'||p_db_link||' gri '
2379: || ' WHERE crd.resource_id = un.resource_id '
2380: || ' AND crd.resource_id = gri.resource_id '
2381: || ' AND crd.organization_id = :orgn_id6 '
2382: || ' AND nvl(crd.calendar_code,:g_default_cal_code6)=:l_cal_code6'

Line 2394: || ' FROM gmp_resource_instances'||p_db_link||' tgri '

2390:
2391: sql_stmt1 := sql_stmt1
2392: || ' AND gri.instance_number in '
2393: || ' ( select tgri.instance_number '
2394: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
2395: || ' WHERE tgri.resource_id = crd.resource_id '
2396: || ' AND rownum <= un.resource_units '
2397: || ' ) '
2398: || ' ) cmd, '

Line 2412: || ' gmp_resource_instances'||p_db_link||' gri '

2408: || ' (exp.shift_date + '
2409: || ' (exp.from_time/86400)) interval_date '
2410: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2411: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '
2412: || ' gmp_resource_instances'||p_db_link||' gri '
2413: || ' WHERE crd.organization_id = :orgn_id7 '
2414: || ' AND nvl(crd.calendar_code,:g_default_cal_code7)=:l_cal_code7'
2415: || ' AND exp.calendar_code = :curr_cal2 '
2416: || ' AND crd.resource_id = gri.resource_id '

Line 2434: || ' gmp_resource_instances'||p_db_link||' gri '

2430: || ' (exp.shift_date + '
2431: || ' (exp.to_time/86400)) interval_date '
2432: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2433: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '
2434: || ' gmp_resource_instances'||p_db_link||' gri '
2435: || ' WHERE crd.organization_id = :orgn_id8 '
2436: || ' AND nvl(crd.calendar_code,:g_default_cal_code8)=:l_cal_code8'
2437: || ' AND exp.calendar_code = :curr_cal3 '
2438: || ' AND crd.resource_id = gri.resource_id '