My selection criteria for a given service id must have the following.
_For example, 0_432296082 and 0459436899 would meet the selection criteria the other would not. Consider for the following data sample. I'm using oracle 9i...Thank you
CREATE TABLE TMP_SELECT
(SERVICE_ID VARCHAR2(20),
CHARGE_TYPE VARCHAR2(20),
DOMAIN VARCHAR2(10),
ISSUE VARCHAR2(30),
UNDER_OVER VARCHAR2(30)
) ;
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0407259613','Device Payment','Mobile','Miss Aligned','Undercharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0407259613','Monthly Plan','Mobile','Miss Aligned','Overcharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0407259613','Recurring Charge','Mobile','Missing','Undercharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0432296082','Device Payment','Mobile','Missing in IGEN','Undercharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0432296082','Monthly Plan','Mobile','Miss Aligned','Undercharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0432296082','Monthly Plan','Mobile','Missing in IGEN','Undercharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0432296082','Recurring Charge','Mobile','Missing','Undercharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0434496444','Monthly Plan','Mobile','Miss Aligned','Overcharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0435554455','Device Payment','Mobile','Missing in IGEN','Undercharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0435554455','Monthly Plan','Table','Missing in IGEN','Undercharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0435554455','Recurring Charge','Mobile','Missing','Undercharge');
Insert into tmp_select(SERVICE_ID,CHARGE_TYPE,DOMAIN,ISSUE,UNDER_OVER) values ('0459436899','Monthly Plan','Mobile','Miss Aligned','Undercharge');