DBA Data[Home] [Help]

APPS.OE_ITORD_UTIL dependencies on HZ_LOCATIONS

Line 1045: --Returns hz_locations.location_id for the given site_use_id

1041: RETURN l_rule_level_value;
1042:
1043: END;
1044:
1045: --Returns hz_locations.location_id for the given site_use_id
1046: FUNCTION Get_Shipto_Location_Id
1047: (p_site_use_id IN NUMBER
1048: )
1049: RETURN NUMBER

Line 1059: hz_locations loc

1055: INTO l_ship_to_location_id
1056: FROM hz_cust_site_uses_all site_uses,
1057: hz_cust_acct_sites_all acct_site,
1058: hz_party_sites party_site,
1059: hz_locations loc
1060: WHERE site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
1061: AND acct_site.party_site_id = party_site.party_site_id
1062: AND loc.location_id = party_site.location_id
1063: AND site_uses.site_use_code = 'SHIP_TO'