eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SPLIT_ASSET_PVT dependencies on HZ_PARTY_SITES

Line 4714: csi.install_location_type_code, --hz_party_sites, hz_locations

4710: txlb.tas_id,
4711: csi.location_id, --hz_locations
4712: csi.install_location_id,
4713: --Bug# 3569441
4714: csi.install_location_type_code, --hz_party_sites, hz_locations
4715: csi.instance_number
4716: FROM csi_item_instances csi,
4717: csi_instance_statuses csi_inst_sts,
4718: okc_k_items ib_cim,

Line 4768: hz_party_sites ps

4764: --BUG# 3569441
4765: CURSOR inst_loc_csr (loc_id IN NUMBER) IS
4766: SELECT TO_CHAR(psu.party_site_use_id) party_site_use_id
4767: FROM hz_party_site_uses psu,
4768: hz_party_sites ps
4769: WHERE psu.party_site_id = ps.party_site_id
4770: AND psu.site_use_type = 'INSTALL_AT'
4771: AND ps.location_id = loc_id;
4772:

Line 4777: hz_party_sites ps

4773: --Cursor to get address for error
4774: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
4775: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
4776: FROM hz_locations hl,
4777: hz_party_sites ps
4778: WHERE hl.location_id = ps.location_id
4779: AND ps.party_site_id = pty_site_id;
4780:
4781: CURSOR l_address_csr2 (loc_id IN NUMBER) IS

Line 4862: IF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN

4858: END IF;
4859: CLOSE ib_loc_csr;
4860:
4861: --BUG# 3569441
4862: IF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN
4863: --RAISE ERROR
4864: OKL_API.Set_Message(p_app_name => G_APP_NAME,
4865: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
4866: p_token1 => G_LOCATION_TYPE_TOKEN,

Line 4869: p_token2_value => 'HZ_PARTY_SITES',

4865: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
4866: p_token1 => G_LOCATION_TYPE_TOKEN,
4867: p_token1_value => l_location_type_code,
4868: p_token2 => G_LOC_TYPE1_TOKEN,
4869: p_token2_value => 'HZ_PARTY_SITES',
4870: p_token3 => G_LOC_TYPE2_TOKEN,
4871: p_token3_value => 'HZ_LOCATIONS');
4872: x_return_status := OKL_API.G_RET_STS_ERROR;
4873: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 4875: ELSIF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

4871: p_token3_value => 'HZ_LOCATIONS');
4872: x_return_status := OKL_API.G_RET_STS_ERROR;
4873: RAISE OKL_API.G_EXCEPTION_ERROR;
4874:
4875: ELSIF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN
4876:
4877: --get site use id
4878: OPEN inst_site_csr(pty_site_id => l_install_location_id);
4879: FETCH inst_site_csr INTO l_party_site_use_id;

Line 5285: csi.install_location_type_code --hz_party_sites OR hz_loactions

5281: csi.instance_status_id,
5282: csi.location_id, --hz_locations
5283: csi.install_location_id,
5284: --BUG# 3569441
5285: csi.install_location_type_code --hz_party_sites OR hz_loactions
5286: FROM csi_item_instances csi,
5287: okc_k_items ib_cim,
5288: okc_k_lines_b ib_cle,
5289: okc_line_styles_b ib_lse,

Line 5328: csi.install_location_type_code --hz_party_sites OR hz_locations

5324: csi.instance_status_id,
5325: csi.location_id, --hz_locations
5326: csi.install_location_id,
5327: --BUG# 3569441
5328: csi.install_location_type_code --hz_party_sites OR hz_locations
5329: FROM csi_item_instances csi,
5330: okc_k_items ib_cim,
5331: okc_k_lines_b ib_cle,
5332: okc_line_styles_b ib_lse,

Line 5370: hz_party_sites ps

5366: --BUG# 3569441
5367: CURSOR inst_loc_csr (loc_id IN NUMBER) IS
5368: SELECT TO_CHAR(psu.party_site_use_id) party_site_use_id
5369: FROM hz_party_site_uses psu,
5370: hz_party_sites ps
5371: WHERE psu.party_site_id = ps.party_site_id
5372: AND psu.site_use_type = 'INSTALL_AT'
5373: AND ps.location_id = loc_id;
5374:

Line 5378: hz_party_sites ps

5374:
5375: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
5376: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
5377: FROM hz_locations hl,
5378: hz_party_sites ps
5379: WHERE hl.location_id = ps.location_id
5380: AND ps.party_site_id = pty_site_id;
5381:
5382: CURSOR l_address_csr2 (loc_id IN NUMBER) IS

Line 5484: IF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN

5480:
5481: --fetch party site use id
5482: l_pty_site_use_id := NULL;
5483: --BUG# 3569441 :
5484: IF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN
5485:
5486: --Raise Error
5487: OKL_API.Set_Message(p_app_name => G_APP_NAME,
5488: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,

Line 5492: p_token2_value => 'HZ_PARTY_SITES',

5488: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
5489: p_token1 => G_LOCATION_TYPE_TOKEN,
5490: p_token1_value => srl_num_rec2.install_location_type_code,
5491: p_token2 => G_LOC_TYPE1_TOKEN,
5492: p_token2_value => 'HZ_PARTY_SITES',
5493: p_token3 => G_LOC_TYPE2_TOKEN,
5494: p_token3_value => 'HZ_LOCATIONS');
5495: x_return_status := OKL_API.G_RET_STS_ERROR;
5496: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 5498: ELSIF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

5494: p_token3_value => 'HZ_LOCATIONS');
5495: x_return_status := OKL_API.G_RET_STS_ERROR;
5496: RAISE OKL_API.G_EXCEPTION_ERROR;
5497:
5498: ELSIF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN
5499:
5500: OPEN inst_site_csr(srl_num_rec2.install_location_id);
5501: FETCH inst_site_csr INTO l_pty_site_use_id;
5502: IF inst_site_csr%NOTFOUND THEN

Line 5583: IF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN

5579:
5580: --fetch party site use id
5581: l_pty_site_use_id := NULL;
5582: --BUG# 3569441
5583: IF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN
5584:
5585: --Raise Error
5586: OKL_API.Set_Message(p_app_name => G_APP_NAME,
5587: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,

Line 5591: p_token2_value => 'HZ_PARTY_SITES',

5587: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
5588: p_token1 => G_LOCATION_TYPE_TOKEN,
5589: p_token1_value => srl_num_rec.install_location_type_code,
5590: p_token2 => G_LOC_TYPE1_TOKEN,
5591: p_token2_value => 'HZ_PARTY_SITES',
5592: p_token3 => G_LOC_TYPE2_TOKEN,
5593: p_token3_value => 'HZ_LOCATIONS');
5594: x_return_status := OKL_API.G_RET_STS_ERROR;
5595: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 5597: ELSIF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

5593: p_token3_value => 'HZ_LOCATIONS');
5594: x_return_status := OKL_API.G_RET_STS_ERROR;
5595: RAISE OKL_API.G_EXCEPTION_ERROR;
5596:
5597: ELSIF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN
5598:
5599: OPEN inst_site_csr(srl_num_rec.install_location_id);
5600: FETCH inst_site_csr INTO l_pty_site_use_id;
5601: IF inst_site_csr%NOTFOUND THEN