APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_SHIP_FROM_ORGS_V

Line 1006: from WSH_SHIP_FROM_ORGS_V SFOV,

1002: l_num_warnings NUMBER := 0;
1003:
1004: cursor l_get_org_loc_id_csr (c_organization_id IN NUMBER) IS
1005: select SFOV.location_id FROM_LOCATION_ID, WLT.LOCATION_ID GTMP_LOCATION_ID
1006: from WSH_SHIP_FROM_ORGS_V SFOV,
1007: WSH_OTM_LOCATIONS_GTMP WLT
1008: WHERE SFOV.organization_id = c_organization_id
1009: AND SFOV.ORGANIZATION_ID = WLT.CORPORATION_ID (+)
1010: AND WLT.LOCATION_TYPE (+) = 'ORG_LOC';