APPS.INVICGDS dependencies on MTL_PARAMETERS

Line 39: FROM mtl_parameters mp

35: FROM mtl_system_items_VL MSI
36: WHERE MSI.inventory_item_id = NVL(iii, MSI.inventory_item_id)
37: AND MSI.item_catalog_group_id is NOT NULL
38: AND MSI.organization_id in (SELECT organization_id
39: FROM mtl_parameters mp
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

Line 47: FROM mtl_parameters mp

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
49: AND MSI.organization_id = mp.organization_id);
50:
51:

Line 87: FROM mtl_parameters mp

83: new_description,
84: new_error_text);
85:
86: SELECT mp.master_organization_id INTO master_org_id_val
87: FROM mtl_parameters mp
88: WHERE mp.organization_id = gir.organization_id;
89:
90: SELECT mia.control_level INTO desc_control_level
91: FROM mtl_item_attributes mia