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.

[Home] [Help]

APPS.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on GME_BATCH_STEPS

Line 128: FROM gme_batch_steps

124: ORDER BY line_type,line_no;
125:
126: CURSOR Cur_assoc_step(v_batch_id NUMBER) IS
127: SELECT *
128: FROM gme_batch_steps
129: WHERE batchstep_id IN (SELECT DISTINCT batchstep_id
130: FROM gme_batch_step_items
131: WHERE batch_id = v_batch_id);
132:

Line 135: FROM gme_batch_step_items m, gme_batch_steps s

131: WHERE batch_id = v_batch_id);
132:
133: CURSOR Cur_prod_assoc(V_batch_id NUMBER, V_material_detail_id NUMBER) IS
134: SELECT s.*
135: FROM gme_batch_step_items m, gme_batch_steps s
136: WHERE m.batch_id = V_batch_id
137: AND m.material_detail_id = V_material_detail_id
138: AND s.batch_id = m.batch_id
139: AND s.batchstep_id = m.batchstep_id

Line 157: l_batch_step_rec gme_batch_steps%ROWTYPE;

153: l_in_material_detail_rec gme_material_details%ROWTYPE;
154: l_phantom_material_rec gme_material_details%ROWTYPE;
155: l_material_detail_tbl gme_common_pvt.material_details_tab;
156:
157: l_batch_step_rec gme_batch_steps%ROWTYPE;
158: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
159: l_step_tbl gme_common_pvt.steps_tab;
160:
161: l_incr_qty NUMBER;

Line 158: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

154: l_phantom_material_rec gme_material_details%ROWTYPE;
155: l_material_detail_tbl gme_common_pvt.material_details_tab;
156:
157: l_batch_step_rec gme_batch_steps%ROWTYPE;
158: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
159: l_step_tbl gme_common_pvt.steps_tab;
160:
161: l_incr_qty NUMBER;
162: l_decr_qty NUMBER;

Line 688: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_resource_txns_gtmp t

684: update gme_resource_txns_gtmp
685: set trans_date = p_trans_date
686: where poc_trans_id in
687: (select t.poc_trans_id
688: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_resource_txns_gtmp t
689: WHERE s.batch_id = l_batch_header_rec.batch_id
690: -- Comment out following update as original fix was just for one step.
691: -- AND a.batchstep_id = l_in_batch_step_rec.batchstep_id
692: AND a.batchstep_id = s.batchstep_id

Line 706: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_resource_txns_gtmp t

702: update gme_resource_txns_gtmp
703: set trans_date = p_trans_date
704: where poc_trans_id in
705: (select t.poc_trans_id
706: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_resource_txns_gtmp t
707: WHERE s.batch_id = l_batch_header_rec.batch_id
708: -- Comment out following update as original fix was just for one step.
709: -- AND a.batchstep_id = l_in_batch_step_rec.batchstep_id
710: AND a.batchstep_id = s.batchstep_id

Line 909: FROM gme_batch_step_dependencies d, gme_batch_steps s

905: l_api_name CONSTANT VARCHAR2 (30) := 'update_dependent_steps';
906:
907: CURSOR Cur_prev_steps(V_batchstep_id NUMBER) IS
908: SELECT d.dep_step_id, d.dep_type, s.step_status
909: FROM gme_batch_step_dependencies d, gme_batch_steps s
910: WHERE d.batchstep_id = V_batchstep_id
911: AND s.batchstep_id = d.dep_step_id;
912:
913: l_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

Line 913: l_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

909: FROM gme_batch_step_dependencies d, gme_batch_steps s
910: WHERE d.batchstep_id = V_batchstep_id
911: AND s.batchstep_id = d.dep_step_id;
912:
913: l_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
914: l_in_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
915:
916: l_message_count NUMBER;
917: l_backflush_factor NUMBER;

Line 914: l_in_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

910: WHERE d.batchstep_id = V_batchstep_id
911: AND s.batchstep_id = d.dep_step_id;
912:
913: l_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
914: l_in_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
915:
916: l_message_count NUMBER;
917: l_backflush_factor NUMBER;
918: l_message_list VARCHAR2(2000);

Line 1697: FROM gme_batch_steps s, gme_batch_step_items i

1693: l_step_status NUMBER;
1694:
1695: CURSOR cur_get_step_status(v_material_detail_id NUMBER) IS
1696: SELECT s.batchstep_no, step_status
1697: FROM gme_batch_steps s, gme_batch_step_items i
1698: WHERE s.batchstep_id = i.batchstep_id
1699: AND i.material_detail_id = v_material_detail_id;
1700:
1701: ERROR_INV_ACTION_FPO EXCEPTION;