APPS.OE_ITORD_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 1043: FROM hz_cust_site_uses_all site

1039: l_rule_level_id := TO_NUMBER(p_rule_level_value);
1040:
1041: SELECT site.location
1042: INTO l_rule_level_value
1043: FROM hz_cust_site_uses_all site
1044: WHERE site.site_use_code = 'SHIP_TO'
1045: AND site.site_use_id= l_rule_level_id;
1046:
1047: ELSIF p_rule_level = 'BILL_TO_LOC'

Line 1054: FROM hz_cust_site_uses_all site

1050: l_rule_level_id := TO_NUMBER(p_rule_level_value);
1051:
1052: SELECT site.location
1053: INTO l_rule_level_value
1054: FROM hz_cust_site_uses_all site
1055: WHERE site.site_use_code = 'BILL_TO'
1056: AND site.site_use_id= l_rule_level_id;
1057:
1058: ELSIF p_rule_level = 'DELIVER_TO_LOC'

Line 1065: FROM hz_cust_site_uses_all site

1061: l_rule_level_id := TO_NUMBER(p_rule_level_value);
1062:
1063: SELECT site.location
1064: INTO l_rule_level_value
1065: FROM hz_cust_site_uses_all site
1066: WHERE site.site_use_code = 'DELIVER_TO'
1067: AND site.site_use_id= l_rule_level_id;
1068: ELSE
1069: l_rule_level_value := 'Invalid rule passed';

Line 1087: FROM hz_cust_site_uses_all site_uses,

1083: BEGIN
1084:
1085: SELECT loc.location_id
1086: INTO l_ship_to_location_id
1087: FROM hz_cust_site_uses_all site_uses,
1088: hz_cust_acct_sites_all acct_site,
1089: hz_party_sites party_site,
1090: hz_locations loc
1091: WHERE site_uses.cust_acct_site_id = acct_site.cust_acct_site_id