APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_SHIP_FROM_ORGS_V

Line 1045: from WSH_SHIP_FROM_ORGS_V SFOV,

1041: l_num_warnings NUMBER := 0;
1042:
1043: cursor l_get_org_loc_id_csr (c_organization_id IN NUMBER) IS
1044: select SFOV.location_id FROM_LOCATION_ID, WLT.LOCATION_ID GTMP_LOCATION_ID
1045: from WSH_SHIP_FROM_ORGS_V SFOV,
1046: WSH_OTM_LOCATIONS_GTMP WLT
1047: WHERE SFOV.organization_id = c_organization_id
1048: AND SFOV.ORGANIZATION_ID = WLT.CORPORATION_ID (+)
1049: AND WLT.LOCATION_TYPE (+) = 'ORG_LOC';