APPS.QA_VALIDATION_API dependencies on MTL_SYSTEM_ITEMS

Line 698: from mtl_system_items

694:
695: CURSOR c2 (i_id NUMBER, o_id NUMBER) IS
696: select restrict_subinventories_code, restrict_locators_code,
697: location_control_code, revision_qty_control_code
698: from mtl_system_items
699: where inventory_item_id = i_id
700: and organization_id = o_id;
701:
702: BEGIN

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

852:
853: CURSOR c2 (i_id NUMBER, o_id NUMBER) IS
854: select restrict_subinventories_code, restrict_locators_code,
855: location_control_code, revision_qty_control_code
856: from mtl_system_items
857: where inventory_item_id = i_id
858: and organization_id = o_id;
859:
860: BEGIN

Line 1234: from mtl_system_items

1230:
1231: CURSOR c2 (i_id NUMBER, o_id NUMBER) IS
1232: select restrict_subinventories_code, restrict_locators_code,
1233: location_control_code, revision_qty_control_code
1234: from mtl_system_items
1235: where inventory_item_id = i_id
1236: and organization_id = o_id;
1237:
1238: BEGIN

Line 1296: from mtl_system_items

1292:
1293: CURSOR c2 (i_id NUMBER, o_id NUMBER) IS
1294: select restrict_subinventories_code, restrict_locators_code,
1295: location_control_code, revision_qty_control_code
1296: from mtl_system_items
1297: where inventory_item_id = i_id
1298: and organization_id = o_id;
1299:
1300: BEGIN