APPS.ENI_DBI_TOO_PKG SQL Statements

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

Line: 16

  l_curr_select       VARCHAR2(100);

Line: 76

    l_curr_select := ' fact.SALES_CREDIT_AMT as ENI_ATTRIBUTE5, ' ;

Line: 79

    l_curr_select := ' fact.SALES_CREDIT_AMT_S as ENI_ATTRIBUTE5, ' ;

Line: 81

    l_curr_select := ' fact.SALES_CREDIT_AMT as ENI_ATTRIBUTE5, ' ;

Line: 85

  SELECT
    cust.party_name as ENI_ATTRIBUTE2,
    fact.opty_id ENI_ATTRIBUTE3,
    hdr.description as ENI_ATTRIBUTE4,
    ENI_ATTRIBUTE5,
    ENI_ATTRIBUTE6,
    ENI_ATTRIBUTE7,
    item.value as ENI_ATTRIBUTE9,
    eni.value as ENI_ATTRIBUTE8,
    nvl(r.resource_name, decode(	fact.salesrep_id, -1,
      ''Unassigned'',
    NULL))	ENI_ATTRIBUTE11,
    g.group_name	ENI_ATTRIBUTE12
  FROM
	  (SELECT
			  fact.opty_id ,
			  '||l_curr_select||'
			  fact.win_probability as ENI_ATTRIBUTE6,
			  fact.close_date as ENI_ATTRIBUTE7,
			  fact.salesrep_id,
        fact. item_id,
        fact.product_category_id,
        fact.customer_id,
        fact.sales_group_id
		  FROM  ENI_DBI_TOO_MV			fact ' ||
	          l_from || '
      WHERE   fact.SALES_CREDIT_AMT > 0 '
        || l_item_where
        || l_category_where
        || l_extra_where ||
	      ' ORDER BY ENI_ATTRIBUTE5 desc
     ) fact,
  ENI_ITEM_VBH_NODES_V		eni,
  ENI_ITEM_V			item,
  HZ_PARTIES			CUST,
  AS_LEADS_ALL HDR,
  JTF_RS_GROUPS_VL		g,
  JTF_RS_RESOURCE_EXTNS_VL	r
  WHERE   fact.item_id = item.id
  AND     fact.opty_id = hdr.lead_id
	AND     fact.product_category_id = eni.id
  AND     eni.parent_id = eni.child_id
	AND     fact.customer_id = cust.party_id
	AND     fact.sales_group_id = g.group_id
	AND     fact.salesrep_id = r.resource_id(+)
  '|| l_extra_outer_where ||'
  ORDER BY  '||l_order_by ; -- Bug : 3991419