DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on CSI_INSTANCE_STATUSES

Line 4738: csi_instance_statuses stat

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
4742: AND NVL (inst.active_end_date, (p_contract_start_date + 1)) > p_contract_start_date