APPS.INV_INVTRLNT_XMLP_PKG SQL Statements

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

Line: 134

                   ,'Failed in before report trigger, item select. ')*/NULL;

Line: 142

                   ,'Failed in before report trigger, locator select. ')*/NULL;

Line: 150

                   ,'Failed in before report trigger, mkts select. ')*/NULL;

Line: 166

                   ,'Failed in before report trigger, mdsp select. ')*/NULL;

Line: 182

                   ,'Failed in before report triger, glcc select. ')*/NULL;

Line: 198

                   ,'Failed in before report trigger, catg select. ')*/NULL;

Line: 394

          RETURN ('and mtln.transaction_source_id = cupd.cost_update_id
                 	and cupd.description between ''' || P_TXN_SOURCE_LO || ''' and ''' || P_TXN_SOURCE_HI || ''' ');

Line: 398

            RETURN ('and mtln.transaction_source_id = cupd.cost_update_id
                   	and cupd.description between >= ''' || P_TXN_SOURCE_LO || ''' ');

Line: 402

              RETURN ('and mtln.transaction_source_id = cupd.cost_update_id
                     	and cupd.description <= ''' || P_TXN_SOURCE_HI || ''' ');

Line: 519

      SELECT
        TRACKING_QUANTITY_IND
      FROM
        MTL_SYSTEM_ITEMS
      WHERE INVENTORY_ITEM_ID = BREAK_ITEM_ID
        AND ORGANIZATION_ID = P_ORG;