APPS.GMO_VBATCH_PVT dependencies on GMD_OPERATIONS_B

Line 1156: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;

1152: batchstep_id,
1153: routingstep_id,
1154: a.oprn_id,
1155: batchstep_no || '-' || b.oprn_no
1156: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;
1157:
1158: cursor c_get_activities is
1159: select batchstep_activity_id,
1160: routingstep_id,

Line 2866: gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and

2862: l_counter number;
2863: l_instr_count number;
2864:
2865: cursor c_get_oprn is select a.batchstep_no || '-' || oprn_no, batchstep_id from
2866: gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and
2867: batchstep_id= P_BATCHSTEP_ID and batch_id = P_BATCH_ID;
2868:
2869: cursor c_get_activity is select activity, batchstep_activity_id from
2870: gme_batch_step_activities where batchstep_id=P_BATCHSTEP_ID and batch_id =

Line 3059: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;

3055: batchstep_id,
3056: routingstep_id,
3057: a.oprn_id,
3058: batchstep_no || '-' || b.oprn_no
3059: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;
3060:
3061: cursor c_get_activities is
3062: select batchstep_activity_id,
3063: routingstep_id,