APPS.CSE_RCVTXN_PKG SQL Statements

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

Line: 44

      SELECT rt.transaction_id,
             pla.item_id,
             pda.project_id,
             rt.organization_id,
             rt.transaction_type,
             rt.destination_type_code
      FROM   rcv_transactions     rt ,
             po_lines_all         pla ,
             po_distributions_all pda
      WHERE  rt.transaction_id      = p_transaction_id
      AND    pda.po_distribution_id = rt.po_distribution_id
      AND    pla.po_line_id         = rt.po_line_id;

Line: 90

          SELECT nvl(comms_nl_trackable_flag, 'N')
          INTO   l_ib_tracked_flag
          FROM   mtl_system_items
          WHERE  inventory_item_id = rcv_txn_rec.item_id
          AND    organization_id   = rcv_txn_rec.organization_id;

Line: 143

        l_Trx_Error_Rec.error_stage   := cse_datastructures_pub.g_ib_update;