APPS.OKC_PO_QA_PVT SQL Statements

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

Line: 115

    SELECT  oklb.item_to_price_yn item_priced,
            oklb.price_level_ind priced,
            oklb.price_negotiated net_price
      FROM OKC_K_LINES_b oklb
     WHERE oklb.dnz_chr_id = p_chr_id
     AND    oklb.cle_id IS NULL;

Line: 125

    SELECT oki.number_of_items qty,
           oki.uom_code UOM_CODE
      FROM OKC_K_LINES_b oklb,
           OKC_K_ITEMS oki
     WHERE oklb.dnz_chr_id = oki.dnz_chr_id
     AND oklb.cle_id IS NULL
     AND   oklb.dnz_chr_id = p_chr_id;

Line: 167

SELECT buy_or_sell
INTO   lcontract_intent
FROM OKC_K_HEADERS_b okhb
WHERE okhb.id = p_chr_id;

Line: 186

        SELECT 1 /*+ FIRST_ROWS */
        INTO l_nlines
        FROM OKC_K_LINES_B oklb
        WHERE oklb.dnz_chr_id = p_chr_id
        and rownum<2;

Line: 276

        SELECT  1 /*+ FIRST_ROWS */
        INTO    lshipping_gr_count
        FROM    okc_rule_groups_b    rgp
        WHERE   rgp.dnz_chr_id         = p_chr_id
        AND     rgp.cle_id IS NULL
        AND     (rgp.rgd_code = g_rg_shipping)
        and rownum<2;

Line: 300

        SELECT  '1' /*+ FIRST_ROWS */
        INTO    lpayment_gr_count
        FROM    okc_rule_groups_b    rgp
        WHERE   rgp.dnz_chr_id         = p_chr_id
        AND     rgp.cle_id IS NULL
        AND     (rgp.rgd_code = g_rg_payment)
        and     rownum < 2;

Line: 327

        SELECT count(*)
        INTO   lno_of_vendors
        FROM    okc_k_party_roles_b cpr
        WHERE   cpr.rle_code          = 'VENDOR'
        AND cpr.cle_id              IS NULL              -- header level vendors only
        AND cpr.dnz_chr_id        = p_chr_id;

Line: 346

        SELECT count(*)
        INTO   lno_of_customers
        FROM okc_k_party_roles_b cpr
        WHERE   cpr.rle_code          = 'CUSTOMER'
        AND cpr.cle_id              IS NULL              -- header level customers only
        AND cpr.dnz_chr_id        = p_chr_id;

Line: 368

        SELECT 1 /*+ FIRST_ROWS */
        INTO   lbuyer_contact
        FROM   okc_contacts okcc,
               okc_k_party_roles_b okpr
        WHERE okcc.dnz_chr_id = okpr.dnz_chr_id
        AND   okcc.cro_code = 'BUYER'
        AND   okpr.rle_code = 'CUSTOMER'
        AND   okcc.dnz_chr_id = p_chr_id
        AND   rownum<2;