APPS.ENI_DBI_TOB_PKG SQL Statements

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

Line: 18

  l_curr_select         VARCHAR2(100);

Line: 76

    l_curr_select := ' fact.booked_amt_g		      ENI_ATTRIBUTE9, ' ;

Line: 79

    l_curr_select := ' fact.booked_amt_g1	        ENI_ATTRIBUTE9, ' ;

Line: 81

    l_curr_select := ' fact.booked_amt_g	        ENI_ATTRIBUTE9, ' ;

Line: 85

 SELECT
   CUST.VALUE ENI_ATTRIBUTE2,
   ENI_ATTRIBUTE3 ,
   ENI_ATTRIBUTE4 ,
   ENI_ATTRIBUTE9 ,
   ENI_ATTRIBUTE7 ,
   ENI_ATTRIBUTE8 ,
   item.value ENI_ATTRIBUTE6 ,
   enit.value ENI_ATTRIBUTE5 ,
   nvl(r.resource_name, decode(	fact.resource_id, -1,
   ''Unassigned'',
   NULL))			ENI_ATTRIBUTE11, -- Sales Person
   g.group_name						ENI_ATTRIBUTE12  -- Sales Group
FROM
(
  SELECT
    fact.order_number				ENI_ATTRIBUTE3, -- Order number
    fact.line_number					ENI_ATTRIBUTE4, -- Order line number
    '|| l_curr_select || '
    fact.booked_date					ENI_ATTRIBUTE7, -- Booked date
    fact.schedule_date				ENI_ATTRIBUTE8, -- Scheduled ship date
    fact.customer_id ,
    fact.sales_grp_id ,
    fact.resource_id ,
    fact.item_id ,
    fact.item_category_id
  FROM
    ENI_DBI_TOB_MV		fact ' ||
    l_from || '
  WHERE
    fact.booked_amt_g > 0	'
    || l_item_where
    || l_category_where
    || l_extra_where || '
  ORDER BY ENI_ATTRIBUTE9 desc ) fact,
  ENI_ITEM_VBH_NODES_V enit,
  ENI_ITEM_V item,
  FII_CUSTOMERS_V			cust,
  JTF_RS_GROUPS_VL		g,
  JTF_RS_RESOURCE_EXTNS_VL	r
WHERE
  fact.item_id = item.id
  AND fact.item_category_id = enit.id
  AND	enit.parent_id = enit.child_id
  AND fact.customer_id = cust.id
  AND fact.sales_grp_id = g.group_id
  AND	fact.resource_id = r.resource_id(+)
  '|| l_extra_outer_where ||'
 ORDER BY  '||l_order_by ; -- Bug : 3991419