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_APS_WRITER dependencies on GMP_APS_OUTPUT_DTL

Line 320: ||' gmp_aps_output_dtl b '

316: ||' COUNT(distinct b.operation_seq_num) OVER (PARTITION BY '
317: ||' b.parent_header_id, b.group_id) oper_count , '
318: ||' max(b.last_unit_completion_date) OVER (PARTITION BY a.batch_id) Max_Step '
319: ||' FROM gmp_aps_output_tbl a,'
320: ||' gmp_aps_output_dtl b '
321: ||' WHERE b.load_type = 3 '
322: ||' AND b.parent_header_id = a.header_id '
323: ||' AND b.group_id = a.process_id '
324: ||' AND b.organization_id = a.organization_id ' -- For R12.0

Line 438: UPDATE gmp_aps_output_dtl

434: END IF ;
435: ELSE
436: -- No Update to steps (WIP or completed)
437: BEGIN
438: UPDATE gmp_aps_output_dtl
439: SET load_type = (load_type * -1)
440: WHERE operation_seq_num =
441: operation_tab(oper_cnt).operation_seq_num
442: AND wip_entity_id = p_batch_id

Line 493: UPDATE GMP_APS_OUTPUT_DTL gad

489: END IF; /* t_max_step_date */
490:
491: BEGIN
492:
493: UPDATE GMP_APS_OUTPUT_DTL gad
494: SET attribute9 = ( SELECT gbr.batchstep_resource_id
495: FROM GME_BATCH_HEADER gbh,
496: GME_BATCH_STEPS gbs,
497: GME_BATCH_STEP_ACTIVITIES gba,

Line 568: ||' ( SELECT count(*) from gmp_aps_output_dtl '

564: ||' MAX(aps.completion_date) OVER (PARTITION BY '
565: ||' final.batchstep_activity_id), '
566: ||' aps.resource_hour, ' -- APS Resource Usage
567: -- Is Charge exists
568: ||' ( SELECT count(*) from gmp_aps_output_dtl '
569: ||' WHERE wip_entity_id = aps.wip_entity_id '
570: ||' AND parent_header_id = aps.parent_header_id '
571: ||' AND group_id = aps.group_id '
572: ||' AND load_type = 10 '

Line 712: ||' FROM gmp_aps_output_dtl gad, '

708: ||' ( COUNT(gad.resource_id_new) '
709: ||' OVER (PARTITION BY gad.operation_seq_num, '
710: ||' gad.schedule_seq_num ) '
711: ||' - crd.delete_mark ) rsrc_count '
712: ||' FROM gmp_aps_output_dtl gad, '
713: ||' gmp_aps_output_tbl gao, '
714: ||' cr_rsrc_dtl crd, '
715: -- Sequence depdendency selection For R12.0
716: ||' ( SELECT operation_seq_num, parent_seq_num, schedule_seq_num, '

Line 721: ||' FROM gmp_aps_output_dtl '

717: ||' wip_entity_id, resource_id_new , '
718: ||' TO_NUMBER(attribute1) sequence_dependent_usage, '
719: ||' MIN(start_date) OVER (PARTITION BY '
720: ||' group_id, parent_header_id, schedule_seq_num) start_date '
721: ||' FROM gmp_aps_output_dtl '
722: ||' WHERE parent_header_id = :phdr2 '
723: ||' AND group_id = :PGRP2 '
724: ||' AND wip_entity_id = :PBATCH2 '
725: ||' AND load_type = 1 '

Line 1027: UPDATE GMP_APS_OUTPUT_DTL

1023: BEGIN
1024: IF p_action_type = 1 THEN
1025: -- New batch
1026:
1027: UPDATE GMP_APS_OUTPUT_DTL
1028: SET attribute9 = new_batchstep_resource_id,
1029: attribute10 = or_tab(j).gme_uom_code
1030: WHERE load_type IN (4,9) -- For R12.0
1031: AND resource_id_new = or_tab(j).aps_resource_id

Line 1048: UPDATE GMP_APS_OUTPUT_DTL

1044: ) ;
1045:
1046: ELSE
1047: -- Reschedule batch (Update the count as APS does not provide)
1048: UPDATE GMP_APS_OUTPUT_DTL
1049: SET attribute9 = new_batchstep_resource_id,
1050: attribute10 = or_tab(j).gme_uom_code,
1051: assigned_units = rsrc_cnt
1052: WHERE load_type IN (4,9) -- For R12.0

Line 1115: -- WIP resource_instance_id then update GMP_APS_OUTPUT_DTL table

1111: END IF; /* End if for rreturn_status */
1112:
1113: -- NOTE:
1114: -- GMPOUTIB.pls will populate column resource_instance_number with
1115: -- WIP resource_instance_id then update GMP_APS_OUTPUT_DTL table
1116: -- resource_instance_id column
1117: -- with actual resource_instance_id from GMP_RESOURCE_INSTACNES table
1118:
1119: -- Update the resource level transactions if instance level transactions

Line 1123: UPDATE gmp_aps_output_dtl

1119: -- Update the resource level transactions if instance level transactions
1120: -- are present
1121: BEGIN
1122:
1123: UPDATE gmp_aps_output_dtl
1124: SET load_type = (load_type * -1)
1125: WHERE load_type = 4
1126: AND group_id = p_group_id
1127: AND parent_header_id = p_header_id

Line 1134: FROM gmp_aps_output_dtl b

1130: schedule_seq_num) IN
1131: ( SELECT b.operation_Seq_num,
1132: nvl(b.parent_seq_num,b.resource_seq_num),
1133: b.schedule_seq_num
1134: FROM gmp_aps_output_dtl b
1135: WHERE b.group_id = p_group_id
1136: AND b.parent_header_id = p_header_id
1137: AND b.load_type = 9 ) ;
1138: EXCEPTION

Line 1164: ||' FROM gmp_aps_output_dtl gad, '

1160: -- sowsubra B4629277 changed to_number to fnd_number.canonical_to_number
1161: ||' gad.start_date, '
1162: ||' gad.completion_date, '
1163: ||' gad.resource_instance_id ' -- For R12.0
1164: ||' FROM gmp_aps_output_dtl gad, '
1165: ||' gmp_aps_output_tbl gao, '
1166: ||' cr_rsrc_dtl crd '
1167: ||' WHERE '
1168: ||' gad.load_type in (4,9) '

Line 1970: gmp_aps_output_dtl gad,

1966: -- For R12.0
1967: BEGIN
1968: SELECT count(*) INTO v_plan_charges
1969: FROM
1970: gmp_aps_output_dtl gad,
1971: gme_batch_steps gbs
1972: WHERE gad.wip_entity_id = pbatch_id
1973: AND gad.load_type = 10
1974: AND gbs.batch_id = gad.wip_entity_id

Line 2453: ||' FROM gmp_aps_output_dtl a, '

2449: ||' OVER (PARTITION BY a.operation_seq_num ) aps_activity_sum, '
2450: ||' count(a.resource_id_new) '
2451: ||' OVER (PARTITION BY a.operation_seq_num, '
2452: ||' a.schedule_seq_num) aps_resource_sum '
2453: ||' FROM gmp_aps_output_dtl a, '
2454: ||' gmp_aps_output_tbl b '
2455: ||' WHERE a.parent_header_id = b.header_id '
2456: ||' AND a.group_id = b.process_id '
2457: ||' AND b.process_id = :pgrp2 '

Line 2883: FROM gmp_aps_output_dtl gad,

2879: gad.last_updated_by,
2880: gad.last_update_date,
2881: gad.creation_date,
2882: gad.created_by
2883: FROM gmp_aps_output_dtl gad,
2884: gmp_aps_output_tbl gao,
2885: gme_batch_steps gbs,
2886: cr_rsrc_dtl crd
2887: WHERE gad.parent_header_id = gao.header_id