APPS.OKL_SPLIT_ASSET_PVT dependencies on CSI_ITEM_INSTANCES

Line 4587: FROM csi_item_instances

4583:
4584: --Cursor to find existence
4585: CURSOR srl_num_csr (Srl_Number IN VARCHAR2) IS
4586: SELECT serial_number
4587: FROM csi_item_instances
4588: WHERE serial_number = Srl_Number;
4589:
4590: l_csi_srl_number csi_item_instances.serial_number%TYPE DEFAULT NULL;
4591:

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

4586: SELECT serial_number
4587: FROM csi_item_instances
4588: WHERE serial_number = Srl_Number;
4589:
4590: l_csi_srl_number csi_item_instances.serial_number%TYPE DEFAULT NULL;
4591:
4592: BEGIN
4593: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4594: l_serial_number := p_serial_number;

Line 4716: FROM csi_item_instances csi,

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,
4719: okc_k_lines_b ib_cle,
4720: okc_line_styles_b ib_lse,

Line 4750: l_location_id csi_item_instances.location_id%TYPE;

4746:
4747: l_fa_cle_id okc_k_lines_b.id%TYPE;
4748: l_ib_cle_id okc_k_lines_b.id%TYPE;
4749: l_tas_id okl_txl_assets_b.tas_id%TYPE;
4750: l_location_id csi_item_instances.location_id%TYPE;
4751: l_install_location_id csi_item_instances.install_location_id%TYPE;
4752: --BUG# 3569441
4753: l_location_type_code csi_item_instances.install_location_type_code%TYPE;
4754: l_instance_number_csi csi_item_instances.instance_number%TYPE;

Line 4751: l_install_location_id csi_item_instances.install_location_id%TYPE;

4747: l_fa_cle_id okc_k_lines_b.id%TYPE;
4748: l_ib_cle_id okc_k_lines_b.id%TYPE;
4749: l_tas_id okl_txl_assets_b.tas_id%TYPE;
4750: l_location_id csi_item_instances.location_id%TYPE;
4751: l_install_location_id csi_item_instances.install_location_id%TYPE;
4752: --BUG# 3569441
4753: l_location_type_code csi_item_instances.install_location_type_code%TYPE;
4754: l_instance_number_csi csi_item_instances.instance_number%TYPE;
4755:

Line 4753: l_location_type_code csi_item_instances.install_location_type_code%TYPE;

4749: l_tas_id okl_txl_assets_b.tas_id%TYPE;
4750: l_location_id csi_item_instances.location_id%TYPE;
4751: l_install_location_id csi_item_instances.install_location_id%TYPE;
4752: --BUG# 3569441
4753: l_location_type_code csi_item_instances.install_location_type_code%TYPE;
4754: l_instance_number_csi csi_item_instances.instance_number%TYPE;
4755:
4756: --Cursor to get install site use id
4757: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS

Line 4754: l_instance_number_csi csi_item_instances.instance_number%TYPE;

4750: l_location_id csi_item_instances.location_id%TYPE;
4751: l_install_location_id csi_item_instances.install_location_id%TYPE;
4752: --BUG# 3569441
4753: l_location_type_code csi_item_instances.install_location_type_code%TYPE;
4754: l_instance_number_csi csi_item_instances.instance_number%TYPE;
4755:
4756: --Cursor to get install site use id
4757: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
4758: SELECT TO_CHAR(Party_site_use_id) party_site_use_id

Line 5041: FROM csi_item_instances csi,

5037: --cursor to find serialized item instances in installed base
5038: CURSOR l_srl_no_count_csr(fin_ast_id IN NUMBER) IS
5039: SELECT
5040: COUNT(1)
5041: FROM csi_item_instances csi,
5042: okc_k_items ib_cim,
5043: okc_k_lines_b ib_cle,
5044: okc_line_styles_b ib_lse,
5045: okc_k_lines_b inst_cle,

Line 5286: FROM csi_item_instances csi,

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

Line 5329: FROM csi_item_instances csi,

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