DBA Data[Home] [Help]

APPS.GME_PHANTOM_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 100: FROM gme_batch_step_items i, gme_batch_steps d

96:
97: CURSOR cur_step_matl_detail (v_material_detail_id NUMBER)
98: IS
99: SELECT d.plan_start_date, d.plan_cmplt_date
100: FROM gme_batch_step_items i, gme_batch_steps d
101: WHERE d.batchstep_id = i.batchstep_id
102: AND i.material_detail_id = v_material_detail_id;
103:
104: l_step_rec cur_step_matl_detail%ROWTYPE;

Line 438: FROM gme_batch_step_items i, gme_material_details d

434: v_batch_id NUMBER
435: ,v_batchstep_id NUMBER)
436: IS
437: SELECT d.phantom_id
438: FROM gme_batch_step_items i, gme_material_details d
439: WHERE d.batch_id = v_batch_id
440: AND i.material_detail_id = d.material_detail_id
441: AND batchstep_id = v_batchstep_id
442: AND ( d.release_type = gme_common_pvt.g_mtl_autobystep_release