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_CALENDAR_DETAIL_GTMP

Line 15559: ins_stmt := 'INSERT INTO gmp_calendar_detail_gtmp'||p_db_link

15555: /* Start writing the exploded Calendar dates into temp table */
15556: wps_index := 1 ;
15557:
15558: /* 12/13/02 - Rajesh Patangya B2710601, Added database link */
15559: ins_stmt := 'INSERT INTO gmp_calendar_detail_gtmp'||p_db_link
15560: ||' ( '
15561: ||' calendar_id, '
15562: ||' shift_num, '
15563: ||' shift_date, '

Line 15642: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp '

15638: || ' from_time, '
15639: || ' to_time, '
15640: || ' 2 , '
15641: || ' :instance_id '
15642: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp '
15643: || ' WHERE calendar_id = :curr_cal_id '
15644: || ' ORDER BY shift_num,from_time, to_time ' ;
15645:
15646: EXECUTE IMMEDIATE shft_time USING p_calendar_no,

Line 16077: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */

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;
16079: shift_num shift_no ;
16080:
16081: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;

Line 16078: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;

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;
16079: shift_num shift_no ;
16080:
16081: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
16082: f_date f_dt ;

Line 16480: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp '

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 '
16482: || ' AND cmd.interval_date BETWEEN '
16483: || ' exp.from_date AND exp.to_date '
16484: || ' UNION ALL '

Line 16492: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp '

16488: || ' 0 , '
16489: || ' exp.from_date interval_date, '
16490: || ' crd.assigned_qty assigned_qty '
16491: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
16492: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp '
16493: || ' WHERE crd.orgn_code = :orgn_code5 ' ;
16494:
16495: IF (p_usage = 'BASED') THEN /* Usage APS */
16496: sql_stmt1 := sql_stmt1

Line 16521: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp '

16517: || ' 0 , '
16518: || ' exp.to_date interval_date, '
16519: || ' crd.assigned_qty assigned_qty '
16520: || ' FROM cr_rsrc_dtl '||p_db_link||' crd, '
16521: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp '
16522: || ' WHERE crd.orgn_code = :orgn_code6 ' ;
16523:
16524: IF (p_usage = 'BASED') THEN /* Usage APS */
16525: sql_stmt1 := sql_stmt1

Line 16751: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp, '

16747: || ' ((crd.resource_id*2)+1), '
16748: || ' 2, '
16749: || ' :instance_id, '
16750: || ' crd.assigned_qty '
16751: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp, '
16752: || ' sy_orgn_mst'||p_db_link||' som, '
16753: || ' cr_rsrc_dtl'||p_db_link||' crd '
16754: || ' WHERE gtmp.calendar_id = :curr_cal_id '
16755: || ' AND NVL(crd.calendar_id,som.mfg_calendar_id)=gtmp.calendar_id '

Line 18359: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp '

18355: || ' WHERE tgri.resource_id = crd.resource_id '
18356: || ' AND rownum <= un.resource_units '
18357: || ' ) '
18358: || ' ) cmd, '
18359: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp '
18360: || ' WHERE exp.calendar_id = :curr_cal1 '
18361: || ' AND cmd.interval_date BETWEEN '
18362: || ' exp.from_date AND exp.to_date '
18363: || ' UNION ALL '

Line 18371: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp, '

18367: || ' 1 , '
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 */

Line 18403: || ' gmp_calendar_detail_gtmp ' ||p_db_link||' exp, '

18399: || ' 1 , '
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 */