APPS.GMD_QC_MIG12 dependencies on IC_ITEM_MST

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

2497: l_source_subinv_loc mtl_item_locations.subinventory_code%TYPE;
2498: l_src_sub_organization_id mtl_item_locations.organization_id%TYPE;
2499:
2500:
2501: CURSOR get_item_data (v_item_id ic_item_mst.item_id%TYPE) IS
2502: SELECT sublot_ctl
2503: FROM ic_item_mst_b
2504: WHERE item_id = v_item_id;
2505:

Line 2503: FROM ic_item_mst_b

2499:
2500:
2501: CURSOR get_item_data (v_item_id ic_item_mst.item_id%TYPE) IS
2502: SELECT sublot_ctl
2503: FROM ic_item_mst_b
2504: WHERE item_id = v_item_id;
2505:
2506: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
2507:

Line 2506: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;

2502: SELECT sublot_ctl
2503: FROM ic_item_mst_b
2504: WHERE item_id = v_item_id;
2505:
2506: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
2507:
2508: CURSOR get_sampling_event IS
2509: SELECT sampling_event_id
2510: FROM gmd_sampling_events

Line 3766: FROM ic_item_mst_b

3762: =======================================*/
3763:
3764: CURSOR get_item_data IS
3765: SELECT sublot_ctl
3766: FROM ic_item_mst_b
3767: WHERE item_id = l_item_id;
3768:
3769: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
3770:

Line 3769: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;

3765: SELECT sublot_ctl
3766: FROM ic_item_mst_b
3767: WHERE item_id = l_item_id;
3768:
3769: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
3770:
3771: /*====================================================
3772: Cursor to check if gmd_inventory_spec_vrs exists.
3773: ====================================================*/