DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 2545: FROM gme_batch_steps s, gme_batch_step_items i

2541: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
2542: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER)
2543: IS
2544: SELECT step_status
2545: FROM gme_batch_steps s, gme_batch_step_items i
2546: WHERE s.batchstep_id = i.batchstep_id
2547: AND i.material_detail_id = v_matl_dtl_id;
2548:
2549: CURSOR cur_lot_input (v_trans_inter_id NUMBER)

Line 4753: FROM gme_batch_steps s, gme_batch_step_items i

4749: FROM mtl_system_items_b
4750: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
4751: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS
4752: SELECT step_status
4753: FROM gme_batch_steps s, gme_batch_step_items i
4754: WHERE s.batchstep_id = i.batchstep_id
4755: AND i.material_detail_id = v_matl_dtl_id;
4756: l_mat_dtl_rec gme_material_details%ROWTYPE;
4757: l_batch_hdr_rec gme_batch_header%ROWTYPE;