APPS.OKL_QA_DATA_INTEGRITY dependencies on CSI_ITEM_INSTANCES

Line 4583: FROM csi_item_instances

4579: AND f2.sts_code <> 'ABANDONED';
4580:
4581: CURSOR srl_num_csr (p_serial_num IN VARCHAR2) IS
4582: SELECT serial_number
4583: FROM csi_item_instances
4584: WHERE serial_number = p_serial_num;
4585:
4586: l_csi_srl_number csi_item_instances.serial_number%TYPE;
4587: l_chk_rebook_chr VARCHAR2(1);

Line 4586: l_csi_srl_number csi_item_instances.serial_number%TYPE;

4582: SELECT serial_number
4583: FROM csi_item_instances
4584: WHERE serial_number = p_serial_num;
4585:
4586: l_csi_srl_number csi_item_instances.serial_number%TYPE;
4587: l_chk_rebook_chr VARCHAR2(1);
4588: l_chk_new_chr VARCHAR2(1);
4589: --Bug# 16098797
4590:

Line 4737: FROM csi_item_instances inst,

4733: p_inv_master_organization_id NUMBER, p_contract_start_date DATE) IS
4734: SELECT instance_id,
4735: install_location_id,
4736: install_location_type_code
4737: FROM csi_item_instances inst,
4738: csi_instance_statuses stat
4739: WHERE inst.serial_number like p_serial_number -- nullable col
4740: AND inst.inventory_item_id = p_inventory_item_id
4741: AND inst.inv_master_organization_id = p_inv_master_organization_id

Line 4797: l_instance_id csi_item_instances.instance_id%TYPE;

4793: WHERE h.id = p_chr_id
4794: AND mtl.organization_id = h.inv_organization_id;
4795:
4796:
4797: l_instance_id csi_item_instances.instance_id%TYPE;
4798: l_install_location_id csi_item_instances.install_location_id%TYPE;
4799: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;
4800: l_location_id hz_party_sites.location_id%TYPE;
4801: l_serial_number_control_code VARCHAR2(3);

Line 4798: l_install_location_id csi_item_instances.install_location_id%TYPE;

4794: AND mtl.organization_id = h.inv_organization_id;
4795:
4796:
4797: l_instance_id csi_item_instances.instance_id%TYPE;
4798: l_install_location_id csi_item_instances.install_location_id%TYPE;
4799: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;
4800: l_location_id hz_party_sites.location_id%TYPE;
4801: l_serial_number_control_code VARCHAR2(3);
4802: l_trx_line_type_book VARCHAR2(10);

Line 4799: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;

4795:
4796:
4797: l_instance_id csi_item_instances.instance_id%TYPE;
4798: l_install_location_id csi_item_instances.install_location_id%TYPE;
4799: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;
4800: l_location_id hz_party_sites.location_id%TYPE;
4801: l_serial_number_control_code VARCHAR2(3);
4802: l_trx_line_type_book VARCHAR2(10);
4803: l_party_site_id hz_party_site_uses.party_site_id%TYPE;