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 CR_RSRC_DTL

Line 321: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '

317: || ' decode(r.schedule_ind,2,1,2), '
318: || ' 1 '/*B4487118 - HLINK GC:(RV): MULTIPLE ROWS ARE DISPALYED FOR A RESOURCE IN THE RV*/
319: /*sowsubra - ME changes - Start*/
320: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */
321: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '
322: || ' cr_rsrc_mst'||p_db_link||' m, '
323: || ' mrp_planning_exception_sets'||p_db_link||' mrp, '
324: || ' mtl_parameters'||p_db_link||' p, '
325: || ' hr_organization_units'||p_db_link||' hr '

Line 381: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '

377: || ' NULL, '
378: /* If the Resource is scheduled to Instance, then value is Yes else No */
379: || ' decode(r.schedule_ind,2,1,2), '
380: || ' 1 ' /*B4487118 - HLINK GC:(RV): MULTIPLE ROWS ARE DISPALYED FOR A RESOURCE IN THE RV*/
381: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '
382: /*sowsubra - ME changes - Start*/
383: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */
384: || ' mtl_parameters'||p_db_link||' p, '
385: || ' cr_rsrc_mst'||p_db_link||' m, '

Line 425: || ' cr_rsrc_dtl'||p_db_link||' crd, '

421: || ' 1,'
422: || ' :instance_id '
423: || ' FROM mtl_parameters'||p_db_link||' p, '
424: || ' hr_organization_units'||p_db_link||' hr, '
425: || ' cr_rsrc_dtl'||p_db_link||' crd, '
426: || ' cr_rsrc_mst'||p_db_link||' crm '
427: || ' WHERE p.organization_id = crd.organization_id '
428: || ' AND p.organization_id = hr.organization_id '
429: || ' AND nvl(hr.date_to,sysdate) >= sysdate '

Line 487: || ' cr_rsrc_dtl'||p_db_link||' crd, '

483: || ' NULL BATCH_ID,'
484: || ' NULL COMPANY_NAME'
485: || ' FROM mtl_parameters'||p_db_link||' p, '
486: || ' hr_organization_units'||p_db_link||' hr, '
487: || ' cr_rsrc_dtl'||p_db_link||' crd, '
488: || ' cr_rsrc_mst'||p_db_link||' crm '
489: || ' WHERE p.organization_id = crd.organization_id '
490: || ' AND p.organization_id = hr.organization_id '
491: || ' AND nvl(hr.date_to,sysdate) >= sysdate '

Line 548: ||' cr_rsrc_dtl'||p_db_link||' c, '

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 '
552: ||' gri.resource_id = c.resource_id '

Line 752: || ' cr_rsrc_dtl'||p_db_link||' crd '

748: || ' 0 '
749: || ' FROM bom_calendars'||p_db_link||' cal, '
750: || ' hr_organization_units'||p_db_link||' hr, '
751: || ' mtl_parameters'||p_db_link||' mp, '
752: || ' cr_rsrc_dtl'||p_db_link||' crd '
753: || ' WHERE mp.organization_id = hr.organization_id '
754: || ' AND nvl(hr.date_to,sysdate) >= sysdate '
755: || ' AND mp.process_enabled_flag = '||''''||'Y'||''''
756: || ' AND crd.organization_id = mp.organization_id '

Line 897: || ' cr_rsrc_dtl'||p_db_link||' crd '

893: || ' 2 '
894: || ' FROM '
895: || ' gmp_resource_avail'||p_db_link||' gra, '
896: || ' mtl_parameters'||p_db_link||' m, '
897: || ' cr_rsrc_dtl'||p_db_link||' crd '
898: || ' WHERE nvl(gra.resource_instance_id,0) = 0 '
899: || ' AND nvl(crd.calendar_code,m.calendar_code) = gra.calendar_code '
900: || ' AND gra.organization_id = crd.organization_id '
901: || ' AND gra.organization_id = m.organization_id '

Line 946: || ' cr_rsrc_dtl'||p_db_link||' crd '

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 '
948: || ' AND gri.instance_id = gra.resource_instance_id '
949: || ' AND gri.inactive_ind = 0 '
950: || ' AND nvl(crd.calendar_code,m.calendar_code) = gra.calendar_code '

Line 988: || ' cr_rsrc_dtl'||p_db_link||' crd '

984: || ' :instance_id, '
985: || ' crd.assigned_qty '
986: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp, '
987: || ' mtl_parameters'||p_db_link||' m, '
988: || ' cr_rsrc_dtl'||p_db_link||' crd '
989: || ' WHERE NVL(crd.calendar_code,m.calendar_code) = gtmp.calendar_code '
990: || ' AND m.organization_id = crd.organization_id '
991: || ' AND m.process_enabled_flag = '||''''||'Y'||''''
992: || ' AND crd.delete_mark = 0 ';

Line 1570: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;

1566: Last_In Number ;
1567: First_In1 Number ;
1568: last_in1 NUMBER ;
1569:
1570: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;
1571: resource_count rsrc_cnt ;
1572:
1573: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;
1574: resource_id rsrc_id ;

Line 1573: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;

1569:
1570: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;
1571: resource_count rsrc_cnt ;
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 ;

Line 1625: /*sowsubra - resource model ME changes - The orgn_code in cr_rsrc_dtl

1621: END IF;
1622:
1623: /* Interval Cursor gives the all the point of inflections */
1624:
1625: /*sowsubra - resource model ME changes - The orgn_code in cr_rsrc_dtl
1626: has been replaced with the organization_id in all the below union
1627: statements */
1628:
1629: stmt_no := 73;

Line 1659: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1655: || ' gri.instance_number, '
1656: || ' un.from_date, '
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 '

Line 1682: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1678: || ' gri.instance_number, '
1679: || ' un.from_date, '
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 '

Line 1710: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1706: || ' 0 instance_number, '
1707: || ' un.from_date, '
1708: || ' un.to_date, '
1709: || ' un.resource_units '
1710: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1711: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un'
1712: || ' WHERE crd.resource_id = un.resource_id '
1713: || ' AND crd.delete_mark = 0 '
1714: || ' AND crd.organization_id = :orgn_id3 '

Line 1756: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1752: || ' 0 shift_num,'
1753: || ' 0 resource_count,'
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 '

Line 1780: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1776: || ' 0 shift_num,'
1777: || ' 0 resource_count,'
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 '

Line 1804: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1800: || ' 0 shift_num,'
1801: || ' 0 resource_count,'
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 '

Line 1833: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1829: || ' 0 shift_num,'
1830: || ' 0 resource_count,'
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 '

Line 1862: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1858: || ' 0 shift_num,'
1859: || ' 0 resource_count,'
1860: || ' un.from_date interval_date, '
1861: || ' crd.assigned_qty assigned_qty '
1862: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1863: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un '
1864: || ' WHERE crd.resource_id = un.resource_id '
1865: || ' AND crd.delete_mark = 0 '
1866: || ' AND crd.organization_id = :orgn_id8 '

Line 1885: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1881: || ' 0 shift_num,'
1882: || ' 0 resource_count,'
1883: || ' un.to_date interval_date, '
1884: || ' crd.assigned_qty assigned_qty '
1885: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1886: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un '
1887: || ' WHERE crd.resource_id = un.resource_id '
1888: || ' AND crd.delete_mark = 0 '
1889: || ' AND crd.organization_id = :orgn_id9 '

Line 1913: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1909: || ' exp.shift_num, '
1910: || ' 0 , '
1911: || ' exp.from_date interval_date, '
1912: || ' crd.assigned_qty assigned_qty '
1913: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1914: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1915: || ' WHERE crd.delete_mark = 0 '
1916: || ' AND crd.organization_id = :orgn_id10 '
1917: || ' AND nvl(crd.calendar_code,:g_default_code10)=:l_cal_code10 ';

Line 1932: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

1928: || ' exp.shift_num, '
1929: || ' 0 , '
1930: || ' exp.to_date interval_date, '
1931: || ' crd.assigned_qty assigned_qty '
1932: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1933: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1934: || ' WHERE crd.delete_mark = 0 '
1935: || ' AND crd.organization_id = :orgn_id11 '
1936: || ' AND nvl(crd.calendar_code,:g_default_code11)=:l_cal_code11 ';

Line 2255: FROM cr_rsrc_dtl c , mtl_parameters m

2251: SELECT MIN(RESOURCES), MAX(RESOURCES) into VRESOURCE_FROM, VRESOURCE_TO
2252: FROM (
2253: SELECT crd.RESOURCES FROM
2254: ( SELECT RESOURCES , RESOURCE_id , c.LAST_UPDATE_DATE
2255: FROM cr_rsrc_dtl c , mtl_parameters m
2256: WHERE c.ORGANIZATION_ID = p_org_id
2257: AND c.ORGANIZATION_ID = m.organization_id
2258: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2259: UNION

Line 2261: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_unavail_man b

2257: AND c.ORGANIZATION_ID = m.organization_id
2258: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2259: UNION
2260: SELECT c.RESOURCES , c.RESOURCE_id , b.LAST_UPDATE_DATE
2261: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_unavail_man b
2262: WHERE c.ORGANIZATION_ID = p_org_id
2263: AND c.ORGANIZATION_ID = m.organization_id
2264: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2265: AND c.resource_id = b.resource_id

Line 2269: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_excp_asnmt b

2265: AND c.resource_id = b.resource_id
2266: UNION
2267: -- VKINDURI BUG 13645301 Resource Unavailability
2268: SELECT c.RESOURCES , c.RESOURCE_id , MAX(b.LAST_UPDATE_DATE) LAST_UPDATE_DATE
2269: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_excp_asnmt b
2270: WHERE c.ORGANIZATION_ID = p_org_id
2271: AND c.ORGANIZATION_ID = m.organization_id
2272: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2273: AND c.resource_id = b.resource_id

Line 2284: FROM cr_rsrc_dtl c , mtl_parameters m

2280: ) gmp
2281: WHERE crd.LAST_UPDATE_DATE > gmp.lud AND crd.resource_id = gmp.resource_id
2282: UNION
2283: SELECT c.RESOURCES
2284: FROM cr_rsrc_dtl c , mtl_parameters m
2285: WHERE c.ORGANIZATION_ID = p_org_id
2286: AND c.ORGANIZATION_ID = m.organization_id
2287: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2288: AND NOT EXISTS ( SELECT 1 FROM gmp_resource_avail gmp

Line 2340: ||' cr_rsrc_dtl crd '

2336: ||' cal.description '
2337: ||' FROM bom_calendars cal, '
2338: ||' hr_organization_units hr, '
2339: ||' mtl_parameters m, '
2340: ||' cr_rsrc_dtl crd '
2341: ||' WHERE m.organization_id = :orgn_id '
2342: ||' AND m.organization_id = hr.organization_id '
2343: ||' AND nvl(hr.date_to,sysdate) >= sysdate '
2344: ||' AND m.process_enabled_flag = '||''''||'Y'||''''

Line 2402: ||' FROM cr_rsrc_dtl '

2398: IF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NOT NULL) THEN
2399: log_message('Delete Case A - Both from and To resources are Entered ');
2400:
2401: delete_stmt := delete_stmt ||' AND resource_id in (select resource_id '
2402: ||' FROM cr_rsrc_dtl '
2403: ||' WHERE organization_id = :org_id2 '
2404: ||' AND resources BETWEEN :frsrc and :trsrc ) ';
2405: EXECUTE IMMEDIATE delete_stmt USING cal_shift_rec(i).calendar_no, p_org_id,
2406: p_org_id, v_from_rsrc, v_to_rsrc;

Line 2411: ||' FROM cr_rsrc_dtl '

2407:
2408: ELSIF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NULL) THEN
2409: log_message('Delete Case B - From Resource is entered and To Resource is blank ');
2410: delete_stmt := delete_stmt ||' AND resource_id in (select resource_id '
2411: ||' FROM cr_rsrc_dtl '
2412: ||' WHERE organization_id = :org_id2 '
2413: ||' AND resources > :frsrc ) ';
2414: EXECUTE IMMEDIATE delete_stmt USING cal_shift_rec(i).calendar_no, p_org_id,
2415: p_org_id, v_from_rsrc;

Line 2563: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;

2559: end_index number ;
2560: first_in number ;
2561: last_in number ;
2562:
2563: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;
2564: resource_count rsrc_cnt ;
2565:
2566: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;
2567: resource_id rsrc_id ;

Line 2566: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;

2562:
2563: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;
2564: resource_count rsrc_cnt ;
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 ;

Line 2646: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

2642: || ' gri.instance_id, '
2643: || ' un.from_date, '
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 '

Line 2669: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

2665: || ' gri.instance_id, '
2666: || ' un.from_date, '
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 '

Line 2722: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

2718: || ' gri.instance_id instance_id,'
2719: || ' 0 shift_num,'
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 '

Line 2745: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

2741: || ' gri.instance_id instance_id,'
2742: || ' 0 shift_num,'
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 '

Line 2768: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

2764: || ' gri.instance_id instance_id,'
2765: || ' 0 shift_num,'
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 '

Line 2796: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

2792: || ' gri.instance_id instance_id,'
2793: || ' 0 shift_num,'
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 '

Line 2830: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

2826: || ' exp.shift_num, '
2827: || ' 1 , '
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'

Line 2852: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '

2848: || ' exp.shift_num, '
2849: || ' 1 , '
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'

Line 3043: ||' from cr_rsrc_dtl'||p_db_link

3039:
3040: IF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NOT NULL) THEN
3041:
3042: sql_assembly := sql_assembly ||' AND resource_id in (select resource_id '
3043: ||' from cr_rsrc_dtl'||p_db_link
3044: ||' WHERE organization_id = :orgn_id2 '
3045: ||' AND resources BETWEEN :frsrc and :trsrc )' ;
3046: END IF ;
3047: