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 217: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '

213: || ' decode(r.schedule_ind,2,1,2), '
214: || ' 1 '/*B4487118 - HLINK GC:(RV): MULTIPLE ROWS ARE DISPALYED FOR A RESOURCE IN THE RV*/
215: /*sowsubra - ME changes - Start*/
216: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */
217: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '
218: || ' cr_rsrc_mst'||p_db_link||' m, '
219: || ' mrp_planning_exception_sets'||p_db_link||' mrp, '
220: || ' mtl_parameters'||p_db_link||' p, '
221: || ' hr_organization_units'||p_db_link||' hr '

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

273: || ' NULL, '
274: /* If the Resource is scheduled to Instance, then value is Yes else No */
275: || ' decode(r.schedule_ind,2,1,2), '
276: || ' 1 ' /*B4487118 - HLINK GC:(RV): MULTIPLE ROWS ARE DISPALYED FOR A RESOURCE IN THE RV*/
277: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '
278: /*sowsubra - ME changes - Start*/
279: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */
280: || ' mtl_parameters'||p_db_link||' p, '
281: || ' cr_rsrc_mst'||p_db_link||' m, '

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

316: || ' :instance_id '
317: /*sowsubra - ME changes - Start*/
318: || ' FROM mtl_parameters'||p_db_link||' p, '
319: || ' hr_organization_units'||p_db_link||' hr, '
320: || ' cr_rsrc_dtl'||p_db_link||' crd, '
321: || ' cr_rsrc_mst'||p_db_link||' crm '
322: || ' WHERE p.organization_id = crd.organization_id '
323: || ' AND p.organization_id = hr.organization_id '
324: || ' AND nvl(hr.date_to,sysdate) >= sysdate '

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

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

Line 548: || ' cr_rsrc_dtl'||p_db_link||' crd '

544: || ' 0 '
545: || ' FROM bom_calendars'||p_db_link||' cal, '
546: || ' hr_organization_units'||p_db_link||' hr, '
547: || ' mtl_parameters'||p_db_link||' mp, '
548: || ' cr_rsrc_dtl'||p_db_link||' crd '
549: || ' WHERE mp.organization_id = hr.organization_id '
550: || ' AND nvl(hr.date_to,sysdate) >= sysdate '
551: || ' AND mp.process_enabled_flag = '||''''||'Y'||''''
552: || ' AND crd.organization_id = mp.organization_id '

Line 668: || ' cr_rsrc_dtl'||p_db_link||' crd '

664: || ' 2 '
665: || ' FROM '
666: || ' gmp_resource_avail'||p_db_link||' gra, '
667: || ' mtl_parameters'||p_db_link||' m, '
668: || ' cr_rsrc_dtl'||p_db_link||' crd '
669: || ' WHERE nvl(gra.resource_instance_id,0) = 0 '
670: || ' AND nvl(crd.calendar_code,m.calendar_code) = gra.calendar_code '
671: || ' AND gra.organization_id = crd.organization_id '
672: || ' AND gra.organization_id = m.organization_id '

Line 715: || ' cr_rsrc_dtl'||p_db_link||' crd '

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

Line 754: || ' cr_rsrc_dtl'||p_db_link||' crd '

750: || ' :instance_id, '
751: || ' crd.assigned_qty '
752: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp, '
753: || ' mtl_parameters'||p_db_link||' m, '
754: || ' cr_rsrc_dtl'||p_db_link||' crd '
755: || ' WHERE NVL(crd.calendar_code,m.calendar_code) = gtmp.calendar_code '
756: || ' AND m.organization_id = crd.organization_id '
757: || ' AND m.process_enabled_flag = '||''''||'Y'||''''
758: || ' AND crd.delete_mark = 0 ';

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

1303: end_index NUMBER ;
1304: first_in NUMBER ;
1305: last_in NUMBER ;
1306:
1307: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;
1308: resource_count rsrc_cnt ;
1309:
1310: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;
1311: resource_id rsrc_id ;

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

1306:
1307: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;
1308: resource_count rsrc_cnt ;
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 ;

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

1355: END IF;
1356:
1357: /* Interval Cursor gives the all the point of inflections */
1358:
1359: /*sowsubra - resource model ME changes - The orgn_code in cr_rsrc_dtl
1360: has been replaced with the organization_id in all the below union
1361: statements */
1362:
1363: stmt_no := 73;

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

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

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

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

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

1438: || ' 0 instance_number, '
1439: || ' un.from_date, '
1440: || ' un.to_date, '
1441: || ' un.resource_units '
1442: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1443: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un'
1444: || ' WHERE crd.resource_id = un.resource_id '
1445: || ' AND crd.delete_mark = 0 '
1446: || ' AND crd.organization_id = :orgn_id3 '

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

1484: || ' 0 shift_num,'
1485: || ' 0 resource_count,'
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 '

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

1508: || ' 0 shift_num,'
1509: || ' 0 resource_count,'
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 '

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

1532: || ' 0 shift_num,'
1533: || ' 0 resource_count,'
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 '

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

1561: || ' 0 shift_num,'
1562: || ' 0 resource_count,'
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 '

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

1590: || ' 0 shift_num,'
1591: || ' 0 resource_count,'
1592: || ' un.from_date interval_date, '
1593: || ' crd.assigned_qty assigned_qty '
1594: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1595: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un '
1596: || ' WHERE crd.resource_id = un.resource_id '
1597: || ' AND crd.delete_mark = 0 '
1598: || ' AND crd.organization_id = :orgn_id8 '

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

1613: || ' 0 shift_num,'
1614: || ' 0 resource_count,'
1615: || ' un.to_date interval_date, '
1616: || ' crd.assigned_qty assigned_qty '
1617: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1618: || ' gmp_rsrc_unavail_dtl_v'||p_db_link||' un '
1619: || ' WHERE crd.resource_id = un.resource_id '
1620: || ' AND crd.delete_mark = 0 '
1621: || ' AND crd.organization_id = :orgn_id9 '

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

1641: || ' exp.shift_num, '
1642: || ' 0 , '
1643: || ' exp.from_date interval_date, '
1644: || ' crd.assigned_qty assigned_qty '
1645: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1646: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1647: || ' WHERE crd.delete_mark = 0 '
1648: || ' AND crd.organization_id = :orgn_id10 '
1649: || ' AND nvl(crd.calendar_code,:g_default_code10)=:l_cal_code10 ';

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

1660: || ' exp.shift_num, '
1661: || ' 0 , '
1662: || ' exp.to_date interval_date, '
1663: || ' crd.assigned_qty assigned_qty '
1664: || ' FROM cr_rsrc_dtl'||p_db_link||' crd, '
1665: || ' gmp_calendar_detail_gtmp'||p_db_link||' exp '
1666: || ' WHERE crd.delete_mark = 0 '
1667: || ' AND crd.organization_id = :orgn_id11 '
1668: || ' AND nvl(crd.calendar_code,:g_default_code11)=:l_cal_code11 ';

Line 1933: ||' cr_rsrc_dtl crd '

1929: ||' cal.description '
1930: ||' FROM bom_calendars cal, '
1931: ||' hr_organization_units hr, '
1932: ||' mtl_parameters m, '
1933: ||' cr_rsrc_dtl crd '
1934: ||' WHERE m.organization_id = :orgn_id '
1935: ||' AND m.organization_id = hr.organization_id '
1936: ||' AND nvl(hr.date_to,sysdate) >= sysdate '
1937: ||' AND m.process_enabled_flag = '||''''||'Y'||''''

Line 1995: ||' FROM cr_rsrc_dtl '

1991: ' AND organization_id = :org_id1 ';
1992:
1993: IF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NOT NULL) THEN
1994: delete_stmt := delete_stmt ||' AND resource_id in (select resource_id '
1995: ||' FROM cr_rsrc_dtl '
1996: ||' WHERE organization_id = :org_id2 '
1997: ||' AND resources BETWEEN :frsrc and :trsrc ) ';
1998: EXECUTE IMMEDIATE delete_stmt USING cal_shift_rec(i).calendar_no, p_org_id,
1999: p_org_id, v_from_rsrc, v_to_rsrc;

Line 2003: ||' FROM cr_rsrc_dtl '

1999: p_org_id, v_from_rsrc, v_to_rsrc;
2000:
2001: ELSIF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NULL) THEN
2002: delete_stmt := delete_stmt ||' AND resource_id in (select resource_id '
2003: ||' FROM cr_rsrc_dtl '
2004: ||' WHERE organization_id = :org_id2 '
2005: ||' AND resources > :frsrc ) ';
2006: EXECUTE IMMEDIATE delete_stmt USING cal_shift_rec(i).calendar_no, p_org_id,
2007: p_org_id, v_from_rsrc;

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

2143: end_index number ;
2144: first_in number ;
2145: last_in number ;
2146:
2147: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;
2148: resource_count rsrc_cnt ;
2149:
2150: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;
2151: resource_id rsrc_id ;

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

2146:
2147: TYPE rsrc_cnt IS TABLE OF cr_rsrc_dtl.assigned_qty%TYPE;
2148: resource_count rsrc_cnt ;
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 ;

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

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

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

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

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

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

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

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

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

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

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

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

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

2406: || ' exp.shift_num, '
2407: || ' 1 , '
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'

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

2428: || ' exp.shift_num, '
2429: || ' 1 , '
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'

Line 2618: ||' from cr_rsrc_dtl'||p_db_link

2614:
2615: IF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NOT NULL) THEN
2616:
2617: sql_assembly := sql_assembly ||' AND resource_id in (select resource_id '
2618: ||' from cr_rsrc_dtl'||p_db_link
2619: ||' WHERE organization_id = :orgn_id2 '
2620: ||' AND resources BETWEEN :frsrc and :trsrc )' ;
2621: END IF ;
2622: