APPS.QLTSMENB SQL Statements

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

Line: 41

	select DATATYPE, FK_LOOKUP_TYPE, FK_TABLE_NAME, FK_TABLE_SHORT_NAME,
               PK_ID, PK_ID2, PK_ID3, FK_ID, FK_ID2, FK_ID3, FK_MEANING,
	       FK_ADD_WHERE
        from   qa_chars
        where  char_id = x_char_id;

Line: 71

        'select order_number from (' ||
	   'select to_number(segment1) order_number from mtl_sales_orders ' ||
	   'where sales_order_id=' || x_value || ' union all '||
	   'select order_number from oe_order_headers '||
	   'where header_id=' || x_value || ')' ||
        'where rownum = 1';

Line: 79

	v_sql_statement := 'SELECT ' || V_FK_TABLE_SHORT_NAME || '.' ||
                            V_FK_MEANING || ' FROM  ' ||
			    V_FK_TABLE_NAME || ' ' || V_FK_TABLE_SHORT_NAME ||
			    ' WHERE ' || x_value || ' = ' ||
			    V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID;