DBA Data[Home] [Help]

APPS.GMO_VBATCH_PVT dependencies on GMD_OPERATIONS_B

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

1197: batchstep_id,
1198: routingstep_id,
1199: a.oprn_id,
1200: batchstep_no || '-' || b.oprn_no
1201: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;
1202:
1203: cursor c_get_activities is
1204: select batchstep_activity_id,
1205: routingstep_id,

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

2907: l_counter number;
2908: l_instr_count number;
2909:
2910: cursor c_get_oprn is select a.batchstep_no || '-' || oprn_no, batchstep_id from
2911: gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and
2912: batchstep_id= P_BATCHSTEP_ID and batch_id = P_BATCH_ID;
2913:
2914: cursor c_get_activity is select activity, batchstep_activity_id from
2915: gme_batch_step_activities where batchstep_id=P_BATCHSTEP_ID and batch_id =

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

3100: batchstep_id,
3101: routingstep_id,
3102: a.oprn_id,
3103: batchstep_no || '-' || b.oprn_no
3104: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;
3105:
3106: cursor c_get_activities is
3107: select batchstep_activity_id,
3108: routingstep_id,