APPS.CSTPACHK SQL Statements

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

Line: 131

  SELECT transaction_type_id,
         transaction_action_id,
         transaction_source_type_id,
         inventory_item_id,
         /* BUG#5970447 FP of 5839922 */
         /* BUG#7149071 fix: regression from bug 5970447
            for regular transactions, cost group to be obtained from
            cost_group_id, for project related transactions, cost group to be
            obtained from the logic of i_debit_credit flag either from
            current txn cost_group_id or transfer cost group id
         */
         DECODE(transaction_type_id, 67,
         decode(i_debit_credit, -1, nvl(cost_group_id, -1), 1,
                nvl(transfer_cost_group_id, nvl(cost_group_id, -1))),
         66,decode(i_debit_credit, -1, nvl(cost_group_id, -1), 1,
                nvl(transfer_cost_group_id, nvl(cost_group_id, -1))),
         68,decode(i_debit_credit, -1, nvl(cost_group_id, -1), 1,
                nvl(transfer_cost_group_id, nvl(cost_group_id, -1))),
         nvl(cost_group_id, -1))
  INTO   l_txn_type_id,
         l_txn_act_id,
         l_txn_src_type_id,
         l_item_id,
         l_cg_id
  FROM   MTL_MATERIAL_TRANSACTIONS
  WHERE  transaction_id = I_TXN_ID;