APPS.QA_VALIDATION_API dependencies on MTL_SECONDARY_INVENTORIES

Line 956: -- which is only for storage subs. Based the cursor on mtl_secondary_inventories

952: where organization_id = org_id;
953:
954:
955: -- Bug 3381173. The cursor C2 was based on the view mtl_subinventories_val_v,
956: -- which is only for storage subs. Based the cursor on mtl_secondary_inventories
957: -- and added the where clause to differentiate receiving subs.
958: -- kabalakr Tue Jan 27 02:18:59 PST 2004.
959:
960: CURSOR C2 (org_id NUMBER) IS

Line 962: FROM mtl_secondary_inventories

958: -- kabalakr Tue Jan 27 02:18:59 PST 2004.
959:
960: CURSOR C2 (org_id NUMBER) IS
961: select locator_type
962: FROM mtl_secondary_inventories
963: WHERE organization_id = org_id
964: AND ((((SUBINVENTORY_TYPE <> 2) OR (SUBINVENTORY_TYPE IS NULL))
965: AND nvl(disable_date, sysdate+1) > sysdate)
966: OR (SUBINVENTORY_TYPE = 2))