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 CSI_ITEM_INSTANCES

Line 4559: FROM csi_item_instances

4555:
4556: --Cursor to find existence
4557: CURSOR srl_num_csr (Srl_Number IN VARCHAR2) IS
4558: SELECT serial_number
4559: FROM csi_item_instances
4560: WHERE serial_number = Srl_Number;
4561:
4562: l_csi_srl_number csi_item_instances.serial_number%TYPE DEFAULT NULL;
4563:

Line 4562: l_csi_srl_number csi_item_instances.serial_number%TYPE DEFAULT NULL;

4558: SELECT serial_number
4559: FROM csi_item_instances
4560: WHERE serial_number = Srl_Number;
4561:
4562: l_csi_srl_number csi_item_instances.serial_number%TYPE DEFAULT NULL;
4563:
4564: BEGIN
4565: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4566: l_serial_number := p_serial_number;

Line 4688: FROM csi_item_instances csi,

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,
4691: okc_k_lines_b ib_cle,
4692: okc_line_styles_b ib_lse,

Line 4722: l_location_id csi_item_instances.location_id%TYPE;

4718:
4719: l_fa_cle_id okc_k_lines_b.id%TYPE;
4720: l_ib_cle_id okc_k_lines_b.id%TYPE;
4721: l_tas_id okl_txl_assets_b.tas_id%TYPE;
4722: l_location_id csi_item_instances.location_id%TYPE;
4723: l_install_location_id csi_item_instances.install_location_id%TYPE;
4724: --BUG# 3569441
4725: l_location_type_code csi_item_instances.install_location_type_code%TYPE;
4726: l_instance_number_csi csi_item_instances.instance_number%TYPE;

Line 4723: l_install_location_id csi_item_instances.install_location_id%TYPE;

4719: l_fa_cle_id okc_k_lines_b.id%TYPE;
4720: l_ib_cle_id okc_k_lines_b.id%TYPE;
4721: l_tas_id okl_txl_assets_b.tas_id%TYPE;
4722: l_location_id csi_item_instances.location_id%TYPE;
4723: l_install_location_id csi_item_instances.install_location_id%TYPE;
4724: --BUG# 3569441
4725: l_location_type_code csi_item_instances.install_location_type_code%TYPE;
4726: l_instance_number_csi csi_item_instances.instance_number%TYPE;
4727:

Line 4725: l_location_type_code csi_item_instances.install_location_type_code%TYPE;

4721: l_tas_id okl_txl_assets_b.tas_id%TYPE;
4722: l_location_id csi_item_instances.location_id%TYPE;
4723: l_install_location_id csi_item_instances.install_location_id%TYPE;
4724: --BUG# 3569441
4725: l_location_type_code csi_item_instances.install_location_type_code%TYPE;
4726: l_instance_number_csi csi_item_instances.instance_number%TYPE;
4727:
4728: --Cursor to get install site use id
4729: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS

Line 4726: l_instance_number_csi csi_item_instances.instance_number%TYPE;

4722: l_location_id csi_item_instances.location_id%TYPE;
4723: l_install_location_id csi_item_instances.install_location_id%TYPE;
4724: --BUG# 3569441
4725: l_location_type_code csi_item_instances.install_location_type_code%TYPE;
4726: l_instance_number_csi csi_item_instances.instance_number%TYPE;
4727:
4728: --Cursor to get install site use id
4729: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
4730: SELECT TO_CHAR(Party_site_use_id) party_site_use_id

Line 5013: FROM csi_item_instances csi,

5009: --cursor to find serialized item instances in installed base
5010: CURSOR l_srl_no_count_csr(fin_ast_id IN NUMBER) IS
5011: SELECT
5012: COUNT(1)
5013: FROM csi_item_instances csi,
5014: okc_k_items ib_cim,
5015: okc_k_lines_b ib_cle,
5016: okc_line_styles_b ib_lse,
5017: okc_k_lines_b inst_cle,

Line 5258: FROM csi_item_instances csi,

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,
5262: okc_k_lines_b inst_cle,

Line 5301: FROM csi_item_instances csi,

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,
5305: okc_k_lines_b inst_cle,