DBA Data[Home] [Help]

APPS.GME_RELEASE_BATCH_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 26: FROM gme_batch_steps s, gme_batch_step_items item

22: AND line_type = gme_common_pvt.g_line_type_ing;
23:
24: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS
25: SELECT s.*
26: FROM gme_batch_steps s, gme_batch_step_items item
27: WHERE s.batchstep_id = item.batchstep_id
28: AND item.material_detail_id = v_matl_dtl_id;
29:
30: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';

Line 1531: FROM gme_batch_steps s, gme_batch_step_items item

1527: AND phantom_type <> 0;
1528:
1529: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS
1530: SELECT s.batchstep_id
1531: FROM gme_batch_steps s, gme_batch_step_items item
1532: WHERE s.batchstep_id = item.batchstep_id
1533: AND item.material_detail_id = v_matl_dtl_id;
1534:
1535: l_api_name CONSTANT VARCHAR2 (30) := 'check_unexploded_phantom';