APPS.INV_UPDATE_ONHAND_STATUS dependencies on MTL_PARAMETERS

Line 51: SELECT organization_id FROM mtl_parameters

47: ORDER BY subinventory_code
48: FOR UPDATE NOWAIT ;
49:
50: CURSOR c_org_id (l_from_org_code IN VARCHAR2 ,l_to_org_code IN VARCHAR2) IS
51: SELECT organization_id FROM mtl_parameters
52: WHERE organization_code BETWEEN l_from_org_code AND l_to_org_code ;
53:
54:
55: BEGIN

Line 123: FROM mtl_parameters

119: print_debug('Running for OrganizationId =' || orgid_list(i));
120:
121: SELECT NVL(default_status_id, -1)
122: INTO l_default_status_id
123: FROM mtl_parameters
124: WHERE organization_id = orgid_list(i);
125:
126: IF (l_default_status_id = -1) THEN
127:

Line 176: UPDATE mtl_parameters

172: AND rownum = 1;
173:
174: IF (l_count = 0) THEN
175:
176: UPDATE mtl_parameters
177: SET default_status_id = (SELECT status_id
178: FROM mtl_material_statuses_vl
179: WHERE status_code = p_default_status)
180: WHERE organization_id = orgid_list(i);