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 547: ||' gmp_resource_instances'||p_db_link||' gri, '

543: ||' gri.eff_start_date, '
544: ||' gri.eff_end_date, '
545: ||' 2 '
546: ||' FROM '
547: ||' gmp_resource_instances'||p_db_link||' gri, '
548: ||' cr_rsrc_dtl'||p_db_link||' c, '
549: ||' hr_organization_units'||p_db_link||' hr, '
550: ||' mtl_parameters'||p_db_link||' m '
551: ||' WHERE '

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

939: || ' gra.to_time, '
940: || ' ((gra.organization_id*2)+1) department_id, '/* encoded */
941: || ' :instance_id '
942: || ' FROM '
943: || ' gmp_resource_instances'||p_db_link||' gri, '
944: || ' gmp_resource_avail'||p_db_link||' gra, '
945: || ' mtl_parameters'||p_db_link||' m, '
946: || ' cr_rsrc_dtl'||p_db_link||' crd '
947: || ' WHERE gri.resource_id = gra.resource_id '

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

1572:
1573: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;
1574: resource_id rsrc_id ;
1575:
1576: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
1577: instance_id inst_id ;
1578:
1579: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
1580: instance_number inst_num ;

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

1575:
1576: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
1577: instance_id inst_id ;
1578:
1579: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
1580: instance_number inst_num ;
1581:
1582: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
1583: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;

Line 1661: || ' gmp_resource_instances'||p_db_link||' gri '

1657: || ' un.to_date, '
1658: || ' 1 resource_units'
1659: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1660: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1661: || ' gmp_resource_instances'||p_db_link||' gri '
1662: || ' WHERE crd.resource_id = un.resource_id '
1663: || ' AND crd.resource_id = gri.resource_id '
1664: || ' AND un.instance_id = gri.instance_id '
1665: || ' AND crd.schedule_ind = 2 '

Line 1684: || ' gmp_resource_instances'||p_db_link||' gri '

1680: || ' un.to_date, '
1681: || ' 1 resource_units'
1682: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1683: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1684: || ' gmp_resource_instances'||p_db_link||' gri '
1685: || ' WHERE crd.resource_id = un.resource_id '
1686: || ' AND crd.resource_id = gri.resource_id '
1687: || ' AND crd.delete_mark = 0 '
1688: || ' AND crd.schedule_ind = 2 '

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

1696:
1697: sql_stmt1 := sql_stmt1
1698: || ' AND gri.instance_number in '
1699: || ' ( select tgri.instance_number '
1700: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
1701: || ' WHERE tgri.resource_id = crd.resource_id '
1702: || ' AND rownum <= un.resource_units '
1703: || ' ) '
1704: || ' UNION ALL '

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

1720:
1721: sql_stmt1 := sql_stmt1
1722: || ' AND NOT EXISTS '
1723: || ' (SELECT 1 '
1724: || ' FROM gmp_resource_instances'||p_db_link||' gri '
1725: || ' WHERE gri.resource_id = un.resource_id ) '
1726: || ' ) '
1727: || ' ) u, '
1728: || ' ( '

Line 1758: || ' gmp_resource_instances'||p_db_link||' gri '

1754: || ' un.from_date interval_date, '
1755: || ' crd.assigned_qty assigned_qty '
1756: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1757: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1758: || ' gmp_resource_instances'||p_db_link||' gri '
1759: || ' WHERE crd.resource_id = un.resource_id '
1760: || ' AND crd.resource_id = gri.resource_id '
1761: || ' AND un.instance_id = gri.instance_id '
1762: || ' AND crd.schedule_ind = 2 '

Line 1782: || ' gmp_resource_instances'||p_db_link||' gri '

1778: || ' un.to_date interval_date, '
1779: || ' crd.assigned_qty assigned_qty '
1780: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1781: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1782: || ' gmp_resource_instances'||p_db_link||' gri '
1783: || ' WHERE crd.resource_id = un.resource_id '
1784: || ' AND crd.resource_id = gri.resource_id '
1785: || ' AND un.instance_id = gri.instance_id '
1786: || ' AND crd.schedule_ind = 2 '

Line 1806: || ' gmp_resource_instances'||p_db_link||' gri '

1802: || ' un.from_date interval_date, '
1803: || ' crd.assigned_qty assigned_qty '
1804: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1805: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1806: || ' gmp_resource_instances'||p_db_link||' gri '
1807: || ' WHERE crd.resource_id = un.resource_id '
1808: || ' AND crd.resource_id = gri.resource_id '
1809: || ' AND crd.schedule_ind = 2 '
1810: || ' AND crd.delete_mark = 0 '

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

1818:
1819: sql_stmt1 := sql_stmt1
1820: || ' AND gri.instance_number in '
1821: || ' ( select tgri.instance_number '
1822: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
1823: || ' WHERE tgri.resource_id = crd.resource_id '
1824: || ' AND rownum <= un.resource_units '
1825: || ' ) '
1826: || ' UNION ALL '

Line 1835: || ' gmp_resource_instances'||p_db_link||' gri '

1831: || ' un.to_date interval_date, '
1832: || ' crd.assigned_qty assigned_qty '
1833: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1834: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
1835: || ' gmp_resource_instances'||p_db_link||' gri '
1836: || ' WHERE crd.resource_id = un.resource_id '
1837: || ' AND crd.resource_id = gri.resource_id '
1838: || ' AND crd.delete_mark = 0 '
1839: || ' AND crd.schedule_ind = 2 '

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

1847:
1848: sql_stmt1 := sql_stmt1
1849: || ' AND gri.instance_number in '
1850: || ' ( select tgri.instance_number '
1851: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
1852: || ' WHERE tgri.resource_id = crd.resource_id '
1853: || ' AND rownum <= un.resource_units '
1854: || ' ) '
1855: || ' UNION ALL '

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

1872:
1873: sql_stmt1 := sql_stmt1
1874: || ' AND NOT EXISTS '
1875: || ' (SELECT 1 '
1876: || ' FROM gmp_resource_instances'||p_db_link||' gri '
1877: || ' WHERE gri.resource_id = un.resource_id ) '
1878: || ' UNION ALL '
1879: || ' SELECT un.resource_id, '
1880: || ' 0 instance_number, '

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

1895:
1896: sql_stmt1 := sql_stmt1
1897: || ' AND NOT EXISTS '
1898: || ' (SELECT 1 '
1899: || ' FROM gmp_resource_instances'||p_db_link||' gri '
1900: || ' WHERE gri.resource_id = un.resource_id ) '
1901: || ' ) cmd, '
1902: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1903: || ' WHERE exp.calendar_code = :CAL91 '

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

2565:
2566: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;
2567: resource_id rsrc_id ;
2568:
2569: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
2570: instance_id inst_id ;
2571:
2572: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
2573: instance_number inst_num ;

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

2568:
2569: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
2570: instance_id inst_id ;
2571:
2572: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
2573: instance_number inst_num ;
2574:
2575: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
2576: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;

Line 2648: || ' gmp_resource_instances'||p_db_link||' gri '

2644: || ' un.to_date, '
2645: || ' 1 resource_units'
2646: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2647: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2648: || ' gmp_resource_instances'||p_db_link||' gri '
2649: || ' WHERE crd.resource_id = un.resource_id '
2650: || ' AND crd.resource_id = gri.resource_id '
2651: || ' AND un.instance_id = gri.instance_id '
2652: || ' AND crd.organization_id = :orgn_id1 '

Line 2671: || ' gmp_resource_instances'||p_db_link||' gri '

2667: || ' un.to_date, '
2668: || ' 1 resource_units'
2669: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2670: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2671: || ' gmp_resource_instances'||p_db_link||' gri '
2672: || ' WHERE crd.resource_id = un.resource_id '
2673: || ' AND crd.resource_id = gri.resource_id '
2674: || ' AND crd.organization_id = :orgn_id2 '
2675: || ' AND nvl(crd.calendar_code,:g_default_cal_code2)=:l_cal_code2'

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

2683:
2684: sql_stmt1 := sql_stmt1
2685: || ' AND gri.instance_number in '
2686: || ' ( select tgri.instance_number '
2687: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
2688: || ' WHERE tgri.resource_id = crd.resource_id '
2689: || ' AND rownum <= un.resource_units '
2690: || ' ) '
2691: || ' ) '

Line 2724: || ' gmp_resource_instances'||p_db_link||' gri '

2720: || ' 1 resource_count,'
2721: || ' un.from_date interval_date '
2722: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2723: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2724: || ' gmp_resource_instances'||p_db_link||' gri '
2725: || ' WHERE crd.resource_id = un.resource_id '
2726: || ' AND crd.resource_id = gri.resource_id '
2727: || ' AND un.instance_id = gri.instance_id '
2728: || ' AND crd.organization_id = :orgn_id3 '

Line 2747: || ' gmp_resource_instances'||p_db_link||' gri '

2743: || ' 1 resource_count,'
2744: || ' un.to_date interval_date '
2745: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2746: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2747: || ' gmp_resource_instances'||p_db_link||' gri '
2748: || ' WHERE crd.resource_id = un.resource_id '
2749: || ' AND crd.resource_id = gri.resource_id '
2750: || ' AND un.instance_id = gri.instance_id '
2751: || ' AND crd.organization_id = :orgn_id4 '

Line 2770: || ' gmp_resource_instances'||p_db_link||' gri '

2766: || ' 1 resource_count,'
2767: || ' un.from_date interval_date '
2768: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2769: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2770: || ' gmp_resource_instances'||p_db_link||' gri '
2771: || ' WHERE crd.resource_id = un.resource_id '
2772: || ' AND crd.resource_id = gri.resource_id '
2773: || ' AND crd.organization_id = :orgn_id5 '
2774: || ' AND nvl(crd.calendar_code,:g_default_cal_code5)=:l_cal_code5'

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

2782:
2783: sql_stmt1 := sql_stmt1
2784: || ' AND gri.instance_number in '
2785: || ' ( select tgri.instance_number '
2786: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
2787: || ' WHERE tgri.resource_id = crd.resource_id '
2788: || ' AND rownum <= un.resource_units '
2789: || ' ) '
2790: || ' UNION ALL '

Line 2798: || ' gmp_resource_instances'||p_db_link||' gri '

2794: || ' 1 resource_count,'
2795: || ' un.to_date interval_date '
2796: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2797: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un, '
2798: || ' gmp_resource_instances'||p_db_link||' gri '
2799: || ' WHERE crd.resource_id = un.resource_id '
2800: || ' AND crd.resource_id = gri.resource_id '
2801: || ' AND crd.organization_id = :orgn_id6 '
2802: || ' AND nvl(crd.calendar_code,:g_default_cal_code6)=:l_cal_code6'

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

2810:
2811: sql_stmt1 := sql_stmt1
2812: || ' AND gri.instance_number in '
2813: || ' ( select tgri.instance_number '
2814: || ' FROM gmp_resource_instances'||p_db_link||' tgri '
2815: || ' WHERE tgri.resource_id = crd.resource_id '
2816: || ' AND rownum <= un.resource_units '
2817: || ' ) '
2818: || ' ) cmd, '

Line 2832: || ' gmp_resource_instances'||p_db_link||' gri '

2828: || ' (exp.shift_date + '
2829: || ' (exp.from_time/86400)) interval_date '
2830: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2831: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '
2832: || ' gmp_resource_instances'||p_db_link||' gri '
2833: || ' WHERE crd.organization_id = :orgn_id7 '
2834: || ' AND nvl(crd.calendar_code,:g_default_cal_code7)=:l_cal_code7'
2835: || ' AND exp.calendar_code = :curr_cal2 '
2836: || ' AND crd.resource_id = gri.resource_id '

Line 2854: || ' gmp_resource_instances'||p_db_link||' gri '

2850: || ' (exp.shift_date + '
2851: || ' (exp.to_time/86400)) interval_date '
2852: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
2853: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp, '
2854: || ' gmp_resource_instances'||p_db_link||' gri '
2855: || ' WHERE crd.organization_id = :orgn_id8 '
2856: || ' AND nvl(crd.calendar_code,:g_default_cal_code8)=:l_cal_code8'
2857: || ' AND exp.calendar_code = :curr_cal3 '
2858: || ' AND crd.resource_id = gri.resource_id '