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_LOCATIONS

Line 4711: csi.location_id, --hz_locations

4707: CURSOR ib_loc_csr (p_tal_id IN NUMBER) IS
4708: SELECT txlb.kle_id fa_cle_id,
4709: ib_cle.id ib_cle_id,
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

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 4776: FROM hz_locations hl,

4772:
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:

Line 4783: FROM hz_locations hl

4779: AND ps.party_site_id = pty_site_id;
4780:
4781: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
4782: 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)
4783: FROM hz_locations hl
4784: WHERE hl.location_id = loc_id;
4785:
4786: l_address VARCHAR2(80);
4787: --END BUG# 3569441

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 4871: p_token3_value => 'HZ_LOCATIONS');

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;
4874:
4875: ELSIF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

Line 4898: ELSIF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN

4894: RAISE OKL_API.G_EXCEPTION_ERROR;
4895: END IF;
4896: CLOSE inst_site_csr;
4897:
4898: ELSIF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN
4899:
4900: --get site use id
4901: OPEN inst_loc_csr(loc_id => l_install_location_id);
4902: FETCH inst_loc_csr INTO l_party_site_use_id;

Line 5282: csi.location_id, --hz_locations

5278: csi.inv_master_organization_id,
5279: csi.unit_of_measure,
5280: csi.quantity,
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,

Line 5325: csi.location_id, --hz_locations

5321: csi.inv_master_organization_id,
5322: csi.unit_of_measure,
5323: csi.quantity,
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,

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 5377: FROM hz_locations hl,

5373: AND ps.location_id = loc_id;
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:

Line 5384: FROM hz_locations hl

5380: AND ps.party_site_id = pty_site_id;
5381:
5382: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
5383: 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)
5384: FROM hz_locations hl
5385: WHERE hl.location_id = loc_id;
5386:
5387: l_address VARCHAR2(80);
5388: --END BUG# 3569441

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 5494: p_token3_value => 'HZ_LOCATIONS');

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;
5497:
5498: ELSIF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

Line 5521: ELSIF NVL(srl_num_rec2.install_location_type_code, OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN

5517: --l_pty_site_use_id := '-1';
5518: END IF;
5519: CLOSE inst_site_csr;
5520:
5521: ELSIF NVL(srl_num_rec2.install_location_type_code, OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN
5522:
5523: OPEN inst_loc_csr(srl_num_rec2.install_location_id);
5524: FETCH inst_loc_csr INTO l_pty_site_use_id;
5525: IF inst_loc_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 5593: p_token3_value => 'HZ_LOCATIONS');

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;
5596:
5597: ELSIF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

Line 5619: ELSIF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN

5615: RAISE OKL_API.G_EXCEPTION_ERROR;
5616: END IF;
5617:
5618: CLOSE inst_site_csr;
5619: ELSIF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN
5620:
5621: OPEN inst_loc_csr(srl_num_rec.install_location_id);
5622: FETCH inst_loc_csr INTO l_pty_site_use_id;
5623: IF inst_loc_csr%NOTFOUND THEN