APPS.QA_VALIDATION_API dependencies on MTL_SYSTEM_ITEMS

Line 709: from mtl_system_items

705:
706: CURSOR c2 (i_id NUMBER, o_id NUMBER) IS
707: select restrict_subinventories_code, restrict_locators_code,
708: location_control_code, revision_qty_control_code
709: from mtl_system_items
710: where inventory_item_id = i_id
711: and organization_id = o_id;
712:
713: BEGIN

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 867: from mtl_system_items

863:
864: CURSOR c2 (i_id NUMBER, o_id NUMBER) IS
865: select restrict_subinventories_code, restrict_locators_code,
866: location_control_code, revision_qty_control_code
867: from mtl_system_items
868: where inventory_item_id = i_id
869: and organization_id = o_id;
870:
871: BEGIN

Line 1245: from mtl_system_items

1241:
1242: CURSOR c2 (i_id NUMBER, o_id NUMBER) IS
1243: select restrict_subinventories_code, restrict_locators_code,
1244: location_control_code, revision_qty_control_code
1245: from mtl_system_items
1246: where inventory_item_id = i_id
1247: and organization_id = o_id;
1248:
1249: BEGIN

Line 1307: from mtl_system_items

1303:
1304: CURSOR c2 (i_id NUMBER, o_id NUMBER) IS
1305: select restrict_subinventories_code, restrict_locators_code,
1306: location_control_code, revision_qty_control_code
1307: from mtl_system_items
1308: where inventory_item_id = i_id
1309: and organization_id = o_id;
1310:
1311: BEGIN