APPS.OKL_QA_DATA_INTEGRITY dependencies on CSI_ITEM_INSTANCES

Line 4350: FROM csi_item_instances inst,

4346: p_inv_master_organization_id NUMBER, p_contract_start_date DATE) IS
4347: SELECT instance_id,
4348: install_location_id,
4349: install_location_type_code
4350: FROM csi_item_instances inst,
4351: csi_instance_statuses stat
4352: WHERE inst.serial_number like p_serial_number -- nullable col
4353: AND inst.inventory_item_id = p_inventory_item_id
4354: AND inst.inv_master_organization_id = p_inv_master_organization_id

Line 4410: l_instance_id csi_item_instances.instance_id%TYPE;

4406: WHERE h.id = p_chr_id
4407: AND mtl.organization_id = h.inv_organization_id;
4408:
4409:
4410: l_instance_id csi_item_instances.instance_id%TYPE;
4411: l_install_location_id csi_item_instances.install_location_id%TYPE;
4412: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;
4413: l_location_id hz_party_sites.location_id%TYPE;
4414: l_serial_number_control_code VARCHAR2(3);

Line 4411: l_install_location_id csi_item_instances.install_location_id%TYPE;

4407: AND mtl.organization_id = h.inv_organization_id;
4408:
4409:
4410: l_instance_id csi_item_instances.instance_id%TYPE;
4411: l_install_location_id csi_item_instances.install_location_id%TYPE;
4412: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;
4413: l_location_id hz_party_sites.location_id%TYPE;
4414: l_serial_number_control_code VARCHAR2(3);
4415: l_trx_line_type_book VARCHAR2(10);

Line 4412: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;

4408:
4409:
4410: l_instance_id csi_item_instances.instance_id%TYPE;
4411: l_install_location_id csi_item_instances.install_location_id%TYPE;
4412: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;
4413: l_location_id hz_party_sites.location_id%TYPE;
4414: l_serial_number_control_code VARCHAR2(3);
4415: l_trx_line_type_book VARCHAR2(10);
4416: l_party_site_id hz_party_site_uses.party_site_id%TYPE;