APPS.GMD_SAMPLES_GRP dependencies on IC_ITEM_MST

Line 1358: -- Bug 4165704: got primary uom from mtl_system_items instead of ic_item_mst

1354: END IF;
1355:
1356: -- Sample Quantity UOM must be convertible to Item's UOM
1357: IF p_sample.sample_type = 'I' THEN
1358: -- Bug 4165704: got primary uom from mtl_system_items instead of ic_item_mst
1359: --l_in_item_mst.inventory_item_id := p_sample.inventory_item_id;
1360: --IF NOT gmivdbl.ic_item_mst_select (l_in_item_mst, l_item_mst) THEN
1361: -- RAISE e_error_fetch_item;
1362: --END IF;

Line 1360: --IF NOT gmivdbl.ic_item_mst_select (l_in_item_mst, l_item_mst) THEN

1356: -- Sample Quantity UOM must be convertible to Item's UOM
1357: IF p_sample.sample_type = 'I' THEN
1358: -- Bug 4165704: got primary uom from mtl_system_items instead of ic_item_mst
1359: --l_in_item_mst.inventory_item_id := p_sample.inventory_item_id;
1360: --IF NOT gmivdbl.ic_item_mst_select (l_in_item_mst, l_item_mst) THEN
1361: -- RAISE e_error_fetch_item;
1362: --END IF;
1363:
1364: OPEN fetch_mtl_system_items;

Line 2351: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence

2347: RAISE INVALID_QC_STATUS;
2348: END IF;
2349:
2350: IF p_sample_id IS NOT NULL THEN
2351: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence
2352: SELECT gs.organization_id ,
2353: gs.inventory_item_id,
2354: iim.concatenated_segments,
2355: gs.parent_lot_number,

Line 2376: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence

2372: WHERE gs.sample_id = p_sample_id
2373: AND gs.inventory_item_id = iim.inventory_item_id
2374: AND gs.organization_id = iim.organization_id;
2375: ELSE
2376: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence
2377: SELECT gse.organization_id,
2378: gse.inventory_item_id,
2379: iim.concatenated_segments,
2380: gse.parent_lot_number,

Line 3161: ic_item_mst i

3157: SELECT 1
3158: FROM oe_order_lines_all l,
3159: mtl_system_items_b m,
3160: mtl_parameters mp,
3161: ic_item_mst i
3162: WHERE l.header_id = p_sample.order_id
3163: AND l.line_id = p_sample.order_line_id
3164: AND l.ship_to_org_id = p_sample.ship_to_site_id
3165: AND m.inventory_item_id = l.inventory_item_id

Line 3190: -- Bug 4165704: removed ic_item_mst_b test

3186: WHERE vendor_id = p_sample.supplier_id
3187: AND po_header_id = p_sample.po_header_id
3188: ;
3189:
3190: -- Bug 4165704: removed ic_item_mst_b test
3191: CURSOR c_po_line IS
3192: SELECT 1
3193: FROM po_lines_all l
3194: WHERE l.po_header_id = p_sample.po_header_id

Line 4423: --RLNAGARA B5106191 Replaced the query in the cursor C_item_no which was using ic_item_mst.

4419: qty IN NUMBER,
4420: x_return_status OUT NOCOPY VARCHAR2
4421: ) IS
4422:
4423: --RLNAGARA B5106191 Replaced the query in the cursor C_item_no which was using ic_item_mst.
4424: /* CURSOR C_item_no(item_id VARCHAR2) IS
4425: SELECT item_no
4426: FROM ic_item_mst
4427: WHERE item_id = item_id;

Line 4426: FROM ic_item_mst

4422:
4423: --RLNAGARA B5106191 Replaced the query in the cursor C_item_no which was using ic_item_mst.
4424: /* CURSOR C_item_no(item_id VARCHAR2) IS
4425: SELECT item_no
4426: FROM ic_item_mst
4427: WHERE item_id = item_id;
4428: */
4429: CURSOR C_item_no(p_inventory_item_id NUMBER,p_organization_id NUMBER) IS
4430: SELECT concatenated_segments item_number