APPS.GMP_APS_WRITER dependencies on GMP_APS_OUTPUT_TBL

Line 236: SELECT firm_flag INTO t_firm_flag FROM gmp_aps_output_tbl

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

Line 326: ||' FROM gmp_aps_output_tbl a,'

322: ||' b.last_unit_completion_date, '
323: ||' COUNT(distinct b.operation_seq_num) OVER (PARTITION BY '
324: ||' b.parent_header_id, b.group_id) oper_count , '
325: ||' max(b.last_unit_completion_date) OVER (PARTITION BY a.batch_id) Max_Step '
326: ||' FROM gmp_aps_output_tbl a,'
327: ||' gmp_aps_output_dtl b '
328: ||' WHERE b.load_type = 3 '
329: ||' AND b.parent_header_id = a.header_id '
330: ||' AND b.group_id = a.process_id '

Line 731: ||' gmp_aps_output_tbl gao, '

727: ||' gad.schedule_seq_num ) '
728: ||' - crd.delete_mark ) rsrc_count, '
729: ||' gao.inventory_item_id ' -- Bug: 8616967 Vpedarla
730: ||' FROM gmp_aps_output_dtl gad, '
731: ||' gmp_aps_output_tbl gao, '
732: ||' cr_rsrc_dtl crd, '
733: -- Sequence depdendency selection For R12.0
734: ||' ( SELECT operation_seq_num, parent_seq_num, schedule_seq_num, '
735: ||' wip_entity_id, resource_id_new , '

Line 1219: ||' gmp_aps_output_tbl gao, '

1215: ||' gad.resource_instance_id , ' -- For R12.0
1216: ||' gme.USAGE_UM , ' --Bug: 8616967 Vpedarla
1217: ||' gao.inventory_item_id ' --Bug: 8616967 Vpedarla
1218: ||' FROM gmp_aps_output_dtl gad, '
1219: ||' gmp_aps_output_tbl gao, '
1220: ||' cr_rsrc_dtl crd , '
1221: ||' gme_batch_step_resources gme ' --Bug: 8616967 Vpedarla
1222: ||' WHERE '
1223: ||' gad.load_type in (4,9) '

Line 1378: UPDATE gmp_aps_output_tbl

1374: log_message('Writer success - '||p_batch_id);
1375: IF p_action_type <> 1 THEN
1376: -- Reschedule form is not calling GME routine and hence once
1377: -- the batch is updated successfully, then processed_ind = 0
1378: UPDATE gmp_aps_output_tbl
1379: SET processed_ind = 0
1380: WHERE batch_id = p_batch_id
1381: AND process_id = p_group_id
1382: AND header_id = p_header_id ;

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

2497: -- Bug 12716557 - ORA-00932: Error Vkinduri
2498: --||' nvl((SELECT SUM(DECODE(sign(g1.gen_lupd '
2499: --||' - trunc(gor.last_update_date)), 1,1,0,1,-1,-600))'
2500: ||' nvl((SELECT SUM(DECODE(sign((SELECT creation_date gen_lupd '
2501: ||' FROM GMP_APS_OUTPUT_TBL WHERE process_id = :pgrp1 '
2502: ||' AND header_id = :phdr1) '
2503: ||' - trunc(gor.last_update_date)), 1,1,0,1,-1,-600))'
2504: ||' FROM'
2505: ||' gmd_operation_resources gor, '

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

2526: ||' gmd_operations fom, '
2527: ||' gmd_operation_activities goa, '
2528: -- B6051303, PS Issue
2529: ||' ( SELECT creation_date gen_lupd '
2530: ||' FROM GMP_APS_OUTPUT_TBL WHERE process_id = :pgrp1 '
2531: ||' AND header_id = :phdr1 ) g1 '
2532: ||' WHERE gr.recipe_id = ffe.recipe_id '
2533: ||' AND gr.routing_id = frh.routing_id '
2534: ||' AND gr.formula_id = ffm.formula_id '

Line 2553: ||' gmp_aps_output_tbl b '

2549: ||' count(a.resource_id_new) '
2550: ||' OVER (PARTITION BY a.operation_seq_num, '
2551: ||' a.schedule_seq_num) aps_resource_sum '
2552: ||' FROM gmp_aps_output_dtl a, '
2553: ||' gmp_aps_output_tbl b '
2554: ||' WHERE a.parent_header_id = b.header_id '
2555: ||' AND a.group_id = b.process_id '
2556: ||' AND b.process_id = :pgrp2 '
2557: ||' AND b.header_id = :phdr2 '

Line 2987: gmp_aps_output_tbl gao,

2983: gad.last_update_date,
2984: gad.creation_date,
2985: gad.created_by
2986: FROM gmp_aps_output_dtl gad,
2987: gmp_aps_output_tbl gao,
2988: gme_batch_steps gbs,
2989: cr_rsrc_dtl crd
2990: WHERE gad.parent_header_id = gao.header_id
2991: AND gad.group_id = gao.process_id