APPS.INV_DIAG_SO_MSO_MCH SQL Statements

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

Line: 38

   JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 73

   sqltxt := ' select FND_PROFILE.value(''OE_SOURCE_CODE'') "OE_SOURCE_CODE" from dual ';

Line: 77

   sqltxt := ' select segment1 "Segment 1",segment2 "Segment 2",segment3 "Segment 3",sales_order_id  "Sales Order Id"' ||
              ' from mtl_sales_orders ' ||
              ' where segment1=' || '''' || l_order_number || '''';

Line: 83

   sqltxt := ' SELECT order_number,' ||
              ' NAME || ''(''  || order_type_id || '')'' "Order Type (ID)",  ' ||
	      ' FND_PROFILE.VALUE(''ONT_SOURCE_CODE'') "Order Source"' ||
              ' FROM oe_order_headers oeh,OE_TRANSACTION_TYPES_TL OTT' ||
              ' WHERE order_number = ' || l_order_number ||
              ' AND ott.TRANSACTION_TYPE_ID = oeh.order_type_id' ||
              ' AND language = (select language_code from' ||
              ' fnd_languages' ||
              ' where installed_flag = ''B'') ';