APPS.QA_VALIDATION_API dependencies on MTL_SECONDARY_INVENTORIES

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

941: where organization_id = org_id;
942:
943:
944: -- Bug 3381173. The cursor C2 was based on the view mtl_subinventories_val_v,
945: -- which is only for storage subs. Based the cursor on mtl_secondary_inventories
946: -- and added the where clause to differentiate receiving subs.
947: -- kabalakr Tue Jan 27 02:18:59 PST 2004.
948:
949: CURSOR C2 (org_id NUMBER) IS

Line 951: FROM mtl_secondary_inventories

947: -- kabalakr Tue Jan 27 02:18:59 PST 2004.
948:
949: CURSOR C2 (org_id NUMBER) IS
950: select locator_type
951: FROM mtl_secondary_inventories
952: WHERE organization_id = org_id
953: AND ((((SUBINVENTORY_TYPE <> 2) OR (SUBINVENTORY_TYPE IS NULL))
954: AND nvl(disable_date, sysdate+1) > sysdate)
955: OR (SUBINVENTORY_TYPE = 2))