APPS.GMP_APS_WRITER dependencies on GMP_APS_OUTPUT_TBL

Line 232: SELECT firm_flag INTO t_firm_flag FROM gmp_aps_output_tbl

228: SAVEPOINT Before_Main_Program ;
229:
230: /* B5897392 get the firm_flag at header level */
231: BEGIN
232: SELECT firm_flag INTO t_firm_flag FROM gmp_aps_output_tbl
233: WHERE batch_id = p_batch_id
234: AND process_id = p_group_id
235: AND header_id = p_header_id ;
236: EXCEPTION

Line 319: ||' FROM gmp_aps_output_tbl a,'

315: ||' b.last_unit_completion_date, '
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 '

Line 713: ||' gmp_aps_output_tbl gao, '

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, '
717: ||' wip_entity_id, resource_id_new , '

Line 1165: ||' gmp_aps_output_tbl gao, '

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) '
1169: ||' AND gad.parent_header_id = gao.header_id '

Line 1304: UPDATE gmp_aps_output_tbl

1300: ELSE
1301: IF p_action_type <> 1 THEN
1302: -- Reschedule form is not calling GME routine and hence once
1303: -- the batch is updated successfully, then processed_ind = 0
1304: UPDATE gmp_aps_output_tbl
1305: SET processed_ind = 0
1306: WHERE batch_id = p_batch_id
1307: AND process_id = p_group_id
1308: AND header_id = p_header_id ;

Line 2431: ||' FROM GMP_APS_OUTPUT_TBL WHERE process_id = :pgrp1 '

2427: ||' gmd_operations fom, '
2428: ||' gmd_operation_activities goa, '
2429: -- B6051303, PS Issue
2430: ||' ( SELECT creation_date gen_lupd '
2431: ||' FROM GMP_APS_OUTPUT_TBL WHERE process_id = :pgrp1 '
2432: ||' AND header_id = :phdr1 ) g1 '
2433: ||' WHERE gr.recipe_id = ffe.recipe_id '
2434: ||' AND gr.routing_id = frh.routing_id '
2435: ||' AND gr.formula_id = ffm.formula_id '

Line 2454: ||' gmp_aps_output_tbl b '

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 '
2458: ||' AND b.header_id = :phdr2 '

Line 2884: gmp_aps_output_tbl gao,

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
2888: AND gad.group_id = gao.process_id