APPS.ISC_DBI_SAM_TOP_AGR_PKG SQL Statements

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

Line: 117

select	oset.isc_attribute_1 ISC_ATTRIBUTE_1,
        ccv.value ISC_ATTRIBUTE_2,
        cust.value ISC_ATTRIBUTE_3,
        sg.group_name ISC_ATTRIBUTE_4,
        agree.value ISC_ATTRIBUTE_5,
        ISC_MEASURE_1,
        ISC_MEASURE_2,
        ISC_MEASURE_3,
        ISC_MEASURE_4,
        ISC_MEASURE_5,
        ISC_MEASURE_6,
        ISC_MEASURE_7,
        ISC_MEASURE_8,
	oset.isc_attribute_6 ISC_ATTRIBUTE_6,
	oset.isc_attribute_7 ISC_ATTRIBUTE_7,
        ''pFunctionName=OKC_REP_SALES_BSA_HEADER_VIEW&mode=view&headerId=''||oset.blanket_header_id||''&moContextOrgId=''||oset.org_id||''&addBreadCrumb=Y&retainAM=Y'' ISC_ATTRIBUTE_8
from
(
select (rank() over (&ORDER_BY_CLAUSE nulls last, isc_attribute_1))-1 rnk,
isc_attribute_1,
isc_attribute_6,
isc_attribute_7,
blanket_header_id,
org_id,
customer_id,
sales_grp_id,
agreement_type_id,
isc_measure_1,
isc_measure_2,
isc_measure_3,
isc_measure_4,
sum(isc_measure_1) over () isc_measure_5,
sum(isc_measure_2) over () isc_measure_6,
sum(isc_measure_3) over () isc_measure_7,
sum(isc_measure_4) over () isc_measure_8
from
(
select f.blanket_number ISC_ATTRIBUTE_1,
       f.time_activation_date_id ISC_ATTRIBUTE_6,
       f.time_'||l_col||'_date_id ISC_ATTRIBUTE_7,
       f.blanket_header_id,
       f.org_id,
       f.customer_id,
       f.sales_grp_id,
       f.agreement_type_id,
       sum(case when f.order_line_id is null then 0 else 1 end)  ISC_MEASURE_1,
       sum(case when (f.time_fulfilled_date_id <= &BIS_CURRENT_ASOF_DATE)
           then f.fulfilled_amt_'||l_curr_suffix||' else 0 end)  ISC_MEASURE_2,
       sum(f.commit_prorated_amt_'||l_curr_suffix||')
       - sum(case when (f.time_fulfilled_date_id <= &BIS_CURRENT_ASOF_DATE)
             then f.fulfilled_outstand_amt_'||l_curr_suffix||' else 0 end) ISC_MEASURE_3,
       sum(f.commit_prorated_amt_'||l_curr_suffix||') ISC_MEASURE_4
from isc_dbi_bsa_order_lines_f f'||l_class_from||'
where 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_time_where||l_sg_where||l_agree_where||l_class_where||l_cust_where||'
group by f.blanket_number,
       f.blanket_header_id,
       f.org_id,
       f.time_activation_date_id,
       f.time_'||l_col||'_date_id,
       f.customer_id,
       f.sales_grp_id,
       f.agreement_type_id
) ) oset,
     fii_party_mkt_class cc,
     fii_partner_mkt_class_v ccv,
     fii_customers_v cust,
     jtf_rs_groups_vl sg,
     isc_agreement_type_v agree
where oset.customer_id = cc.party_id
and cc.class_code = ccv.id
and oset.customer_id = cust.id
and oset.sales_grp_id = sg.group_id
and oset.agreement_type_id = agree.id
and((oset.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
&ORDER_BY_CLAUSE nulls last
';