APPS.IEX_METRIC_CONCUR_PVT SQL Statements

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

Line: 26

    SELECT distinct p.party_id
    FROM hz_parties p, hz_cust_accounts ca
    WHERE p.status = 'A'
    AND ca.status = 'A'
    AND ca.party_id = p.party_id
    --Begin Bug 7477844 24-Dec-2008 barathsr
    AND EXISTS ( select 1 from IEX_DELINQUENCIES_ALL del
		where del.party_cust_id= p.party_id
		and del.status in ('DELINQUENT', 'PREDELINQUENT'));

Line: 38

    SELECT ca.cust_account_id, p.party_id
    FROM hz_parties p, hz_cust_accounts ca
    WHERE p.status = 'A'
    AND ca.status = 'A'
    AND ca.party_id = p.party_id
    --Begin Bug 7477844 24-Dec-2008 barathsr
    AND EXISTS ( select 1 from IEX_DELINQUENCIES_ALL del
		where del.cust_account_id= ca.cust_account_id
		and del.status in ('DELINQUENT', 'PREDELINQUENT'));

Line: 50

    SELECT site_uses.site_use_id site_use_id, ca.cust_account_id cust_account_id, p.party_id,
    acct_site.org_id
    FROM hz_cust_accounts ca, hz_parties p,
         hz_cust_acct_sites acct_site,hz_cust_site_uses site_uses
    WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
    AND acct_site.cust_account_id = ca.cust_account_id
    AND ca.party_id = p.party_id
    AND p.status = 'A'
    AND ca.status = 'A'
    AND acct_site.status = 'A'
    AND site_uses.status = 'A'
    --Begin Bug 7477844 24-Dec-2008 barathsr
    AND EXISTS ( select 1 from IEX_DELINQUENCIES_ALL del
		where del.customer_site_use_id= site_uses.site_use_id
		and del.status in ('DELINQUENT', 'PREDELINQUENT'));

Line: 68

    SELECT delinquency_id, customer_site_use_id, cust_account_id, party_cust_id,org_id
    FROM iex_delinquencies
    WHERE status IN ('DELINQUENT', 'PREDELINQUENT');

Line: 75

    SELECT organization_id from hr_operating_units where
      mo_global.check_access(organization_id) = 'Y'
      AND organization_id = nvl(P_ORG_ID,organization_id);

Line: 83

    select count(1)
    from iex_score_comp_types_vl
    where metric_flag='Y'
    and jtf_object_code=l_jtf_object_code
    and active_flag='Y';

Line: 96

    SELECT count(1)
    FROM iex_metric_summaries;

Line: 101

    SELECT count(1)
    FROM iex_metric_summaries_all
    WHERE object_type in ('PARTY','ACCOUNT');

Line: 108

  l_del_sql          VARCHAR2(4000) := 'DELETE FROM iex_metric_summaries';

Line: 110

  l_del_cust_acct    VARCHAR2(4000) := 'DELETE FROM iex_metric_summaries_all';

Line: 273

          INSERT INTO iex_metric_summaries_all
	  (object_id, object_type, org_id, score_comp_type_id, metric_value,
	  creation_date, created_by, last_update_date, last_updated_by,
	  last_update_login, metric_rating)
          VALUES(l_party_id_tbl(idx1), 'PARTY',
	  --l_org_id, Moac Changes. Insert the Org_id from current set.
	  --I_ORG.organization_id, -- comment added for bug  16516837 SNUTHALA  22/mar/2013
    --P_ORG_ID,
          NULL, --Don't store org_id value at customer and account level for bug 16575665 gnramasa 3rd Apr 2013
	  l_metric_id_tbl(idx2), l_metric_value_tbl(idx2), SYSDATE, G_USER_ID,
	  SYSDATE, G_USER_ID, G_LOGIN_ID, l_metric_rating_tbl(idx2));

Line: 317

     l_party_id_tbl.DELETE;

Line: 347

          INSERT INTO iex_metric_summaries_all(object_id, object_type,
	  org_id, score_comp_type_id, metric_value, creation_date,
	  created_by, last_update_date, last_updated_by,
	  last_update_login, metric_rating)
          VALUES(l_cust_account_id_tbl(idx1), 'ACCOUNT',
	  --l_org_id, Moac Changes. Insert Org_id from current set.
	  --I_ORG.organization_id,  -- comment added for bug  16516837 SNUTHALA  22/mar/2013
    --P_ORG_ID,
          NULL, --Don't store org_id value at customer and account level for bug 16575665 gnramasa 3rd Apr 2013
	  l_metric_id_tbl(idx2),
	  l_metric_value_tbl(idx2), SYSDATE, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID,
	  l_metric_rating_tbl(idx2));

Line: 383

    l_cust_account_id_tbl.DELETE;

Line: 384

    l_party_id_tbl.DELETE;

Line: 419

          INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,
	  score_comp_type_id, metric_value, creation_date, created_by, last_update_date,
	  last_updated_by,last_update_login, metric_rating)
          VALUES(l_site_use_id_tbl(idx1), 'BILL_TO',
	  --l_org_id,  Moac Changes. Insert Org_id from cursor.
	  l_org_id_tbl(idx1),
	  l_metric_id_tbl(idx2), l_metric_value_tbl(idx2), SYSDATE,
	  G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID, l_metric_rating_tbl(idx2));

Line: 441

    l_site_use_id_tbl.DELETE;

Line: 442

    l_cust_account_id_tbl.DELETE;

Line: 443

    l_party_id_tbl.DELETE;

Line: 479

          INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,
	  score_comp_type_id, metric_value, creation_date, created_by,
	  last_update_date, last_updated_by, last_update_login, metric_rating)
          VALUES(l_delinquency_id_tbl(idx1), 'DELINQUENCY',
	  --l_org_id, Moac Changes. Insert Org_id from cursor.
	  l_org_id_tbl(idx1),
	  l_metric_id_tbl(idx2), l_metric_value_tbl(idx2), SYSDATE,
	  G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID, l_metric_rating_tbl(idx2));