APPS.CSTPLPOP SQL Statements

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

Line: 11

      SELECT /*+ INDEX (mmt3 MTL_MATERIAL_TRANSACTIONS_N1) */
      Max(Trunc(transaction_date)) transaction_date
      INTO
      max_transaction_date_tmp
      FROM
      mtl_material_transactions mmt3
      WHERE
      mmt3.organization_id = l_org_id AND
      mmt3.inventory_item_id = l_item_id AND
      EXISTS(SELECT /*+ INDEX(mmt MTL_MATERIAL_TRANSACTIONS_U2)*/1 FROM Mtl_material_transactions mmt WHERE
      mmt.transaction_source_type_id = 1 AND
      --Added for Bug # 6819625 for MTL_MATERIAL_TRANSACTIONS_N15 index usage
      mmt.transaction_action_id = 27 AND
      mmt.transaction_type_id = 18
      AND mmt.transaction_id=mmt3.transaction_id);

Line: 33

      SELECT /*+ INDEX_JOIN (mmt2 MTL_MATERIAL_TRANSACTIONS_N1 MTL_MATERIAL_TRANSACTIONS_N15) */
      To_number(Substr(MAX(To_char(mmt2.creation_date,
      'YYYY-MM-DD-HH24-MI-SS:') ||
      To_char(mmt2.transaction_id)), 21))
      INTO
      transaction_id_tmp
      FROM
      mtl_material_transactions mmt2
      WHERE
      mmt2.organization_id = l_org_id AND
      mmt2.inventory_item_id = l_item_id AND
      mmt2.transaction_type_id = 18 AND
      --Added for Bug # 6819625 for MTL_MATERIAL_TRANSACTIONS_N15 index usage
      mmt2.transaction_action_id = 27 AND
      mmt2.transaction_source_type_id = 1 AND
      mmt2.transaction_date BETWEEN max_transaction_date_tmp
      AND max_transaction_date_tmp + 1;

Line: 51

      SELECT
      mmt.transaction_cost
      INTO
      po_price_tmp
      FROM
      mtl_material_transactions mmt
      WHERE
      mmt.transaction_id = transaction_id_tmp;