APPS.INVICGDS dependencies on MTL_SYSTEM_ITEMS_B

Line 25: FROM mtl_system_items_B MSI

21: /* This cursor gets all child item rows for a given III and org*/
22:
23: CURSOR get_item_rows(iii NUMBER, org NUMBER) IS
24: SELECT inventory_item_id, organization_id--, description
25: FROM mtl_system_items_B MSI
26: WHERE (MSI.inventory_item_id = iii OR iii IS NULL)
27: AND (MSI.organization_id = org OR org IS NULL)
28: AND MSI.ITEM_CATALOG_GROUP_ID is NOT NULL;
29:

Line 44: FROM mtl_system_items_B MSI

40: WHERE mp.master_organization_id = m_org);
41: */
42: CURSOR get_child_item_rows(iii NUMBER, m_org NUMBER) IS
43: SELECT inventory_item_id, organization_id
44: FROM mtl_system_items_B MSI
45: WHERE MSI.inventory_item_id = iii
46: AND EXISTS (SELECT NULL
47: FROM mtl_parameters mp
48: WHERE mp.master_organization_id = m_org

Line 102: UPDATE mtl_system_items_B MSI

98: FOR gcir in get_child_item_rows( gir.inventory_item_id,
99: gir.organization_id )
100: LOOP
101:
102: UPDATE mtl_system_items_B MSI
103: SET
104: MSI.description = decode(l_INSTALLED_FLAG,'B', new_description, MSI.description)
105: WHERE MSI.inventory_item_id = gcir.inventory_item_id
106: AND MSI.organization_id = gcir.organization_id;

Line 126: UPDATE mtl_system_items_B MSI

122: END LOOP;
123:
124: ELSIF desc_control_level = 2 THEN
125:
126: UPDATE mtl_system_items_B MSI
127: SET
128: MSI.description = decode(l_INSTALLED_FLAG,'B', new_description, MSI.description)
129: WHERE MSI.inventory_item_id = gir.inventory_item_id
130: AND MSI.organization_id = gir.organization_id;

Line 158: UPDATE mtl_system_items_B MSI

154: NULL;
155:
156: ELSIF desc_control_level = 2 THEN
157:
158: UPDATE mtl_system_items_B MSI
159: SET
160: MSI.description = decode(l_INSTALLED_FLAG,'B', new_description, MSI.description)
161: WHERE MSI.inventory_item_id = gir.inventory_item_id
162: AND MSI.organization_id = gir.organization_id;

Line 291: FROM mtl_system_items_B MSI

287: **There is no point in proceeding further if there is no ICG for the item
288: */
289: BEGIN
290: SELECT item_catalog_group_id INTO icg_id_val
291: FROM mtl_system_items_B MSI
292: WHERE MSI.inventory_item_id = inv_item_id
293: AND rownum =1;
294: /*added rownum clause because this stmt may return more than one
295: identical rows*/