APPS.OKE_DTS_WSH_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

    SELECT L.ID, DECODE(L.CLE_ID, NULL, 'T', 'S'), L.DNZ_CHR_ID
    FROM okc_k_lines_b L, oke_k_deliverables_b D
    WHERE L.ID = D.K_Line_ID
    AND D.Deliverable_ID = P_Deliverable_ID;

Line: 30

    SELECT C.Location_ID
    FROM okc_k_party_roles_b R, oke_cust_site_uses_v C
    WHERE R.dnz_chr_id = P_header_ID
    AND   R.Cle_ID = P_ID
    AND   R.JTOT_Object1_Code = 'OKE_BILLTO'
    AND   R.Object1_ID1 = C.ID1;

Line: 38

    SELECT Cle_ID_Ascendant, Level_Sequence
    FROM okc_ancestrys
    WHERE Cle_ID = P_ID
    ORDER BY Level_Sequence desc;

Line: 44

    SELECT C.Location_ID
    FROM okc_k_party_roles_b R, oke_cust_site_uses_v C
    WHERE R.dnz_Chr_ID = P_ID
    AND   R.Chr_ID = P_ID
    AND   R.JTOT_Object1_Code = 'OKE_BILLTO'
    AND   R.Object1_ID1 = C.ID1;