APPS.QA_VALIDATION_API dependencies on MTL_PARAMETERS

Line 825: FROM mtl_system_items_kfv msi, mtl_parameters mp

821:
822: CURSOR c2 (i_value VARCHAR2, o_id NUMBER) IS
823: SELECT restrict_subinventories_code, restrict_locators_code,
824: location_control_code, revision_qty_control_code,inventory_item_id
825: FROM mtl_system_items_kfv msi, mtl_parameters mp
826: WHERE msi.concatenated_segments = i_value
827: AND msi.organization_id = mp.organization_id
828: AND mp.maint_organization_id = o_id
829: AND rownum = 1;

Line 951: from mtl_parameters

947: x_where_clause VARCHAR2(500);
948:
949: CURSOR C1 (org_id NUMBER) IS
950: select stock_locator_control_code, negative_inv_receipt_code
951: from mtl_parameters
952: where organization_id = org_id;
953:
954:
955: -- Bug 3381173. The cursor C2 was based on the view mtl_subinventories_val_v,

Line 1104: from mtl_parameters

1100: x_where_clause VARCHAR2(500);
1101:
1102: CURSOR C1 (org_id NUMBER) IS
1103: select stock_locator_control_code, negative_inv_receipt_code
1104: from mtl_parameters
1105: where organization_id = org_id;
1106:
1107: --
1108: -- Bug 6126260

Line 1372: from mtl_parameters

1368: x_where_clause VARCHAR2(500);
1369:
1370: CURSOR C1 (org_id NUMBER) IS
1371: select stock_locator_control_code, negative_inv_receipt_code
1372: from mtl_parameters
1373: where organization_id = org_id;
1374:
1375: CURSOR C2 (org_id NUMBER) IS
1376: select locator_type