APPS.AR_AME_CM_ATTRIBUTES_API SQL Statements

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

Line: 14

        SELECT rct.bill_to_customer_id
        FROM   hz_cust_accounts bill_to_cust,
               hz_parties party,
               ra_customer_trx  rct
        WHERE  rct.bill_to_customer_id = bill_to_cust.cust_account_id
        AND    bill_to_cust.party_id = party.party_id
        AND    rct.customer_trx_id =
                 (SELECT r.customer_trx_id
                  FROM   ar_lookups l, ra_cm_requests r
                  WHERE  r.request_id = p_txn_id
                  AND    r.cm_reason_code = l.lookup_code
                  AND    l.lookup_type = 'CREDIT_MEMO_REASON');

Line: 54

        SELECT r.customer_trx_id
        FROM   ar_lookups l,
               ra_cm_requests r
        WHERE  r.request_id = p_txn_id
        AND    r.cm_reason_code = l.lookup_code
        AND    l.lookup_type = 'CREDIT_MEMO_REASON';

Line: 87

        SELECT rct.bill_to_site_use_id
        FROM   hz_cust_accounts bill_to_cust,
               hz_parties party,
               ra_customer_trx  rct
        WHERE  rct.bill_to_customer_id = bill_to_cust.cust_account_id
        AND    bill_to_cust.party_id = party.party_id
        AND    rct.customer_trx_id =
                 (SELECT r.customer_trx_id
                  FROM   ar_lookups l,ra_cm_requests r
                  WHERE  r.request_id = p_txn_id
                  AND    r.cm_reason_code = l.lookup_code
                  AND    l.lookup_type = 'CREDIT_MEMO_REASON');

Line: 129

      SELECT  'person_id:' || col.employee_id, cp.site_use_id
      FROM    ar_collectors col,
              hz_customer_profiles cp
      WHERE   cp.collector_id    = col.collector_id
      AND     cp.cust_account_id = p_customer_id
      AND     (cp.site_use_id    = p_bill_to_use_id
               OR cp.site_use_id is NULL)
      ORDER by cp.site_use_id;

Line: 578

    SELECT tt.name
    FROM   ar_lookups l,
           ra_cm_requests r,
           ra_customer_trx t,
           ra_cust_trx_types tt
    WHERE  r.request_id = p_transaction_id
    AND    r.cm_reason_code = l.lookup_code
    AND    l.lookup_type = 'CREDIT_MEMO_REASON'
    AND    t.customer_trx_id = r.customer_trx_id
    AND    t.cust_trx_type_id = tt.cust_trx_type_id;

Line: 606

    SELECT interface_line_context
    FROM   ar_lookups l,
           ra_cm_requests r,
           ra_customer_trx_lines tl
    WHERE  r.request_id = p_transaction_id
    AND    r.cm_reason_code = l.lookup_code
    AND    l.lookup_type = 'CREDIT_MEMO_REASON'
    AND    tl.customer_trx_id = r.customer_trx_id
    AND    tl.interface_line_context IS NOT NULL
    AND    rownum = 1;