[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pr.jtot_object1_code Object_Code
, pr.object1_id1 ID1
, pr.code
, pr.facility
FROM okc_k_party_roles_b pr
, oke_k_deliverables_b kd
, ( select cle_id , cle_id_ascendant , level_sequence
from okc_ancestrys
union all
select id , id , 99999 from okc_k_lines_b ) a
WHERE kd.deliverable_id = C_Deliverable_ID
AND pr.rle_code = C_Role_Code
AND pr.dnz_chr_id = kd.k_header_id
AND a.cle_id = kd.k_line_id
AND ( ( pr.cle_id IS NULL AND a.cle_id = a.cle_id_ascendant )
OR pr.cle_id = a.cle_id_ascendant )
ORDER BY DECODE(pr.cle_id , null , 0 , a.level_sequence) DESC;
SELECT kt.term_value_pk1 Code
, OKE_UTILS.Get_Term_Values
( kt.term_code , kt.term_value_pk1
, kt.term_value_pk2 , 'MEANING' ) Name
FROM oke_k_terms kt
, oke_k_deliverables_b kd
, ( select cle_id , cle_id_ascendant , level_sequence
from okc_ancestrys
union all
select id , id , 99999 from okc_k_lines_b ) a
WHERE kd.deliverable_id = C_Deliverable_ID
AND kt.term_code = C_Term_Code
AND kt.k_header_id = kd.k_header_id
AND a.cle_id = kd.k_line_id
AND ( ( kt.k_line_id IS NULL AND a.cle_id = a.cle_id_ascendant )
OR kt.k_line_id = a.cle_id_ascendant )
ORDER BY DECODE(kt.k_line_id , null , 0 , a.level_sequence) DESC;
SELECT Rtrim(Ltrim(H.Contract_Number, ' '), ' ') K_Number
, Rtrim(Ltrim(L.Line_Number, ' '), ' ') L_Number
, Rtrim(Ltrim(D.Deliverable_Num, ' '), ' ') D_Number
FROM okc_k_headers_all_b H
, okc_k_lines_b L
, oke_k_deliverables_b D
WHERE D.Deliverable_ID = P_Deliverable_ID
AND L.ID = D.K_Line_ID
AND H.ID = D.K_Header_ID;
SELECT Rtrim(Ltrim(H.Deliverable_Number, ' '), ' ') D_Number
, Rtrim(Ltrim(L.Action_Name, ' '), ' ') A_Number
FROM oke_deliverables_b H
, oke_deliverable_actions L
WHERE H.Deliverable_ID = P_Deliverable_ID
AND H.Deliverable_ID = L.Deliverable_ID
AND L.Action_Type = 'WSH'
AND L.Reference2 > 0;