[Home] [Help]
APPS.OKS_ATTR_DEFAULTS_PVT dependencies on CS_INCIDENTS_ALL_B
Line 613: from cs_incidents_all_b cs , okc_k_lines_b line
609: select distinct incident_id,
610: contract_number,
611: contract_service_id,
612: incident_number
613: from cs_incidents_all_b cs , okc_k_lines_b line
614: where cs.contract_service_id = p_cle_id
615: and cs.contract_id =p_chr_id
616: and cs.contract_id =line.dnz_chr_id
617: and line.cle_id = p_cle_id