APPS.ISC_DBI_BK_DETAIL_PKG SQL Statements

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

Line: 91

  ELSIF (l_prod IS NULL) -- Prod Cat selected, Product=All
    THEN l_prod_cat_from := ',
			ENI_DENORM_HIERARCHIES		eni_cat,
			MTL_DEFAULT_CATEGORY_SETS	mdcs';

Line: 103

  ELSE -- Product selected, Prod Cat selected OR All
    	 l_prod_cat_from := '';

Line: 114

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 Order Sales Credit
				ISC_MEASURE_3, -- Grand Total - Booked Order 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	f.org_ou_id			ORG_OU_ID,
			f.customer_id			CUSTOMER_ID,
			class.class_code		CLASS_CODE,
			nvl(star.master_id, star.id)	ITEM_ID,
			sc.sales_grp_id			SALES_GRP_ID,
			sc.resource_id			RESOURCE_ID,
			f.order_number			ISC_ATTRIBUTE_1,
			f.line_number			ISC_ATTRIBUTE_2,
			f.time_booked_date_id		ISC_ATTRIBUTE_4,
			f.booked_amt_'||l_curr_suffix||' * sc.sales_credit_percent / 100
							ISC_MEASURE_2,
			sum(f.booked_amt_'||l_curr_suffix||' * sc.sales_credit_percent / 100) over ()
							ISC_MEASURE_3,
			f.header_id			ISC_MEASURE_4
   	   	   FROM	ISC_BOOK_SUM2_F		f,
			ISC_SALES_CREDITS_F	sc,
			ENI_OLTP_ITEM_STAR	star,
			FII_PARTY_MKT_CLASS	class'
			||l_prod_cat_from||'
  		  WHERE f.time_booked_date_id BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE
						  AND &BIS_CURRENT_ASOF_DATE
		    AND	f.line_id = sc.line_id
		    AND f.inventory_item_id = star.inventory_item_id
		    AND f.item_inv_org_id = star.organization_id
		    AND f.customer_id = class.party_id
		    AND f.line_category_code <> ''RETURN''
		    AND f.item_type_code <> ''SERVICE''
		    AND f.order_source_id <> 27
		    AND f.order_source_id <> 10
		    AND f.ordered_quantity <> 0
		    AND f.charge_periodicity_code is NULL'
			||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';