DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 3395: FROM gme_batch_steps s, gme_batch_step_items i

3391: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
3392: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER)
3393: IS
3394: SELECT step_status
3395: FROM gme_batch_steps s, gme_batch_step_items i
3396: WHERE s.batchstep_id = i.batchstep_id
3397: AND i.material_detail_id = v_matl_dtl_id;
3398:
3399: CURSOR cur_lot_input (v_trans_inter_id NUMBER)

Line 5799: FROM gme_batch_steps s, gme_batch_step_items i

5795: FROM mtl_system_items_b
5796: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
5797: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS
5798: SELECT step_status
5799: FROM gme_batch_steps s, gme_batch_step_items i
5800: WHERE s.batchstep_id = i.batchstep_id
5801: AND i.material_detail_id = v_matl_dtl_id;
5802: l_mat_dtl_rec gme_material_details%ROWTYPE;
5803: l_batch_hdr_rec gme_batch_header%ROWTYPE;