DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 472: FROM gme_material_details matl, gme_batch_step_items item

468:
469:
470: CURSOR Cur_step_prod_byprod(v_batchstep_id NUMBER) IS
471: SELECT matl.*
472: FROM gme_material_details matl, gme_batch_step_items item
473: WHERE item.batchstep_id = v_batchstep_id
474: AND item.material_detail_id = matl.material_detail_id
475: AND (matl.line_type IN (gme_common_pvt.g_line_type_prod, gme_common_pvt.g_line_type_byprod) OR
476: (matl.line_type = gme_common_pvt.g_line_type_ing AND matl.phantom_id IS NOT NULL))