APPS.GMD_QC_MIG12 dependencies on IC_ITEM_MST

Line 2520: CURSOR get_item_data (v_item_id ic_item_mst.item_id%TYPE) IS

2516: l_source_subinv_loc mtl_item_locations.subinventory_code%TYPE;
2517: l_src_sub_organization_id mtl_item_locations.organization_id%TYPE;
2518:
2519:
2520: CURSOR get_item_data (v_item_id ic_item_mst.item_id%TYPE) IS
2521: SELECT sublot_ctl
2522: FROM ic_item_mst_b
2523: WHERE item_id = v_item_id;
2524:

Line 2522: FROM ic_item_mst_b

2518:
2519:
2520: CURSOR get_item_data (v_item_id ic_item_mst.item_id%TYPE) IS
2521: SELECT sublot_ctl
2522: FROM ic_item_mst_b
2523: WHERE item_id = v_item_id;
2524:
2525: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
2526:

Line 2525: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;

2521: SELECT sublot_ctl
2522: FROM ic_item_mst_b
2523: WHERE item_id = v_item_id;
2524:
2525: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
2526:
2527: -- cursor modified while fixing bug 14198664
2528: CURSOR get_sampling_event IS
2529: SELECT gse.sampling_event_id

Line 2550: CURSOR get_lot (v_item_id ic_item_mst.item_id%TYPE ,v_lot_no ic_lots_mst.lot_no%TYPE ) IS

2546: AND rowid BETWEEN p_start_rowid AND p_end_rowid
2547: AND (migrated_ind = 1 OR organization_id IS NOT NULL);
2548:
2549: -- 13685161
2550: CURSOR get_lot (v_item_id ic_item_mst.item_id%TYPE ,v_lot_no ic_lots_mst.lot_no%TYPE ) IS
2551: SELECT lot_no, sublot_no
2552: FROM ic_lots_mst
2553: WHERE item_id = v_item_id
2554: and lot_no = v_lot_no

Line 2559: CURSOR get_parent_lot_number_mig (v_item_id ic_item_mst.item_id%TYPE ,v_lot_no

2555: ORDER BY sublot_no desc;
2556:
2557:
2558: -- 13826138
2559: CURSOR get_parent_lot_number_mig (v_item_id ic_item_mst.item_id%TYPE ,v_lot_no
2560: ic_lots_mst.lot_no%TYPE ) IS
2561: SELECT parent_lot_number
2562: FROM ic_lots_mst_mig
2563: WHERE migrated_ind = 1

Line 4035: FROM ic_item_mst_b

4031: =======================================*/
4032:
4033: CURSOR get_item_data IS
4034: SELECT sublot_ctl
4035: FROM ic_item_mst_b
4036: WHERE item_id = l_item_id;
4037:
4038: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
4039:

Line 4038: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;

4034: SELECT sublot_ctl
4035: FROM ic_item_mst_b
4036: WHERE item_id = l_item_id;
4037:
4038: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
4039:
4040: /*====================================================
4041: Cursor to check if gmd_inventory_spec_vrs exists.
4042: ====================================================*/