DBA Data[Home] [Help]

APPS.GME_PHANTOM_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 88: FROM gme_batch_step_items i, gme_batch_steps d

84:
85: CURSOR cur_step_matl_detail (v_material_detail_id NUMBER)
86: IS
87: SELECT d.plan_start_date, d.plan_cmplt_date
88: FROM gme_batch_step_items i, gme_batch_steps d
89: WHERE d.batchstep_id = i.batchstep_id
90: AND i.material_detail_id = v_material_detail_id;
91:
92: l_step_rec cur_step_matl_detail%ROWTYPE;

Line 403: FROM gme_batch_step_items i, gme_material_details d

399: v_batch_id NUMBER
400: ,v_batchstep_id NUMBER)
401: IS
402: SELECT d.phantom_id
403: FROM gme_batch_step_items i, gme_material_details d
404: WHERE d.batch_id = v_batch_id
405: AND i.material_detail_id = d.material_detail_id
406: AND batchstep_id = v_batchstep_id
407: AND ( d.release_type = gme_common_pvt.g_mtl_autobystep_release