APPS.XNB_SALES_ORDER_PVT dependencies on HZ_PARTY_SITES

Line 751: hz_party_sites d,

747: hz_cust_site_uses_all p,
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

Line 963: IF l_loc_type_code = 'HZ_PARTY_SITES' THEN

959: return;
960:
961: end;
962:
963: IF l_loc_type_code = 'HZ_PARTY_SITES' THEN
964:
965: BEGIN
966:
967: SELECT install_location_id

Line 983: from hz_party_sites

979: BEGIN
980:
981: SELECT location_id
982: into l_loc_id
983: from hz_party_sites
984: where party_site_id = l_install_loc_id;
985:
986: exception
987:

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 1127: hz_party_sites d,

1123: hz_cust_site_uses_all p,
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