APPS.ISC_DBI_BOOK_DETAIL_PKG SQL Statements

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

Line: 64

			  (SELECT 1
			     FROM org_access o
			    WHERE o.responsibility_id = fnd_global.resp_id
			      AND o.resp_application_id = fnd_global.resp_appl_id
			      AND o.organization_id = fact.item_inv_org_id)
			OR EXISTS
			    (SELECT 1
			       FROM mtl_parameters org
			      WHERE org.organization_id = fact.item_inv_org_id
				AND NOT EXISTS
				 (SELECT 1
				    FROM org_access ora
				   WHERE org.organization_id = ora.organization_id)))';

Line: 86

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

Line: 101

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

Line: 124

 SELECT 			ISC_ATTRIBUTE_1, -- Order Number
				ISC_ATTRIBUTE_2, -- Line Number
	org.name		ISC_ATTRIBUTE_3, -- Organization
				ISC_ATTRIBUTE_4, -- Booked Date
	cust.value		ISC_ATTRIBUTE_5, -- Customer
	items.value		ISC_ATTRIBUTE_6, -- Item
	items.description	ISC_ATTRIBUTE_7, -- Description
	mtl.unit_of_measure	ISC_ATTRIBUTE_8, -- UOM
				ISC_MEASURE_1, -- Booked Quantity
				ISC_MEASURE_2, -- Booked Value
				ISC_MEASURE_3, -- Grand Total - Booked Value
				ISC_MEASURE_4 -- Header ID
   FROM	(SELECT	(rank() over (&ORDER_BY_CLAUSE, isc_measure_4, isc_attribute_2))-1 RNK,
		customer_id, inv_org_id, item_id, uom,
		ISC_ATTRIBUTE_1, ISC_ATTRIBUTE_2, ISC_ATTRIBUTE_4,
		ISC_MEASURE_1, ISC_MEASURE_2, ISC_MEASURE_3, ISC_MEASURE_4
   	   FROM	(SELECT	fact.customer_id					CUSTOMER_ID,
			fact.item_inv_org_id					INV_ORG_ID,
			fact.inventory_item_id||''-''||fact.item_inv_org_id	ITEM_ID,
			fact.inv_uom_code					UOM,
			fact.order_number					ISC_ATTRIBUTE_1,
			fact.line_number					ISC_ATTRIBUTE_2,
			fact.time_booked_date_id				ISC_ATTRIBUTE_4,
			fact.booked_qty_inv					ISC_MEASURE_1,
			fact.booked_amt_'||l_curr_suffix||'					ISC_MEASURE_2,
			sum(fact.booked_amt_'||l_curr_suffix||') over ()				ISC_MEASURE_3,
			fact.header_id						ISC_MEASURE_4
   	   	   FROM	ISC_BOOK_SUM2_F			fact'||l_prod_cat_from||'
  		  WHERE fact.time_booked_date_id BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE
						     AND &BIS_CURRENT_ASOF_DATE
		    AND	fact.line_category_code <> ''RETURN''
	  	    AND fact.item_type_code <> ''SERVICE''
		    AND	fact.order_source_id <> 10
		    AND fact.order_source_id <> 27
		    AND	fact.ordered_quantity <> 0
		    AND	fact.unit_selling_price <> 0
		    AND fact.charge_periodicity_code is NULL'
			||l_org_where
			||l_prod_cat_where
			||l_prod_where
			||l_cust_where||')
	)				a,
	FII_CUSTOMERS_V			cust,
	ENI_ITEM_ORG_V			items,
	HR_ALL_ORGANIZATION_UNITS_TL	org,
	MTL_UNITS_OF_MEASURE_TL		mtl
  WHERE	a.customer_id = cust.id
    AND a.item_id = items.id
    AND a.inv_org_id = org.organization_id
    AND org.language = :ISC_LANG
    AND a.uom = mtl.uom_code
    AND mtl.language = :ISC_LANG
    AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
ORDER BY rnk';