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 8353: || ' gmp_resource_instances'||pdblink||' gri, '

8349: || ' gme_batch_steps'||pdblink||' r,'
8350: || ' gme_batch_step_activities'||pdblink||' o,'
8351: || ' gme_batch_step_resources'||pdblink||' gs,'
8352: || ' gme_resource_txns'||pdblink||' t , '
8353: || ' gmp_resource_instances'||pdblink||' gri, '
8354: || ' cr_rsrc_dtl'||pdblink||' c'
8355: || ' WHERE'
8356: || ' h.batch_id = r.batch_id '
8357: || ' AND r.batch_id = o.batch_id'

Line 13662: UPDATE gmp_resource_instances gri

13658: END IF;
13659:
13660: IF NOT (lsetup_updated) THEN
13661: lsetup_updated := TRUE;
13662: UPDATE gmp_resource_instances gri
13663: SET gri.last_setup_id = v_last_setup_id
13664: WHERE gri.resource_id = v_resource_id
13665: AND gri.instance_id = v_instance_id;
13666: END IF;

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

14051: ||' gri.eff_start_date, '
14052: ||' gri.eff_end_date, '
14053: ||' 2 '
14054: ||' FROM '
14055: ||' gmp_resource_instances'||p_db_link||' gri, '
14056: ||' cr_rsrc_dtl'||p_db_link||' crd, '
14057: ||' sy_orgn_mst'||p_db_link||' som,'
14058: ||' ic_whse_mst'||p_db_link||' iwm '
14059: ||' WHERE '

Line 15287: || ' gmp_resource_instances '||p_db_link||' gri '

15283: || ' un.to_date, '
15284: || ' 1 resource_units'
15285: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
15286: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
15287: || ' gmp_resource_instances '||p_db_link||' gri '
15288: || ' WHERE crd.resource_id = un.resource_id '
15289: || ' AND crd.resource_id = gri.resource_id '
15290: || ' AND un.instance_id = gri.instance_id '
15291: || ' AND crd.orgn_code = :orgn_code ' ;

Line 15320: || ' gmp_resource_instances '||p_db_link||' gri '

15316: || ' un.to_date, '
15317: || ' 1 resource_units'
15318: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
15319: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
15320: || ' gmp_resource_instances '||p_db_link||' gri '
15321: || ' WHERE crd.resource_id = un.resource_id '
15322: || ' AND crd.resource_id = gri.resource_id '
15323: || ' AND crd.orgn_code = :orgn_code1 ' ;
15324:

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

15341: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
15342: sql_stmt1 := sql_stmt1
15343: || ' AND gri.instance_number in '
15344: || ' ( select tgri.instance_number '
15345: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
15346: || ' WHERE tgri.resource_id = crd.resource_id '
15347: || ' AND rownum <= un.resource_units '
15348: || ' ) '
15349: || ' UNION ALL '

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

15374: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
15375: sql_stmt1 := sql_stmt1
15376: || ' AND NOT EXISTS '
15377: || ' (SELECT 1 '
15378: || ' FROM gmp_resource_instances ' ||p_db_link||' gri '
15379: || ' WHERE gri.resource_id = un.resource_id ) '
15380: || ' ) '
15381: || ' ) u, '
15382: || ' ( '

Line 15412: || ' gmp_resource_instances '||p_db_link||' gri '

15408: || ' un.from_date interval_date, '
15409: || ' crd.assigned_qty assigned_qty '
15410: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
15411: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
15412: || ' gmp_resource_instances '||p_db_link||' gri '
15413: || ' WHERE crd.resource_id = un.resource_id '
15414: || ' AND crd.resource_id = gri.resource_id '
15415: || ' AND un.instance_id = gri.instance_id '
15416: || ' AND crd.orgn_code = :orgn_code1 ' ;

Line 15446: || ' gmp_resource_instances '||p_db_link||' gri '

15442: || ' un.to_date interval_date, '
15443: || ' crd.assigned_qty assigned_qty '
15444: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
15445: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
15446: || ' gmp_resource_instances '||p_db_link||' gri '
15447: || ' WHERE crd.resource_id = un.resource_id '
15448: || ' AND crd.resource_id = gri.resource_id '
15449: || ' AND un.instance_id = gri.instance_id '
15450: || ' AND crd.orgn_code = :orgn_code2 ' ;

Line 15480: || ' gmp_resource_instances '||p_db_link||' gri '

15476: || ' un.from_date interval_date, '
15477: || ' crd.assigned_qty assigned_qty '
15478: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
15479: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
15480: || ' gmp_resource_instances '||p_db_link||' gri '
15481: || ' WHERE crd.resource_id = un.resource_id '
15482: || ' AND crd.resource_id = gri.resource_id '
15483: || ' AND crd.orgn_code = :orgn_code3 ' ;
15484:

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

15502: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
15503: sql_stmt1 := sql_stmt1
15504: || ' AND gri.instance_number in '
15505: || ' ( select tgri.instance_number '
15506: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
15507: || ' WHERE tgri.resource_id = crd.resource_id '
15508: || ' AND rownum <= un.resource_units '
15509: || ' ) '
15510: || ' UNION ALL '

Line 15519: || ' gmp_resource_instances '||p_db_link||' gri '

15515: || ' un.to_date interval_date, '
15516: || ' crd.assigned_qty assigned_qty '
15517: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
15518: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
15519: || ' gmp_resource_instances '||p_db_link||' gri '
15520: || ' WHERE crd.resource_id = un.resource_id '
15521: || ' AND crd.resource_id = gri.resource_id '
15522: || ' AND crd.orgn_code = :orgn_code4 ' ;
15523:

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

15540:
15541: sql_stmt1 := sql_stmt1
15542: || ' AND gri.instance_number in '
15543: || ' ( select tgri.instance_number '
15544: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
15545: || ' WHERE tgri.resource_id = crd.resource_id '
15546: || ' AND rownum <= un.resource_units '
15547: || ' ) '
15548: || ' UNION ALL '

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

15575: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
15576: sql_stmt1 := sql_stmt1
15577: || ' AND NOT EXISTS '
15578: || ' (SELECT 1 '
15579: || ' FROM gmp_resource_instances '||p_db_link||' gri '
15580: || ' WHERE gri.resource_id = un.resource_id ) '
15581: || ' UNION ALL '
15582: || ' SELECT un.resource_id, '
15583: || ' 0 instance_number, '

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

15607:
15608: sql_stmt1 := sql_stmt1
15609: || ' AND NOT EXISTS '
15610: || ' (SELECT 1 '
15611: || ' FROM gmp_resource_instances '||p_db_link||' gri '
15612: || ' WHERE gri.resource_id = un.resource_id ) '
15613: || ' ) cmd, '
15614: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp '
15615: || ' WHERE exp.calendar_id = :curr_cal1 '

Line 17275: || ' gmp_resource_instances '||p_db_link||' gri '

17271: || ' un.to_date, '
17272: || ' 1 resource_units'
17273: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
17274: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
17275: || ' gmp_resource_instances '||p_db_link||' gri '
17276: || ' WHERE crd.resource_id = un.resource_id '
17277: || ' AND crd.resource_id = gri.resource_id '
17278: || ' AND un.instance_id = gri.instance_id '
17279: || ' AND crd.orgn_code = :orgn_code1 ' ;

Line 17308: || ' gmp_resource_instances '||p_db_link||' gri '

17304: || ' un.to_date, '
17305: || ' 1 resource_units'
17306: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
17307: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
17308: || ' gmp_resource_instances '||p_db_link||' gri '
17309: || ' WHERE crd.resource_id = un.resource_id '
17310: || ' AND crd.resource_id = gri.resource_id '
17311: || ' AND crd.orgn_code = :orgn_code2 ' ;
17312:

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

17329: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
17330: sql_stmt1 := sql_stmt1
17331: || ' AND gri.instance_number in '
17332: || ' ( select tgri.instance_number '
17333: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
17334: || ' WHERE tgri.resource_id = crd.resource_id '
17335: || ' AND rownum <= un.resource_units '
17336: || ' ) '
17337: || ' ) '

Line 17370: || ' gmp_resource_instances '||p_db_link||' gri '

17366: || ' 1 resource_count,'
17367: || ' un.from_date interval_date '
17368: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
17369: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
17370: || ' gmp_resource_instances '||p_db_link||' gri '
17371: || ' WHERE crd.resource_id = un.resource_id '
17372: || ' AND crd.resource_id = gri.resource_id '
17373: || ' AND un.instance_id = gri.instance_id '
17374: || ' AND crd.orgn_code = :orgn_code3 ' ;

Line 17403: || ' gmp_resource_instances '||p_db_link||' gri '

17399: || ' 1 resource_count,'
17400: || ' un.to_date interval_date '
17401: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
17402: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
17403: || ' gmp_resource_instances '||p_db_link||' gri '
17404: || ' WHERE crd.resource_id = un.resource_id '
17405: || ' AND crd.resource_id = gri.resource_id '
17406: || ' AND un.instance_id = gri.instance_id '
17407: || ' AND crd.orgn_code = :orgn_code4 ' ;

Line 17435: || ' gmp_resource_instances '||p_db_link||' gri '

17431: || ' 1 resource_count,'
17432: || ' un.from_date interval_date '
17433: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
17434: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
17435: || ' gmp_resource_instances '||p_db_link||' gri '
17436: || ' WHERE crd.resource_id = un.resource_id '
17437: || ' AND crd.resource_id = gri.resource_id '
17438: || ' AND crd.orgn_code = :orgn_code5 ' ;
17439: IF (p_usage = 'BASED') THEN /* Usage APS */

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

17456: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
17457: sql_stmt1 := sql_stmt1
17458: || ' AND gri.instance_number in '
17459: || ' ( select tgri.instance_number '
17460: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
17461: || ' WHERE tgri.resource_id = crd.resource_id '
17462: || ' AND rownum <= un.resource_units '
17463: || ' ) '
17464: || ' UNION ALL '

Line 17472: || ' gmp_resource_instances '||p_db_link||' gri '

17468: || ' 1 resource_count,'
17469: || ' un.to_date interval_date '
17470: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
17471: || ' gmp_rsrc_unavail_dtl_v '||p_db_link||' un, '
17472: || ' gmp_resource_instances '||p_db_link||' gri '
17473: || ' WHERE crd.resource_id = un.resource_id '
17474: || ' AND crd.resource_id = gri.resource_id '
17475: || ' AND crd.orgn_code = :orgn_code6 ' ;
17476:

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

17494: -- HW B4309093 Check for calendar id in cr_rsrc_dtl
17495: sql_stmt1 := sql_stmt1
17496: || ' AND gri.instance_number in '
17497: || ' ( select tgri.instance_number '
17498: || ' FROM gmp_resource_instances '||p_db_link||' tgri '
17499: || ' WHERE tgri.resource_id = crd.resource_id '
17500: || ' AND rownum <= un.resource_units '
17501: || ' ) '
17502: || ' ) cmd, '

Line 17516: || ' gmp_resource_instances '||p_db_link||' gri '

17512: || ' (exp.shift_date + '
17513: || ' (exp.from_time/86400)) interval_date '
17514: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
17515: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp, '
17516: || ' gmp_resource_instances '||p_db_link||' gri '
17517: || ' WHERE crd.orgn_code = :orgn_code7 ' ;
17518:
17519: IF (p_usage = 'BASED') THEN /* Usage APS */
17520: sql_stmt1 := sql_stmt1

Line 17548: || ' gmp_resource_instances '||p_db_link||' gri '

17544: || ' (exp.shift_date + '
17545: || ' (exp.to_time/86400)) interval_date '
17546: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
17547: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp, '
17548: || ' gmp_resource_instances '||p_db_link||' gri '
17549: || ' WHERE crd.orgn_code = :orgn_code8 ' ;
17550:
17551: IF (p_usage = 'BASED') THEN /* Usage APS */
17552: sql_stmt1 := sql_stmt1

Line 17591: || ' gmp_resource_instances '||p_db_link||' gri '

17587: || ' ,t.interval_date '
17588: || ' ,u.resource_units '
17589: || ' ,t.assigned_qty '
17590: || ' ) rt, '
17591: || ' gmp_resource_instances '||p_db_link||' gri '
17592: || ' WHERE '
17593: || ' decode(rt.interval_date,rt.lead_idate,rt.assigned_qty,'
17594: || ' (rt.assigned_qty - nvl(rt.rsum,0))) > 0 '
17595: || ' AND rt.resource_id = gri.resource_id '