APPS.INV_DIAG_TDUMP SQL Statements

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

Line: 19

 sqltxt    VARCHAR2(9999);  -- SQL select statement

Line: 37

JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 53

       sqltxt := 'select * from MTL_MATERIAL_TRANSACTIONS where transaction_id ='||l_txn_id;

Line: 57

       sqltxt := 'select * from MTL_MATERIAL_TRANSACTIONS where inventory_item_id ='||l_item_id||
                 ' order by transaction_id';

Line: 59

       sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;

Line: 72

       sqltxt := 'select * from mtl_material_transactions_temp where 1 = 1';

Line: 91

       sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;

Line: 96

       sqltxt := 'select * from mtl_material_transactions_temp where rownum <= '||row_limit;

Line: 102

       sqltxt := 'select * from mtl_transactions_interface where 1 = 1';

Line: 121

       sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;

Line: 124

       sqltxt := 'select * from mtl_transactions_interface where rownum <= '||row_limit;

Line: 131

       sqltxt := 'select * from MTL_UNIT_TRANSACTIONS where 1 = 1';

Line: 150

       sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;

Line: 162

       sqltxt := 'select * from MTL_TRANSACTION_LOT_NUMBERS where 1 = 1';

Line: 181

       sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;

Line: 193

       sqltxt := 'select * from MTL_SERIAL_NUMBERS_TEMP where 1 = 1';

Line: 204

       sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;

Line: 208

       sqltxt := 'select * from MTL_SERIAL_NUMBERS_TEMP  where rownum <= '||row_limit;

Line: 215

       sqltxt := 'select * from MTL_TRANSACTION_LOTS_TEMP where 1 = 1';

Line: 225

       sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;

Line: 229

       sqltxt := 'select * from MTL_SERIAL_NUMBERS_TEMP  where rownum <= '||row_limit;