APPS.ISC_DBI_RET_DETAIL_PKG SQL Statements

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

Line: 91

    ELSE -- a prod cat has been selected
      IF (l_prod IS NULL)
        THEN
          l_prod_cat_from := ',
		ENI_DENORM_HIERARCHIES		eni_cat,
		MTL_DEFAULT_CATEGORY_SETS	mdcs';

Line: 120

SELECT				ISC_ATTRIBUTE_1, -- Order Number
				ISC_ATTRIBUTE_2, -- Line Number
	ou.value		ISC_ATTRIBUTE_3, -- Operating Unit
				ISC_ATTRIBUTE_4, -- Booked Date
	cust.value		ISC_ATTRIBUTE_5, -- Customer
	cc.value		ISC_ATTRIBUTE_10, -- Customer Classification
	items.value		ISC_ATTRIBUTE_6, -- Item
	items.description	ISC_ATTRIBUTE_7, -- Description
	g.group_name		ISC_ATTRIBUTE_8, -- Sales Group
	r.resource_name		ISC_ATTRIBUTE_9, -- Sales Representative
				ISC_MEASURE_2, -- Booked Return Sales Credit
				ISC_MEASURE_3, -- Grand Total - Booked Return Sales Credit
				ISC_MEASURE_4 -- Header ID
  FROM	(SELECT	(rank() over (&ORDER_BY_CLAUSE, isc_attribute_1 desc, isc_attribute_2, org_ou_id))-1 RNK,
		org_ou_id, customer_id, class_code, item_id, sales_grp_id, resource_id,
		ISC_ATTRIBUTE_1, ISC_ATTRIBUTE_2, ISC_ATTRIBUTE_4,
		ISC_MEASURE_2, ISC_MEASURE_3, ISC_MEASURE_4
   	   FROM	(SELECT	mv.org_ou_id			ORG_OU_ID,
			mv.customer_id			CUSTOMER_ID,
			mv.class_code			CLASS_CODE,
			mv.item_id			ITEM_ID,
			mv.sales_grp_id			SALES_GRP_ID,
			mv.resource_id			RESOURCE_ID,
			mv.order_number			ISC_ATTRIBUTE_1,
			mv.line_number			ISC_ATTRIBUTE_2,
			mv.time_booked_date_id		ISC_ATTRIBUTE_4,
			mv.returned_amt_'||l_curr_suffix||'		ISC_MEASURE_2,
			sum(mv.returned_amt_'||l_curr_suffix||') over ()	ISC_MEASURE_3,
			mv.header_id			ISC_MEASURE_4
   	   	   FROM	ISC_DBI_SCR_003_MV		mv'
			||l_prod_cat_from||'
  		  WHERE mv.time_booked_date_id BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE
						   AND &BIS_CURRENT_ASOF_DATE'
			||l_sg_where
			||l_prod_cat_where
			||l_prod_where
			||l_cust_where
			||l_class_where||')
	)				a,
	FII_CUSTOMERS_V			cust,
	FII_PARTNER_MKT_CLASS_V		cc,
	ENI_ITEM_V			items,
	FII_OPERATING_UNITS_V		ou,
	JTF_RS_GROUPS_VL		g,
	JTF_RS_RESOURCE_EXTNS_VL	r
  WHERE	a.customer_id = cust.id
    AND a.class_code = cc.id
    AND a.item_id = items.id
    AND a.org_ou_id = ou.id
    AND	a.sales_grp_id = g.group_id
    AND	a.resource_id = r.resource_id
    AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
ORDER BY rnk';