[Home] [Help]
1052: to_number(cal_score(trx_summ.site_use_id,'IEX_BILLTO','SCORE_ID')) score_id,
1053: cal_score(trx_summ.site_use_id,'IEX_BILLTO','SCORE_NAME') score_name,
1054: max(decode(ac.resource_type, 'RS_RESOURCE' ,
1055: (select rs.source_name from jtf_rs_resource_extns rs where rs.resource_id= ac.resource_id),
1056: (select rg.group_name from JTF_RS_GROUPS_VL rg where rg.group_id=ac.resource_id)
1057: ) ) collector_resource_name,*/ --9597052
1058: -- end for the bug#7562130
1059: -- Start for the bug#8538945 by PNAVEENK
1060: /* party.address1 address1,
1480: FROM
1481: hz_customer_profiles hp,
1482: ar_collectors ac,
1483: iex_dln_uwq_summary temp,
1484: JTF_RS_GROUPS_VL rg,
1485: jtf_rs_resource_extns rs
1486: WHERE
1487: hp.site_use_id=temp.site_use_id
1488: and hp.collector_id=ac.collector_id
1672: to_number(cal_score(trx_summ.site_use_id,'IEX_BILLTO','SCORE_ID')) score_id,
1673: cal_score(trx_summ.site_use_id,'IEX_BILLTO','SCORE_NAME') score_name,
1674: max(decode(ac.resource_type, 'RS_RESOURCE' ,
1675: (select rs.source_name from jtf_rs_resource_extns rs where rs.resource_id= ac.resource_id),
1676: (select rg.group_name from JTF_RS_GROUPS_VL rg where rg.group_id=ac.resource_id)
1677: ) ) collector_resource_name,*/--9597052
1678: -- end for the bug#7562130
1679: -- Start for the bug#8538945 by PNAVEENK
1680: /* party.address1 address1,
2117: FROM
2118: hz_customer_profiles hp,
2119: ar_collectors ac,
2120: iex_dln_uwq_summary temp,
2121: JTF_RS_GROUPS_VL rg,
2122: jtf_rs_resource_extns rs
2123: WHERE
2124: hp.site_use_id=temp.site_use_id
2125: and hp.collector_id=ac.collector_id
2336: to_number(cal_score(trx_summ.cust_account_id,'IEX_ACCOUNT','SCORE_ID')) score_id,
2337: cal_score(trx_summ.cust_account_id,'IEX_ACCOUNT','SCORE_NAME') score_name,
2338: max(decode(ac.resource_type, 'RS_RESOURCE' ,
2339: (select rs.source_name from jtf_rs_resource_extns rs where rs.resource_id= ac.resource_id),
2340: (select rg.group_name from JTF_RS_GROUPS_VL rg where rg.group_id=ac.resource_id)
2341: ) ) collector_resource_name,
2342: -- end for the bug#7562130
2343: party.address1 address1,
2344: party.city city,
2722: FROM
2723: hz_customer_profiles hp,
2724: ar_collectors ac,
2725: iex_dln_uwq_summary temp,
2726: JTF_RS_GROUPS_VL rg,
2727: jtf_rs_resource_extns rs
2728: WHERE
2729: hp.CUST_ACCOUNT_ID = temp.CUST_ACCOUNT_ID
2730: and ac.collector_id(+) = hp.collector_id
2918: to_number(cal_score(trx_summ.cust_account_id,'IEX_ACCOUNT','SCORE_ID')) score_id,
2919: cal_score(trx_summ.cust_account_id,'IEX_ACCOUNT','SCORE_NAME') score_name,
2920: max(decode(ac.resource_type, 'RS_RESOURCE' ,
2921: (select rs.source_name from jtf_rs_resource_extns rs where rs.resource_id= ac.resource_id),
2922: (select rg.group_name from JTF_RS_GROUPS_VL rg where rg.group_id=ac.resource_id)
2923: ) ) collector_resource_name,
2924: -- end for the bug#7562130
2925: party.address1 address1,
2926: party.city city,
3324: FROM
3325: hz_customer_profiles hp,
3326: ar_collectors ac,
3327: iex_dln_uwq_summary temp,
3328: JTF_RS_GROUPS_VL rg,
3329: jtf_rs_resource_extns rs
3330: WHERE
3331: hp.CUST_ACCOUNT_ID = temp.CUST_ACCOUNT_ID
3332: and ac.collector_id(+) = hp.collector_id
3548: to_number(cal_score(party.party_id,'PARTY','SCORE_ID')) score_id,
3549: cal_score(party.party_id,'PARTY','SCORE_NAME') score_name,
3550: max(decode(ac.resource_type, 'RS_RESOURCE' ,
3551: (select rs.source_name from jtf_rs_resource_extns rs where rs.resource_id= ac.resource_id),
3552: (select rg.group_name from JTF_RS_GROUPS_VL rg where rg.group_id=ac.resource_id)
3553: ) ) collector_resource_name,
3554: -- end for the bug#7562130
3555: party.address1 address1,
3556: party.city city,
3922: FROM
3923: hz_customer_profiles hp,
3924: ar_collectors ac,
3925: iex_dln_uwq_summary temp,
3926: JTF_RS_GROUPS_VL rg,
3927: jtf_rs_resource_extns rs
3928: WHERE
3929: hp.party_id = temp.party_ID
3930: and ac.collector_id(+) = hp.collector_id
4126: to_number(cal_score(party.party_id,'PARTY','SCORE_ID')) score_id,
4127: cal_score(party.party_id,'PARTY','SCORE_NAME') score_name,
4128: max(decode(ac.resource_type, 'RS_RESOURCE' ,
4129: (select rs.source_name from jtf_rs_resource_extns rs where rs.resource_id= ac.resource_id),
4130: (select rg.group_name from JTF_RS_GROUPS_VL rg where rg.group_id=ac.resource_id)
4131: ) ) collector_resource_name,
4132: -- end for the bug#7562130
4133: party.address1 address1,
4134: party.city city,
4519: FROM
4520: hz_customer_profiles hp,
4521: ar_collectors ac,
4522: iex_dln_uwq_summary temp,
4523: JTF_RS_GROUPS_VL rg,
4524: jtf_rs_resource_extns rs
4525: WHERE
4526: hp.party_id = temp.party_ID
4527: and ac.collector_id(+) = hp.collector_id
4734: FROM
4735: ar_collectors ar,
4736: iex_dln_uwq_summary ids,
4737: jtf_rs_resource_extns rs,
4738: JTF_RS_GROUPS_VL rg
4739: WHERE
4740: ar.collector_id = ids.collector_id
4741: AND ar.resource_id is NOT NULL
4742: AND ar.resource_id <> ids.collector_resource_id
4763: hz_customer_profiles hp,
4764: iex_dln_uwq_summary ids,
4765: ar_collectors ar,
4766: jtf_rs_resource_extns rs,
4767: JTF_RS_GROUPS_VL rg
4768: WHERE
4769: hp.party_id = ids.party_id
4770: AND decode(hp.cust_account_id,-1,1,hp.cust_account_id)
4771: = decode(ids.cust_account_id,null,1,ids.cust_account_id)
9720: hz_customer_profiles hp,
9721: ar_collectors ac,
9722: iex_pop_uwq_summ_gt temp,
9723: jtf_rs_resource_extns rs,
9724: JTF_RS_GROUPS_VL rg
9725: WHERE
9726: hp.site_use_id=temp.object_id
9727: and hp.collector_id=ac.collector_id
9728: and rs.resource_id(+) = ac.resource_id
11045: hz_customer_profiles hp,
11046: ar_collectors ac,
11047: iex_pop_uwq_summ_gt temp,
11048: jtf_rs_resource_extns rs,
11049: JTF_RS_GROUPS_VL rg
11050: WHERE
11051: hp.site_use_id is null
11052: and hp.cust_account_id=temp.object_id
11053: and hp.collector_id=ac.collector_id
12356: hz_customer_profiles hp,
12357: ar_collectors ac,
12358: iex_pop_uwq_summ_gt temp,
12359: jtf_rs_resource_extns rs,
12360: JTF_RS_GROUPS_VL rg
12361: WHERE
12362: hp.cust_account_id = -1
12363: and hp.site_use_id is null
12364: and hp.party_id=temp.object_id