APPS.XNB_SALES_ORDER_PVT dependencies on HZ_LOCATIONS

Line 752: hz_locations locations

748: hz_cust_acct_sites_all a,
749: hz_cust_accounts b,
750: hz_parties c,
751: hz_party_sites d,
752: hz_locations locations
753: WHERE
754: p.site_use_id = l_inv_to_org_id
755: and a.cust_acct_site_id = p.cust_acct_site_id
756: and a.cust_account_id = b.cust_account_id

Line 1016: FROM hz_locations

1012: p_country,
1013: p_county,
1014: p_postal_code,
1015: p_state
1016: FROM hz_locations
1017: WHERE location_id = l_loc_id;
1018:
1019: exception
1020:

Line 1022: RAISE_APPLICATION_ERROR(-20033,'Address does not exist in HZ_LOCATIONS(HZ_PARTY_SITES), Please Recheck the DATA');

1018:
1019: exception
1020:
1021: WHEN NO_DATA_FOUND THEN
1022: RAISE_APPLICATION_ERROR(-20033,'Address does not exist in HZ_LOCATIONS(HZ_PARTY_SITES), Please Recheck the DATA');
1023:
1024: END;
1025:
1026: END IF;

Line 1028: IF l_loc_type_code = 'HZ_LOCATIONS' THEN

1024: END;
1025:
1026: END IF;
1027:
1028: IF l_loc_type_code = 'HZ_LOCATIONS' THEN
1029:
1030: BEGIN
1031:
1032: SELECT install_location_id

Line 1067: FROM hz_locations

1063: p_country,
1064: p_county,
1065: p_postal_code,
1066: p_state
1067: FROM hz_locations
1068: WHERE location_id = l_install_loc_id;
1069:
1070: EXCEPTION
1071:

Line 1073: RAISE_APPLICATION_ERROR(-20043,'Address does not exist in HZ_LOCATIONS, Please Recheck the DATA');

1069:
1070: EXCEPTION
1071:
1072: WHEN NO_DATA_FOUND THEN
1073: RAISE_APPLICATION_ERROR(-20043,'Address does not exist in HZ_LOCATIONS, Please Recheck the DATA');
1074:
1075: END;
1076:
1077: END IF;

Line 1128: hz_locations locations

1124: hz_cust_acct_sites_all a,
1125: hz_cust_accounts b,
1126: hz_parties c,
1127: hz_party_sites d,
1128: hz_locations locations
1129: WHERE
1130: p.site_use_id = p_ship_to_org_id
1131: and a.cust_acct_site_id = p.cust_acct_site_id
1132: and a.cust_account_id = b.cust_account_id

Line 1139: RAISE_APPLICATION_ERROR(-20043,'Address does not exist in HZ_LOCATIONS, Please Recheck the DATA');

1135: and d.location_id = locations.location_id;
1136:
1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: RAISE_APPLICATION_ERROR(-20043,'Address does not exist in HZ_LOCATIONS, Please Recheck the DATA');
1140:
1141: END return_ship_to_address;
1142:
1143: