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 4686: csi.install_location_type_code, --hz_party_sites, hz_locations

4682: txlb.tas_id,
4683: csi.location_id, --hz_locations
4684: csi.install_location_id,
4685: --Bug# 3569441
4686: csi.install_location_type_code, --hz_party_sites, hz_locations
4687: csi.instance_number
4688: FROM csi_item_instances csi,
4689: csi_instance_statuses csi_inst_sts,
4690: okc_k_items ib_cim,

Line 4740: hz_party_sites ps

4736: --BUG# 3569441
4737: CURSOR inst_loc_csr (loc_id IN NUMBER) IS
4738: SELECT TO_CHAR(psu.party_site_use_id) party_site_use_id
4739: FROM hz_party_site_uses psu,
4740: hz_party_sites ps
4741: WHERE psu.party_site_id = ps.party_site_id
4742: AND psu.site_use_type = 'INSTALL_AT'
4743: AND ps.location_id = loc_id;
4744:

Line 4749: hz_party_sites ps

4745: --Cursor to get address for error
4746: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
4747: 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)
4748: FROM hz_locations hl,
4749: hz_party_sites ps
4750: WHERE hl.location_id = ps.location_id
4751: AND ps.party_site_id = pty_site_id;
4752:
4753: CURSOR l_address_csr2 (loc_id IN NUMBER) IS

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

4830: END IF;
4831: CLOSE ib_loc_csr;
4832:
4833: --BUG# 3569441
4834: IF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN
4835: --RAISE ERROR
4836: OKL_API.Set_Message(p_app_name => G_APP_NAME,
4837: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
4838: p_token1 => G_LOCATION_TYPE_TOKEN,

Line 4841: p_token2_value => 'HZ_PARTY_SITES',

4837: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
4838: p_token1 => G_LOCATION_TYPE_TOKEN,
4839: p_token1_value => l_location_type_code,
4840: p_token2 => G_LOC_TYPE1_TOKEN,
4841: p_token2_value => 'HZ_PARTY_SITES',
4842: p_token3 => G_LOC_TYPE2_TOKEN,
4843: p_token3_value => 'HZ_LOCATIONS');
4844: x_return_status := OKL_API.G_RET_STS_ERROR;
4845: RAISE OKL_API.G_EXCEPTION_ERROR;

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

4843: p_token3_value => 'HZ_LOCATIONS');
4844: x_return_status := OKL_API.G_RET_STS_ERROR;
4845: RAISE OKL_API.G_EXCEPTION_ERROR;
4846:
4847: ELSIF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN
4848:
4849: --get site use id
4850: OPEN inst_site_csr(pty_site_id => l_install_location_id);
4851: FETCH inst_site_csr INTO l_party_site_use_id;

Line 5257: csi.install_location_type_code --hz_party_sites OR hz_loactions

5253: csi.instance_status_id,
5254: csi.location_id, --hz_locations
5255: csi.install_location_id,
5256: --BUG# 3569441
5257: csi.install_location_type_code --hz_party_sites OR hz_loactions
5258: FROM csi_item_instances csi,
5259: okc_k_items ib_cim,
5260: okc_k_lines_b ib_cle,
5261: okc_line_styles_b ib_lse,

Line 5300: csi.install_location_type_code --hz_party_sites OR hz_locations

5296: csi.instance_status_id,
5297: csi.location_id, --hz_locations
5298: csi.install_location_id,
5299: --BUG# 3569441
5300: csi.install_location_type_code --hz_party_sites OR hz_locations
5301: FROM csi_item_instances csi,
5302: okc_k_items ib_cim,
5303: okc_k_lines_b ib_cle,
5304: okc_line_styles_b ib_lse,

Line 5342: hz_party_sites ps

5338: --BUG# 3569441
5339: CURSOR inst_loc_csr (loc_id IN NUMBER) IS
5340: SELECT TO_CHAR(psu.party_site_use_id) party_site_use_id
5341: FROM hz_party_site_uses psu,
5342: hz_party_sites ps
5343: WHERE psu.party_site_id = ps.party_site_id
5344: AND psu.site_use_type = 'INSTALL_AT'
5345: AND ps.location_id = loc_id;
5346:

Line 5350: hz_party_sites ps

5346:
5347: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
5348: 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)
5349: FROM hz_locations hl,
5350: hz_party_sites ps
5351: WHERE hl.location_id = ps.location_id
5352: AND ps.party_site_id = pty_site_id;
5353:
5354: CURSOR l_address_csr2 (loc_id IN NUMBER) IS

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

5452:
5453: --fetch party site use id
5454: l_pty_site_use_id := NULL;
5455: --BUG# 3569441 :
5456: IF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN
5457:
5458: --Raise Error
5459: OKL_API.Set_Message(p_app_name => G_APP_NAME,
5460: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,

Line 5464: p_token2_value => 'HZ_PARTY_SITES',

5460: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
5461: p_token1 => G_LOCATION_TYPE_TOKEN,
5462: p_token1_value => srl_num_rec2.install_location_type_code,
5463: p_token2 => G_LOC_TYPE1_TOKEN,
5464: p_token2_value => 'HZ_PARTY_SITES',
5465: p_token3 => G_LOC_TYPE2_TOKEN,
5466: p_token3_value => 'HZ_LOCATIONS');
5467: x_return_status := OKL_API.G_RET_STS_ERROR;
5468: RAISE OKL_API.G_EXCEPTION_ERROR;

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

5466: p_token3_value => 'HZ_LOCATIONS');
5467: x_return_status := OKL_API.G_RET_STS_ERROR;
5468: RAISE OKL_API.G_EXCEPTION_ERROR;
5469:
5470: ELSIF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN
5471:
5472: OPEN inst_site_csr(srl_num_rec2.install_location_id);
5473: FETCH inst_site_csr INTO l_pty_site_use_id;
5474: IF inst_site_csr%NOTFOUND THEN

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

5551:
5552: --fetch party site use id
5553: l_pty_site_use_id := NULL;
5554: --BUG# 3569441
5555: IF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN
5556:
5557: --Raise Error
5558: OKL_API.Set_Message(p_app_name => G_APP_NAME,
5559: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,

Line 5563: p_token2_value => 'HZ_PARTY_SITES',

5559: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
5560: p_token1 => G_LOCATION_TYPE_TOKEN,
5561: p_token1_value => srl_num_rec.install_location_type_code,
5562: p_token2 => G_LOC_TYPE1_TOKEN,
5563: p_token2_value => 'HZ_PARTY_SITES',
5564: p_token3 => G_LOC_TYPE2_TOKEN,
5565: p_token3_value => 'HZ_LOCATIONS');
5566: x_return_status := OKL_API.G_RET_STS_ERROR;
5567: RAISE OKL_API.G_EXCEPTION_ERROR;

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

5565: p_token3_value => 'HZ_LOCATIONS');
5566: x_return_status := OKL_API.G_RET_STS_ERROR;
5567: RAISE OKL_API.G_EXCEPTION_ERROR;
5568:
5569: ELSIF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN
5570:
5571: OPEN inst_site_csr(srl_num_rec.install_location_id);
5572: FETCH inst_site_csr INTO l_pty_site_use_id;
5573: IF inst_site_csr%NOTFOUND THEN