Oracle APPS ISO Internal Location details and deletion from backend.

SELECT * FROM PO_LOCATION_ASSOCIATIONS_ALL

WHERE LOCATION_ID = &location_id AND ORG_ID = &enter org_id;

 If it returns any row, it means that, indeed, an Internal location is Already assigned to another Ship-to Address 

For deletion of internal location association

Please run following datafix:

Take a backup of table :- FROM PO_LOCATION_ASSOCIATIONS_ALL

 DELETE FROM PO_LOCATION_ASSOCIATIONS_ALL

WHERE LOCATION_ID = &location_id AND ORG_ID = &enter org_id;