APPS.CSI_SYSTEMS_PVT dependencies on HZ_LOCATIONS

Line 5880: ,HZ_LOCATIONS hls

5876: FROM HZ_CUST_SITE_USES_ALL hzsu
5877: ,HZ_CUST_ACCT_SITES_ALL hzca
5878: ,HZ_PARTY_SITES hps
5879: ,HZ_PARTIES hzp
5880: ,HZ_LOCATIONS hls
5881: WHERE hzsu.site_use_id = p_system_header_tbl(sys_row).ship_to_site_use_id
5882: AND hzca.cust_acct_site_id = hzsu.cust_acct_site_id
5883: AND hzca.party_site_id = hps.party_site_id
5884: AND hps.party_id = hzp.party_id

Line 5929: ,HZ_LOCATIONS hls

5925: FROM HZ_CUST_SITE_USES_ALL hzsu
5926: ,HZ_CUST_ACCT_SITES_ALL hzca
5927: ,HZ_PARTY_SITES hps
5928: ,HZ_PARTIES hzp
5929: ,HZ_LOCATIONS hls
5930: WHERE hzsu.site_use_id = p_system_header_tbl(sys_row).bill_to_site_use_id
5931: AND hzca.cust_acct_site_id = hzsu.cust_acct_site_id
5932: AND hzca.party_site_id = hps.party_site_id
5933: AND hps.party_id = hzp.party_id

Line 5976: ,HZ_LOCATIONS hls

5972: ,p_system_header_tbl(sys_row).install_location_id
5973: ,p_system_header_tbl(sys_row).install_site_number
5974: FROM HZ_PARTY_SITES hps
5975: ,HZ_PARTIES hzp
5976: ,HZ_LOCATIONS hls
5977: WHERE hps.party_site_id = p_system_header_tbl(sys_row).install_site_use_id
5978: AND hps.party_id = hzp.party_id
5979: AND hps.location_id = hls.location_id;
5980: EXCEPTION