APPS.GMD_SAMPLES_GRP dependencies on IC_ITEM_MST

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

1451: END IF;
1452:
1453: -- Sample Quantity UOM must be convertible to Item's UOM
1454: IF p_sample.sample_type = 'I' THEN
1455: -- Bug 4165704: got primary uom from mtl_system_items instead of ic_item_mst
1456: --l_in_item_mst.inventory_item_id := p_sample.inventory_item_id;
1457: --IF NOT gmivdbl.ic_item_mst_select (l_in_item_mst, l_item_mst) THEN
1458: -- RAISE e_error_fetch_item;
1459: --END IF;

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

1453: -- Sample Quantity UOM must be convertible to Item's UOM
1454: IF p_sample.sample_type = 'I' THEN
1455: -- Bug 4165704: got primary uom from mtl_system_items instead of ic_item_mst
1456: --l_in_item_mst.inventory_item_id := p_sample.inventory_item_id;
1457: --IF NOT gmivdbl.ic_item_mst_select (l_in_item_mst, l_item_mst) THEN
1458: -- RAISE e_error_fetch_item;
1459: --END IF;
1460:
1461: OPEN fetch_mtl_system_items;

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

2594: RAISE INVALID_QC_STATUS;
2595: END IF;
2596:
2597: IF p_sample_id IS NOT NULL THEN
2598: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence
2599: SELECT gs.organization_id ,
2600: gs.inventory_item_id,
2601: iim.concatenated_segments,
2602: gs.parent_lot_number,

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

2630:
2631:
2632:
2633: ELSE
2634: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence
2635: SELECT gse.organization_id,
2636: gse.inventory_item_id,
2637: iim.concatenated_segments,
2638: gse.parent_lot_number,

Line 3756: ic_item_mst i

3752: SELECT 1
3753: FROM oe_order_lines_all l,
3754: mtl_system_items_b m,
3755: mtl_parameters mp,
3756: ic_item_mst i
3757: WHERE l.header_id = p_sample.order_id
3758: AND l.line_id = p_sample.order_line_id
3759: AND l.ship_to_org_id = p_sample.ship_to_site_id
3760: AND m.inventory_item_id = l.inventory_item_id

Line 3785: -- Bug 4165704: removed ic_item_mst_b test

3781: WHERE vendor_id = p_sample.supplier_id
3782: AND po_header_id = p_sample.po_header_id
3783: ;
3784:
3785: -- Bug 4165704: removed ic_item_mst_b test
3786: CURSOR c_po_line IS
3787: SELECT 1
3788: FROM po_lines_all l
3789: WHERE l.po_header_id = p_sample.po_header_id

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

5064: qty IN NUMBER,
5065: x_return_status OUT NOCOPY VARCHAR2
5066: ) IS
5067:
5068: --RLNAGARA B5106191 Replaced the query in the cursor C_item_no which was using ic_item_mst.
5069: /* CURSOR C_item_no(item_id VARCHAR2) IS
5070: SELECT item_no
5071: FROM ic_item_mst
5072: WHERE item_id = item_id;

Line 5071: FROM ic_item_mst

5067:
5068: --RLNAGARA B5106191 Replaced the query in the cursor C_item_no which was using ic_item_mst.
5069: /* CURSOR C_item_no(item_id VARCHAR2) IS
5070: SELECT item_no
5071: FROM ic_item_mst
5072: WHERE item_id = item_id;
5073: */
5074: CURSOR C_item_no(p_inventory_item_id NUMBER,p_organization_id NUMBER) IS
5075: SELECT concatenated_segments item_number