APPS.INV_INVTRSTS_XMLP_PKG SQL Statements

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

Line: 45

      SELECT
        TRANSACTION_SOURCE_TYPE_NAME
      INTO NAME
      FROM
        MTL_TXN_SOURCE_TYPES
      WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;

Line: 67

      SELECT
        TRANSACTION_SOURCE_TYPE_NAME
      INTO NAME
      FROM
        MTL_TXN_SOURCE_TYPES
      WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;

Line: 89

      SELECT
        TRANSACTION_SOURCE_TYPE_NAME
      INTO NAME
      FROM
        MTL_TXN_SOURCE_TYPES
      WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;

Line: 145

                     ,'Error in MSTK/select')*/NULL;

Line: 172

                       ,'Error in MCAT/Select')*/NULL;

Line: 219

        select mmt.subinventory_code        subinv,
               mmt.inventory_item_id        item_id,
               sum(decode(mmt.transaction_source_type_id,' || P_STYPE1 || ',
                          decode(' || TO_CHAR(P_SELECTION) || ',1,primary_quantity,2,1,
                                 decode(' || P_STYPE1 || ',11,quantity_adjusted*
                                        (new_cost-prior_cost),
                                         13,
                                         decode ( mmt.transaction_type_id, 80,
                                                quantity_adjusted*(new_cost-prior_cost),
                                                primary_quantity * actual_cost
                                               ),
                                        primary_quantity * actual_cost))
                          ,0))    source_type1,
               sum(decode(mmt.transaction_source_type_id,' || P_STYPE2 || ',
                          decode(' || TO_CHAR(P_SELECTION) || ',1,primary_quantity,2,1,
                                 decode(' || P_STYPE2 || ',11,quantity_adjusted*
                                        (new_cost-prior_cost),
                                         13,
                                         decode ( mmt.transaction_type_id, 80,
                                                quantity_adjusted*(new_cost-prior_cost),
                                                primary_quantity * actual_cost
                                               ),
                                        primary_quantity * actual_cost))
                          ,0))    source_type2,
               sum(decode(mmt.transaction_source_type_id,' || P_STYPE3 || ',
                          decode(' || TO_CHAR(P_SELECTION) || ',1,primary_quantity,2,1,
                                 decode(' || P_STYPE3 || ',11,quantity_adjusted*
                                        (new_cost-prior_cost),
                                        13,
                                        decode ( mmt.transaction_type_id, 80,
                                                quantity_adjusted*(new_cost-prior_cost),
                                                primary_quantity * actual_cost
                                               ),
                                        primary_quantity * actual_cost))
                          ,0))    source_type3,
               sum(decode(mmt.transaction_source_type_id,' || P_STYPE1 || ',0,
                          ' || P_STYPE2 || ',0,' || P_STYPE3 || ',0,' || P_STYPE4 || ',0,' || P_STYPE5 || ',0,
                          decode(' || TO_CHAR(P_SELECTION) || ',1,primary_quantity,2,1,
                                 decode(mmt.transaction_source_type_id,11,
                                        quantity_adjusted*(new_cost-prior_cost),
                                        13,
                                        decode ( mmt.transaction_type_id, 80,
                                                quantity_adjusted*(new_cost-prior_cost),
                                                primary_quantity * actual_cost
                                               ),
                                        primary_quantity * actual_cost))
                          ))       other
        from mtl_material_transactions mmt
        where mmt.organization_id = ' || TO_CHAR(P_ORG_ID) || '
        and   (transaction_date) >= nvl(to_date(''' || P_DATE_LO_1 || ''',' || '''DD-MON-YYYY HH24:MI:SS''' || '), (transaction_date))
        and   (transaction_date) <= nvl(to_date(''' || P_DATE_HI_1 || ''',' || '''DD-MON-YYYY HH24:MI:SS''' || '), (transaction_date))
        group by mmt.subinventory_code, mmt.inventory_item_id';

Line: 297

        SELECT
          CATEGORY_SET_NAME
        INTO NAME
        FROM
          MTL_CATEGORY_SETS
        WHERE CATEGORY_SET_ID = SET_ID;