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

Line 8909: || ' gmp_resource_instances'||pdblink||' gri, '

8905: || ' gme_batch_steps'||pdblink||' r,'
8906: || ' gme_batch_step_activities'||pdblink||' o,'
8907: || ' gme_batch_step_resources'||pdblink||' gs,'
8908: || ' gme_resource_txns'||pdblink||' t , '
8909: || ' gmp_resource_instances'||pdblink||' gri, '
8910: || ' cr_rsrc_dtl'||pdblink||' c'
8911: || ' WHERE'
8912: || ' h.batch_id = r.batch_id '
8913: || ' AND r.batch_id = o.batch_id'

Line 14457: UPDATE gmp_resource_instances gri

14453: END IF;
14454:
14455: IF NOT (lsetup_updated) THEN
14456: lsetup_updated := TRUE;
14457: UPDATE gmp_resource_instances gri
14458: SET gri.last_setup_id = v_last_setup_id
14459: WHERE gri.resource_id = v_resource_id
14460: AND gri.instance_id = v_instance_id;
14461: END IF;

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

14877: ||' gri.eff_start_date, '
14878: ||' gri.eff_end_date, '
14879: ||' 2 '
14880: ||' FROM '
14881: ||' gmp_resource_instances'||p_db_link||' gri, '
14882: ||' cr_rsrc_dtl'||p_db_link||' crd, '
14883: ||' sy_orgn_mst'||p_db_link||' som,'
14884: ||' ic_whse_mst'||p_db_link||' iwm '
14885: ||' WHERE '

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

16067:
16068: TYPE rsrc_id IS TABLE OF cr_rsrc_dtl.resource_id%TYPE;
16069: resource_id rsrc_id ;
16070:
16071: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
16072: instance_id inst_id ;
16073:
16074: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
16075: instance_number inst_num ;

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

16070:
16071: TYPE inst_id IS TABLE OF gmp_resource_instances.instance_id%TYPE;
16072: instance_id inst_id ;
16073:
16074: TYPE inst_num IS TABLE OF gmp_resource_instances.instance_number%TYPE;
16075: instance_number inst_num ;
16076:
16077: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
16078: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;

Line 16153: || ' gmp_resource_instances '||p_db_link||' gri '

16149: || ' un.to_date, '
16150: || ' 1 resource_units'
16151: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
16152: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
16153: || ' gmp_resource_instances '||p_db_link||' gri '
16154: || ' WHERE crd.resource_id = un.resource_id '
16155: || ' AND crd.resource_id = gri.resource_id '
16156: || ' AND un.instance_id = gri.instance_id '
16157: || ' AND crd.orgn_code = :orgn_code ' ;

Line 16186: || ' gmp_resource_instances '||p_db_link||' gri '

16182: || ' un.to_date, '
16183: || ' 1 resource_units'
16184: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
16185: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
16186: || ' gmp_resource_instances '||p_db_link||' gri '
16187: || ' WHERE crd.resource_id = un.resource_id '
16188: || ' AND crd.resource_id = gri.resource_id '
16189: || ' AND crd.orgn_code = :orgn_code1 ' ;
16190:

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

16207: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
16208: sql_stmt1 := sql_stmt1
16209: || ' AND gri.instance_number in '
16210: || ' ( select tgri.instance_number '
16211: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
16212: || ' WHERE tgri.resource_id = crd.resource_id '
16213: || ' AND rownum <= un.resource_units '
16214: || ' ) '
16215: || ' UNION ALL '

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

16240: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
16241: sql_stmt1 := sql_stmt1
16242: || ' AND NOT EXISTS '
16243: || ' (SELECT 1 '
16244: || ' FROM gmp_resource_instances ' ||p_db_link||' gri '
16245: || ' WHERE gri.resource_id = un.resource_id ) '
16246: || ' ) '
16247: || ' ) u, '
16248: || ' ( '

Line 16278: || ' gmp_resource_instances '||p_db_link||' gri '

16274: || ' un.from_date interval_date, '
16275: || ' crd.assigned_qty assigned_qty '
16276: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
16277: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
16278: || ' gmp_resource_instances '||p_db_link||' gri '
16279: || ' WHERE crd.resource_id = un.resource_id '
16280: || ' AND crd.resource_id = gri.resource_id '
16281: || ' AND un.instance_id = gri.instance_id '
16282: || ' AND crd.orgn_code = :orgn_code1 ' ;

Line 16312: || ' gmp_resource_instances '||p_db_link||' gri '

16308: || ' un.to_date interval_date, '
16309: || ' crd.assigned_qty assigned_qty '
16310: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
16311: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
16312: || ' gmp_resource_instances '||p_db_link||' gri '
16313: || ' WHERE crd.resource_id = un.resource_id '
16314: || ' AND crd.resource_id = gri.resource_id '
16315: || ' AND un.instance_id = gri.instance_id '
16316: || ' AND crd.orgn_code = :orgn_code2 ' ;

Line 16346: || ' gmp_resource_instances '||p_db_link||' gri '

16342: || ' un.from_date interval_date, '
16343: || ' crd.assigned_qty assigned_qty '
16344: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
16345: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
16346: || ' gmp_resource_instances '||p_db_link||' gri '
16347: || ' WHERE crd.resource_id = un.resource_id '
16348: || ' AND crd.resource_id = gri.resource_id '
16349: || ' AND crd.orgn_code = :orgn_code3 ' ;
16350:

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

16368: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
16369: sql_stmt1 := sql_stmt1
16370: || ' AND gri.instance_number in '
16371: || ' ( select tgri.instance_number '
16372: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
16373: || ' WHERE tgri.resource_id = crd.resource_id '
16374: || ' AND rownum <= un.resource_units '
16375: || ' ) '
16376: || ' UNION ALL '

Line 16385: || ' gmp_resource_instances '||p_db_link||' gri '

16381: || ' un.to_date interval_date, '
16382: || ' crd.assigned_qty assigned_qty '
16383: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
16384: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
16385: || ' gmp_resource_instances '||p_db_link||' gri '
16386: || ' WHERE crd.resource_id = un.resource_id '
16387: || ' AND crd.resource_id = gri.resource_id '
16388: || ' AND crd.orgn_code = :orgn_code4 ' ;
16389:

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

16406:
16407: sql_stmt1 := sql_stmt1
16408: || ' AND gri.instance_number in '
16409: || ' ( select tgri.instance_number '
16410: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
16411: || ' WHERE tgri.resource_id = crd.resource_id '
16412: || ' AND rownum <= un.resource_units '
16413: || ' ) '
16414: || ' UNION ALL '

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

16441: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
16442: sql_stmt1 := sql_stmt1
16443: || ' AND NOT EXISTS '
16444: || ' (SELECT 1 '
16445: || ' FROM gmp_resource_instances '||p_db_link||' gri '
16446: || ' WHERE gri.resource_id = un.resource_id ) '
16447: || ' UNION ALL '
16448: || ' SELECT un.resource_id, '
16449: || ' 0 instance_number, '

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

16473:
16474: sql_stmt1 := sql_stmt1
16475: || ' AND NOT EXISTS '
16476: || ' (SELECT 1 '
16477: || ' FROM gmp_resource_instances '||p_db_link||' gri '
16478: || ' WHERE gri.resource_id = un.resource_id ) '
16479: || ' ) cmd, '
16480: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp '
16481: || ' WHERE exp.calendar_id = :curr_cal1 '

Line 18131: || ' gmp_resource_instances '||p_db_link||' gri '

18127: || ' un.to_date, '
18128: || ' 1 resource_units'
18129: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
18130: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
18131: || ' gmp_resource_instances '||p_db_link||' gri '
18132: || ' WHERE crd.resource_id = un.resource_id '
18133: || ' AND crd.resource_id = gri.resource_id '
18134: || ' AND un.instance_id = gri.instance_id '
18135: || ' AND crd.orgn_code = :orgn_code1 ' ;

Line 18164: || ' gmp_resource_instances '||p_db_link||' gri '

18160: || ' un.to_date, '
18161: || ' 1 resource_units'
18162: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
18163: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
18164: || ' gmp_resource_instances '||p_db_link||' gri '
18165: || ' WHERE crd.resource_id = un.resource_id '
18166: || ' AND crd.resource_id = gri.resource_id '
18167: || ' AND crd.orgn_code = :orgn_code2 ' ;
18168:

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

18185: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
18186: sql_stmt1 := sql_stmt1
18187: || ' AND gri.instance_number in '
18188: || ' ( select tgri.instance_number '
18189: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
18190: || ' WHERE tgri.resource_id = crd.resource_id '
18191: || ' AND rownum <= un.resource_units '
18192: || ' ) '
18193: || ' ) '

Line 18226: || ' gmp_resource_instances '||p_db_link||' gri '

18222: || ' 1 resource_count,'
18223: || ' un.from_date interval_date '
18224: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
18225: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
18226: || ' gmp_resource_instances '||p_db_link||' gri '
18227: || ' WHERE crd.resource_id = un.resource_id '
18228: || ' AND crd.resource_id = gri.resource_id '
18229: || ' AND un.instance_id = gri.instance_id '
18230: || ' AND crd.orgn_code = :orgn_code3 ' ;

Line 18259: || ' gmp_resource_instances '||p_db_link||' gri '

18255: || ' 1 resource_count,'
18256: || ' un.to_date interval_date '
18257: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
18258: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
18259: || ' gmp_resource_instances '||p_db_link||' gri '
18260: || ' WHERE crd.resource_id = un.resource_id '
18261: || ' AND crd.resource_id = gri.resource_id '
18262: || ' AND un.instance_id = gri.instance_id '
18263: || ' AND crd.orgn_code = :orgn_code4 ' ;

Line 18291: || ' gmp_resource_instances '||p_db_link||' gri '

18287: || ' 1 resource_count,'
18288: || ' un.from_date interval_date '
18289: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
18290: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
18291: || ' gmp_resource_instances '||p_db_link||' gri '
18292: || ' WHERE crd.resource_id = un.resource_id '
18293: || ' AND crd.resource_id = gri.resource_id '
18294: || ' AND crd.orgn_code = :orgn_code5 ' ;
18295: IF (p_usage = 'BASED') THEN /* Usage APS */

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

18312: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
18313: sql_stmt1 := sql_stmt1
18314: || ' AND gri.instance_number in '
18315: || ' ( select tgri.instance_number '
18316: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
18317: || ' WHERE tgri.resource_id = crd.resource_id '
18318: || ' AND rownum <= un.resource_units '
18319: || ' ) '
18320: || ' UNION ALL '

Line 18328: || ' gmp_resource_instances '||p_db_link||' gri '

18324: || ' 1 resource_count,'
18325: || ' un.to_date interval_date '
18326: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
18327: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
18328: || ' gmp_resource_instances '||p_db_link||' gri '
18329: || ' WHERE crd.resource_id = un.resource_id '
18330: || ' AND crd.resource_id = gri.resource_id '
18331: || ' AND crd.orgn_code = :orgn_code6 ' ;
18332:

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

18350: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
18351: sql_stmt1 := sql_stmt1
18352: || ' AND gri.instance_number in '
18353: || ' ( select tgri.instance_number '
18354: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
18355: || ' WHERE tgri.resource_id = crd.resource_id '
18356: || ' AND rownum <= un.resource_units '
18357: || ' ) '
18358: || ' ) cmd, '

Line 18372: || ' gmp_resource_instances '||p_db_link||' gri '

18368: || ' (exp.shift_date + '
18369: || ' (exp.from_time/86400)) interval_date '
18370: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
18371: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp, '
18372: || ' gmp_resource_instances '||p_db_link||' gri '
18373: || ' WHERE crd.orgn_code = :orgn_code7 ' ;
18374:
18375: IF (p_usage = 'BASED') THEN /* Usage APS */
18376: sql_stmt1 := sql_stmt1

Line 18404: || ' gmp_resource_instances '||p_db_link||' gri '

18400: || ' (exp.shift_date + '
18401: || ' (exp.to_time/86400)) interval_date '
18402: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
18403: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp, '
18404: || ' gmp_resource_instances '||p_db_link||' gri '
18405: || ' WHERE crd.orgn_code = :orgn_code8 ' ;
18406:
18407: IF (p_usage = 'BASED') THEN /* Usage APS */
18408: sql_stmt1 := sql_stmt1

Line 18447: || ' gmp_resource_instances '||p_db_link||' gri '

18443: || ' ,t.interval_date '
18444: || ' ,u.resource_units '
18445: || ' ,t.assigned_qty '
18446: || ' ) rt, '
18447: || ' gmp_resource_instances '||p_db_link||' gri '
18448: || ' WHERE '
18449: || ' decode(rt.interval_date,rt.lead_idate,rt.assigned_qty,'
18450: || ' (rt.assigned_qty - nvl(rt.rsum,0))) > 0 '
18451: || ' AND rt.resource_id = gri.resource_id '