APPS.OE_ITORD_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 1012: FROM hz_cust_site_uses_all site

1008: l_rule_level_id := TO_NUMBER(p_rule_level_value);
1009:
1010: SELECT site.location
1011: INTO l_rule_level_value
1012: FROM hz_cust_site_uses_all site
1013: WHERE site.site_use_code = 'SHIP_TO'
1014: AND site.site_use_id= l_rule_level_id;
1015:
1016: ELSIF p_rule_level = 'BILL_TO_LOC'

Line 1023: FROM hz_cust_site_uses_all site

1019: l_rule_level_id := TO_NUMBER(p_rule_level_value);
1020:
1021: SELECT site.location
1022: INTO l_rule_level_value
1023: FROM hz_cust_site_uses_all site
1024: WHERE site.site_use_code = 'BILL_TO'
1025: AND site.site_use_id= l_rule_level_id;
1026:
1027: ELSIF p_rule_level = 'DELIVER_TO_LOC'

Line 1034: FROM hz_cust_site_uses_all site

1030: l_rule_level_id := TO_NUMBER(p_rule_level_value);
1031:
1032: SELECT site.location
1033: INTO l_rule_level_value
1034: FROM hz_cust_site_uses_all site
1035: WHERE site.site_use_code = 'DELIVER_TO'
1036: AND site.site_use_id= l_rule_level_id;
1037: ELSE
1038: l_rule_level_value := 'Invalid rule passed';

Line 1056: FROM hz_cust_site_uses_all site_uses,

1052: BEGIN
1053:
1054: SELECT loc.location_id
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