APPS.GMD_QC_MIGRATE_TO_1151J dependencies on IC_LOTS_MST

Line 2346: FROM ic_lots_mst

2342:
2343: -- Get the lot numbers
2344: CURSOR c_lot_nums (v_lot_id number) IS
2345: SELECT lot_no, sublot_no
2346: FROM ic_lots_mst
2347: WHERE lot_id = v_lot_id;
2348:
2349: l_lot_no ic_lots_mst.lot_no%TYPE;
2350: l_sublot_no ic_lots_mst.sublot_no%TYPE;

Line 2349: l_lot_no ic_lots_mst.lot_no%TYPE;

2345: SELECT lot_no, sublot_no
2346: FROM ic_lots_mst
2347: WHERE lot_id = v_lot_id;
2348:
2349: l_lot_no ic_lots_mst.lot_no%TYPE;
2350: l_sublot_no ic_lots_mst.sublot_no%TYPE;
2351:
2352: -- Get the recipe id + no + version
2353: CURSOR c_recipe_id_no_vers (v_batch_id number) IS

Line 2350: l_sublot_no ic_lots_mst.sublot_no%TYPE;

2346: FROM ic_lots_mst
2347: WHERE lot_id = v_lot_id;
2348:
2349: l_lot_no ic_lots_mst.lot_no%TYPE;
2350: l_sublot_no ic_lots_mst.sublot_no%TYPE;
2351:
2352: -- Get the recipe id + no + version
2353: CURSOR c_recipe_id_no_vers (v_batch_id number) IS
2354: SELECT r.recipe_id, r.recipe_no, r.recipe_version

Line 3780: l_lot_no ic_lots_mst.lot_no%TYPE;

3776: l_customer_spec_rec GMD_SPEC_MATCH_MIG_GRP.customer_spec_rec_type;
3777: l_inventory_spec_rec GMD_SPEC_MATCH_MIG_GRP.inventory_spec_rec_type;
3778: l_supplier_spec_rec GMD_SPEC_MATCH_MIG_GRP.supplier_spec_rec_type;
3779:
3780: l_lot_no ic_lots_mst.lot_no%TYPE;
3781: l_sublot_no ic_lots_mst.sublot_no%TYPE;
3782: l_recipe_id NUMBER;
3783: l_r_qc_spec_id NUMBER;
3784: l_r_tests_cnt NUMBER;

Line 3781: l_sublot_no ic_lots_mst.sublot_no%TYPE;

3777: l_inventory_spec_rec GMD_SPEC_MATCH_MIG_GRP.inventory_spec_rec_type;
3778: l_supplier_spec_rec GMD_SPEC_MATCH_MIG_GRP.supplier_spec_rec_type;
3779:
3780: l_lot_no ic_lots_mst.lot_no%TYPE;
3781: l_sublot_no ic_lots_mst.sublot_no%TYPE;
3782: l_recipe_id NUMBER;
3783: l_r_qc_spec_id NUMBER;
3784: l_r_tests_cnt NUMBER;
3785: l_sm_spec_id NUMBER;

Line 3811: FROM ic_lots_mst

3807: /* ------------------ CURSORS ---------------------- */
3808: /* Get lot_no and sublot_no */
3809: CURSOR c_lot_sublot (v_lot_id NUMBER) IS
3810: SELECT lot_no, sublot_no
3811: FROM ic_lots_mst
3812: WHERE lot_id = v_lot_id;
3813:
3814: /* Get recipe_id based on batch_id */
3815: CURSOR c_recipe_id (v_batch_id number) IS