APPS.GMD_QC_MIG12 dependencies on IC_ITEM_MST_B

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 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: ====================================================*/