APPS.ISC_DBI_SAM_AGR_ORD_DTL_PKG SQL Statements

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

Line: 112

select oset.isc_attribute_1   ISC_ATTRIBUTE_1,
        oset.isc_attribute_2   ISC_ATTRIBUTE_2,
        oset.isc_attribute_3  ISC_ATTRIBUTE_3,
        oset.isc_attribute_4   ISC_ATTRIBUTE_4,
        cust.value    ISC_ATTRIBUTE_5,
        ccv.value    ISC_ATTRIBUTE_6,
        item.value   ISC_ATTRIBUTE_7,
        item.description   ISC_ATTRIBUTE_8,
        sg.group_name   ISC_ATTRIBUTE_9,
        sr.resource_name   ISC_ATTRIBUTE_10,
        oset.isc_measure_1   ISC_MEASURE_1,
        oset.isc_measure_2  ISC_MEASURE_2,
        oset.isc_attribute_11 ISC_ATTRIBUTE_11,
        ''pFunctionName=OKC_REP_SALES_BSA_HEADER_VIEW&mode=view&headerId=''||oset.blanket_header_id||''&moContextOrgId=''||oset.org_id||''&addBreadCrumb=Y&retainAM=Y'' ISC_ATTRIBUTE_12
from
(select (rank() over (&ORDER_BY_CLAUSE nulls last, isc_attribute_1, isc_attribute_2))-1 rnk,
blanket_header_id, org_id, customer_id, item_id, sales_grp_id, resource_id,
isc_attribute_1,isc_attribute_2,isc_attribute_3,isc_attribute_4,isc_measure_1,isc_measure_2,
isc_attribute_11
from
(select f.order_number isc_attribute_1,
        f.line_number isc_attribute_2,
        f.blanket_number isc_attribute_3,
        f.time_fulfilled_date_id isc_attribute_4,
        f.order_line_header_id isc_attribute_11,
	f.blanket_header_id,
	f.org_id,
        f.customer_id,
        star.id item_id,
        sc.sales_grp_id,
        sc.resource_id,
        f.fulfilled_amt_'||l_curr_suffix||' * sc.sales_credit_percent / 100 isc_measure_1,
        sum(f.fulfilled_amt_'||l_curr_suffix||' * sc.sales_credit_percent / 100)over() isc_measure_2
from isc_dbi_bsa_order_lines_f f,
     isc_sales_credits_f sc,
     eni_oltp_item_star star'||l_prod_cat_from||l_class_from||'
where f.time_fulfilled_date_id between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE
and f.order_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.transaction_phase_code = ''F''
and f.commit_prorated_amt_g is not null
and f.blanket_line_id is not null
and nvl(f.time_termination_date_id, f.time_activation_date_id + 1) >= f.time_activation_date_id
'||l_sg_where||l_class_where||l_cust_where||l_prod_cat_where||l_item_where||'
) )oset,
     fii_party_mkt_class cc,
     fii_partner_mkt_class_v ccv,
     fii_customers_v cust,
     eni_item_org_v item,
     jtf_rs_groups_vl sg,
     jtf_rs_resource_extns_vl  sr
where oset.customer_id = cc.party_id
and cc.class_code = ccv.id
and oset.customer_id = cust.id
and oset.item_id = item.id
and oset.sales_grp_id = sg.group_id
and oset.resource_id = sr.resource_id
and((oset.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
&ORDER_BY_CLAUSE nulls last
';