APPS.JA_AU_COSTPROC_PKG SQL Statements

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

Line: 39

      SELECT nvl(requisition_line_id,0)
        INTO l_req_line_id
        FROM rcv_transactions
       WHERE inv_transaction_id = x_transaction_id
         AND transaction_type = 'RECEIVE'
         AND organization_id = x_org_id;

Line: 72

      SELECT code_combination_id
        INTO l_ccid
        FROM po_req_distributions_all
       WHERE requisition_line_id = l_req_line_id;

Line: 88

   /* Update reference_account field in mtl_transaction_accounts */

    IF l_req_line_id <> 0 THEN
     UPDATE mtl_transaction_accounts
        SET reference_account = l_ccid
      WHERE transaction_id = x_transaction_id
        AND accounting_line_type = 2 ;