APPS.QA_VALIDATION_API dependencies on MTL_PARAMETERS

Line 814: FROM mtl_system_items_kfv msi, mtl_parameters mp

810:
811: CURSOR c2 (i_value VARCHAR2, o_id NUMBER) IS
812: SELECT restrict_subinventories_code, restrict_locators_code,
813: location_control_code, revision_qty_control_code,inventory_item_id
814: FROM mtl_system_items_kfv msi, mtl_parameters mp
815: WHERE msi.concatenated_segments = i_value
816: AND msi.organization_id = mp.organization_id
817: AND mp.maint_organization_id = o_id
818: AND rownum = 1;

Line 940: from mtl_parameters

936: x_where_clause VARCHAR2(500);
937:
938: CURSOR C1 (org_id NUMBER) IS
939: select stock_locator_control_code, negative_inv_receipt_code
940: from mtl_parameters
941: where organization_id = org_id;
942:
943:
944: -- Bug 3381173. The cursor C2 was based on the view mtl_subinventories_val_v,

Line 1093: from mtl_parameters

1089: x_where_clause VARCHAR2(500);
1090:
1091: CURSOR C1 (org_id NUMBER) IS
1092: select stock_locator_control_code, negative_inv_receipt_code
1093: from mtl_parameters
1094: where organization_id = org_id;
1095:
1096: --
1097: -- Bug 6126260

Line 1361: from mtl_parameters

1357: x_where_clause VARCHAR2(500);
1358:
1359: CURSOR C1 (org_id NUMBER) IS
1360: select stock_locator_control_code, negative_inv_receipt_code
1361: from mtl_parameters
1362: where organization_id = org_id;
1363:
1364: CURSOR C2 (org_id NUMBER) IS
1365: select locator_type