eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_COMPILE dependencies on HZ_MATCH_RULE_PRIMARY

Line 38: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

34: temp BOOLEAN := FALSE ;
35: BEGIN
36: FOR attrs in (
37: SELECT primary_attribute_id
38: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
39: where p.match_rule_id= p_match_rule_id
40: and p.attribute_id=a.attribute_id
41: and a.entity_name = p_entity_name
42: )

Line 368: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

364: -- Generate the Primary Attribute section of the query for the passed in entity
365: FIRST1 := TRUE;
366: FOR attrs in (
367: SELECT primary_attribute_id
368: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
369: where p.match_rule_id=p_rule_id
370: and p.attribute_id=a.attribute_id
371: and a.entity_name = p_entity
372: and nvl(p.filter_flag,'N') = 'N' )

Line 420: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

416: -- Generate the Primary Attribute section of the query for the passed in entity
417: FIRST1 := TRUE;
418: FOR attrs in (
419: SELECT primary_attribute_id
420: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
421: where p.match_rule_id=p_rule_id
422: and p.attribute_id=a.attribute_id
423: and a.entity_name = p_entity
424: and nvl(p.filter_flag,'N') = 'N' )

Line 495: FROM hz_match_rule_primary p, hz_trans_attributes_vl a

491: WHERE a.attribute_id = s.attribute_id
492: AND s.match_rule_id = p_rule_id
493: MINUS
494: SELECT DISTINCT a.entity_name
495: FROM hz_match_rule_primary p, hz_trans_attributes_vl a
496: WHERE a.attribute_id = p.attribute_id
497: AND p.match_rule_id = p_rule_id;
498:
499: CURSOR check_inactive IS

Line 501: FROM hz_match_rule_primary p, hz_primary_trans pt, hz_trans_functions_vl f

497: AND p.match_rule_id = p_rule_id;
498:
499: CURSOR check_inactive IS
500: SELECT 1
501: FROM hz_match_rule_primary p, hz_primary_trans pt, hz_trans_functions_vl f
502: WHERE p.match_rule_id = p_rule_id
503: AND pt.PRIMARY_ATTRIBUTE_ID = p.PRIMARY_ATTRIBUTE_ID
504: AND f.function_id = pt.function_id
505: AND f.ACTIVE_FLAG = 'N'

Line 2670: FROM HZ_MATCH_RULE_PRIMARY p,

2666:
2667: -- Setup of contains str
2668: l_num_primary := 0;
2669: SELECT count(1) INTO l_num_primary
2670: FROM HZ_MATCH_RULE_PRIMARY p,
2671: HZ_TRANS_ATTRIBUTES_VL a
2672: WHERE p.match_rule_id = p_rule_id
2673: AND p.ATTRIBUTE_ID = a.ATTRIBUTE_ID
2674: AND ENTITY_NAME = p_entity;

Line 2725: HZ_MATCH_RULE_PRIMARY p

2721: FOR PRIMATTRS IN (
2722: SELECT a.ATTRIBUTE_ID, PRIMARY_ATTRIBUTE_ID, ATTRIBUTE_NAME,nvl(FILTER_FLAG,'N') FILTER_FLAG,
2723: nvl(DENORM_FLAG,'N') DENORM_FLAG
2724: FROM HZ_TRANS_ATTRIBUTES_VL a,
2725: HZ_MATCH_RULE_PRIMARY p
2726: WHERE p.match_rule_id = p_rule_id
2727: AND p.attribute_id = a.attribute_id
2728: AND a.ENTITY_NAME = p_entity) LOOP
2729: l('');

Line 3476: HZ_MATCH_RULE_PRIMARY p,

3472: cnt := cnt+1;
3473: FOR PRIMATTRS IN (
3474: SELECT a.ATTRIBUTE_ID, PRIMARY_ATTRIBUTE_ID, ATTRIBUTE_NAME, nvl(SCORE,0) SCORE
3475: FROM HZ_TRANS_ATTRIBUTES_VL a,
3476: HZ_MATCH_RULE_PRIMARY p,
3477: HZ_MATCH_RULE_SECONDARY s
3478: WHERE p.match_rule_id = p_rule_id
3479: AND s.match_rule_id (+) = p_rule_id
3480: AND s.attribute_id (+) = a.attribute_id

Line 3588: HZ_MATCH_RULE_PRIMARY pattr,

3584: for PRIMTRANS IN (
3585: SELECT f.STAGED_ATTRIBUTE_COLUMN
3586: FROM HZ_TRANS_FUNCTIONS_VL f,
3587: HZ_TRANS_ATTRIBUTES_VL a,
3588: HZ_MATCH_RULE_PRIMARY pattr,
3589: HZ_PRIMARY_TRANS pfunc
3590: WHERE pattr.MATCH_RULE_ID = p_rule_id
3591: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3592: AND a.ENTITY_NAME = 'PARTY'

Line 3721: HZ_MATCH_RULE_PRIMARY p

3717: cnt := 1;
3718: FOR PATTRS IN (
3719: SELECT PRIMARY_ATTRIBUTE_ID, ATTRIBUTE_NAME
3720: FROM HZ_TRANS_ATTRIBUTES_VL a,
3721: HZ_MATCH_RULE_PRIMARY p
3722: WHERE p.match_rule_id = p_rule_id
3723: AND p.attribute_id = a.attribute_id
3724: AND a.ENTITY_NAME = 'PARTY'
3725: AND a.attribute_name <> 'PARTY_NAME'

Line 3761: HZ_MATCH_RULE_PRIMARY p

3757:
3758: FOR PATTRS IN (
3759: SELECT PRIMARY_ATTRIBUTE_ID, ATTRIBUTE_NAME
3760: FROM HZ_TRANS_ATTRIBUTES_VL a,
3761: HZ_MATCH_RULE_PRIMARY p
3762: WHERE p.match_rule_id = p_rule_id
3763: AND p.attribute_id = a.attribute_id
3764: AND a.ENTITY_NAME = 'PARTY'
3765: AND a.attribute_name <> 'PARTY_NAME'

Line 3800: HZ_MATCH_RULE_PRIMARY p

3796: FIRST := TRUE;
3797: FOR DENATTR IN (
3798: SELECT PRIMARY_ATTRIBUTE_ID, ATTRIBUTE_NAME
3799: FROM HZ_TRANS_ATTRIBUTES_VL a,
3800: HZ_MATCH_RULE_PRIMARY p
3801: WHERE p.match_rule_id = p_rule_id
3802: AND p.attribute_id = a.attribute_id
3803: AND a.ENTITY_NAME = 'PARTY_SITES'
3804: AND nvl(a.denorm_flag,'N') = 'Y') LOOP

Line 7349: HZ_MATCH_RULE_PRIMARY p

7345: FIRST := TRUE;
7346: FOR ATTRS IN (
7347: SELECT a.attribute_id, a.attribute_name, a.entity_name
7348: FROM HZ_TRANS_ATTRIBUTES_VL a,
7349: HZ_MATCH_RULE_PRIMARY p
7350: WHERE p.match_rule_id = p_rule_id
7351: AND p.attribute_id = a.attribute_id
7352:
7353: UNION

Line 8511: HZ_MATCH_RULE_PRIMARY p

8507: FIRST := TRUE;
8508: FOR PRIMATTRS IN (
8509: SELECT ATTRIBUTE_NAME
8510: FROM HZ_TRANS_ATTRIBUTES_VL a,
8511: HZ_MATCH_RULE_PRIMARY p
8512: WHERE p.match_rule_id = p_rule_id
8513: AND p.attribute_id = a.attribute_id
8514: AND a.ENTITY_NAME = 'PARTY'
8515: AND nvl(p.FILTER_FLAG,'N') = 'N') LOOP

Line 8560: HZ_MATCH_RULE_PRIMARY p

8556: FIRST := TRUE;
8557: FOR PRIMATTRS IN (
8558: SELECT ATTRIBUTE_NAME
8559: FROM HZ_TRANS_ATTRIBUTES_VL a,
8560: HZ_MATCH_RULE_PRIMARY p
8561: WHERE p.match_rule_id = p_rule_id
8562: AND a.ENTITY_NAME = 'PARTY_SITES'
8563: AND p.attribute_id = a.attribute_id)
8564: LOOP

Line 8624: HZ_MATCH_RULE_PRIMARY p

8620: FIRST := TRUE;
8621: FOR PRIMATTRS IN (
8622: SELECT ATTRIBUTE_NAME
8623: FROM HZ_TRANS_ATTRIBUTES_VL a,
8624: HZ_MATCH_RULE_PRIMARY p
8625: WHERE p.match_rule_id = p_rule_id
8626: AND a.ENTITY_NAME = 'CONTACTS'
8627: AND p.attribute_id = a.attribute_id)
8628: LOOP

Line 8686: HZ_MATCH_RULE_PRIMARY p

8682: FIRST := TRUE;
8683: FOR PRIMATTRS IN (
8684: SELECT ATTRIBUTE_NAME
8685: FROM HZ_TRANS_ATTRIBUTES_VL a,
8686: HZ_MATCH_RULE_PRIMARY p
8687: WHERE p.match_rule_id = p_rule_id
8688: AND a.ENTITY_NAME = 'CONTACT_POINTS'
8689: AND p.attribute_id = a.attribute_id)
8690: LOOP

Line 9119: HZ_MATCH_RULE_PRIMARY p,

9115: cnt := cnt+1;
9116: FOR PRIMATTRS IN (
9117: SELECT a.ATTRIBUTE_ID, PRIMARY_ATTRIBUTE_ID, ATTRIBUTE_NAME, nvl(SCORE,0) SCORE
9118: FROM HZ_TRANS_ATTRIBUTES_VL a,
9119: HZ_MATCH_RULE_PRIMARY p,
9120: HZ_MATCH_RULE_SECONDARY s
9121: WHERE p.match_rule_id = p_rule_id
9122: AND s.match_rule_id (+) = p_rule_id
9123: AND s.attribute_id (+) = a.attribute_id

Line 9175: HZ_MATCH_RULE_PRIMARY pattr,

9171: for PRIMTRANS IN (
9172: SELECT f.STAGED_ATTRIBUTE_COLUMN
9173: FROM HZ_TRANS_FUNCTIONS_VL f,
9174: HZ_TRANS_ATTRIBUTES_VL a,
9175: HZ_MATCH_RULE_PRIMARY pattr,
9176: HZ_PRIMARY_TRANS pfunc
9177: WHERE pattr.MATCH_RULE_ID = p_rule_id
9178: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9179: AND a.ENTITY_NAME = 'PARTY'

Line 11755: HZ_MATCH_RULE_PRIMARY p

11751: FIRST := TRUE;
11752: FOR ATTRS IN (
11753: SELECT a.attribute_id, a.attribute_name, a.entity_name
11754: FROM HZ_TRANS_ATTRIBUTES_VL a,
11755: HZ_MATCH_RULE_PRIMARY p
11756: WHERE p.match_rule_id = p_rule_id
11757: AND p.attribute_id = a.attribute_id
11758:
11759: UNION

Line 12879: HZ_MATCH_RULE_PRIMARY pattr,

12875: f.PROCEDURE_NAME,
12876: f.STAGED_ATTRIBUTE_COLUMN
12877: FROM HZ_TRANS_FUNCTIONS_VL f,
12878: HZ_TRANS_ATTRIBUTES_VL a,
12879: HZ_MATCH_RULE_PRIMARY pattr,
12880: HZ_PRIMARY_TRANS pfunc
12881: WHERE pattr.MATCH_RULE_ID = p_rule_id
12882: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
12883: AND a.ENTITY_NAME = 'PARTY'

Line 13094: HZ_MATCH_RULE_PRIMARY pattr,

13090: f.PROCEDURE_NAME,
13091: f.STAGED_ATTRIBUTE_COLUMN
13092: FROM HZ_TRANS_FUNCTIONS_VL f,
13093: HZ_TRANS_ATTRIBUTES_VL a,
13094: HZ_MATCH_RULE_PRIMARY pattr,
13095: HZ_PRIMARY_TRANS pfunc
13096: WHERE pattr.MATCH_RULE_ID = p_rule_id
13097: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13098: AND a.ENTITY_NAME = p_entity

Line 13210: HZ_MATCH_RULE_PRIMARY pattr,

13206: for FUNCS IN (
13207: SELECT a.ATTRIBUTE_ID, a.ATTRIBUTE_NAME
13208: FROM HZ_TRANS_FUNCTIONS_VL f,
13209: HZ_TRANS_ATTRIBUTES_VL a,
13210: HZ_MATCH_RULE_PRIMARY pattr,
13211: HZ_PRIMARY_TRANS pfunc
13212: WHERE pattr.MATCH_RULE_ID = p_rule_id
13213: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13214: AND a.ENTITY_NAME = p_entity

Line 13340: HZ_MATCH_RULE_PRIMARY pattr,

13336: f.PROCEDURE_NAME,
13337: f.STAGED_ATTRIBUTE_COLUMN
13338: FROM HZ_TRANS_FUNCTIONS_VL f,
13339: HZ_TRANS_ATTRIBUTES_VL a,
13340: HZ_MATCH_RULE_PRIMARY pattr,
13341: HZ_PRIMARY_TRANS pfunc
13342: WHERE pattr.MATCH_RULE_ID = p_rule_id
13343: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13344: AND a.ENTITY_NAME = p_entity

Line 13408: HZ_MATCH_RULE_PRIMARY pattr,

13404: f.PROCEDURE_NAME,
13405: f.STAGED_ATTRIBUTE_COLUMN
13406: FROM HZ_TRANS_FUNCTIONS_VL f,
13407: HZ_TRANS_ATTRIBUTES_VL a,
13408: HZ_MATCH_RULE_PRIMARY pattr,
13409: HZ_PRIMARY_TRANS pfunc
13410: WHERE pattr.MATCH_RULE_ID = p_rule_id
13411: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13412: AND a.ENTITY_NAME = p_entity

Line 13522: HZ_MATCH_RULE_PRIMARY sattr

13518: NONE:=TRUE;
13519: for PRIMATTRS IN (
13520: SELECT a.ATTRIBUTE_NAME
13521: FROM HZ_TRANS_ATTRIBUTES_VL a,
13522: HZ_MATCH_RULE_PRIMARY sattr
13523: WHERE sattr.MATCH_RULE_ID = p_rule_id
13524: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13525: AND a.ENTITY_NAME = 'PARTY'
13526: ) LOOP

Line 13563: HZ_MATCH_RULE_PRIMARY pattr,

13559: f.PROCEDURE_NAME,
13560: f.STAGED_ATTRIBUTE_COLUMN
13561: FROM HZ_TRANS_FUNCTIONS_VL f,
13562: HZ_TRANS_ATTRIBUTES_VL a,
13563: HZ_MATCH_RULE_PRIMARY pattr,
13564: HZ_PRIMARY_TRANS pfunc
13565: WHERE pattr.MATCH_RULE_ID = p_rule_id
13566: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13567: AND a.ENTITY_NAME = 'PARTY'

Line 13605: FROM HZ_MATCH_RULE_PRIMARY p

13601: NONE := FALSE;
13602: trxctx := has_trx_context(FUNCS.PROCEDURE_NAME);
13603: begin
13604: select nvl(filter_flag, 'N') INTO l_filt
13605: FROM HZ_MATCH_RULE_PRIMARY p
13606: where p.MATCH_RULE_ID = p_rule_id
13607: AND p.attribute_id = FUNCS.attribute_id;
13608: exception
13609: when no_data_found then

Line 13717: HZ_MATCH_RULE_PRIMARY p

13713:
13714: FIRST := TRUE;
13715: FOR CPTS IN (SELECT ATTRIBUTE_NAME
13716: FROM HZ_TRANS_ATTRIBUTES_VL a,
13717: HZ_MATCH_RULE_PRIMARY p
13718: WHERE p.match_rule_id = p_rule_id
13719: AND a.ENTITY_NAME = 'CONTACT_POINTS'
13720: AND p.attribute_id = a.attribute_id
13721: AND ATTRIBUTE_NAME <> 'CONTACT_POINT_TYPE'

Line 13745: HZ_MATCH_RULE_PRIMARY p

13741:
13742: FOR PRIMATTRS IN (
13743: SELECT ATTRIBUTE_NAME
13744: FROM HZ_TRANS_ATTRIBUTES_VL a,
13745: HZ_MATCH_RULE_PRIMARY p
13746: WHERE p.match_rule_id = p_rule_id
13747: AND p.attribute_id = a.attribute_id
13748: AND a.ENTITY_NAME = 'PARTY'
13749: AND nvl(p.FILTER_FLAG,'N') = 'N') LOOP

Line 13758: HZ_MATCH_RULE_PRIMARY p

13754:
13755: FOR PRIMATTRS IN (
13756: SELECT ENTITY_NAME, ATTRIBUTE_NAME
13757: FROM HZ_TRANS_ATTRIBUTES_VL a,
13758: HZ_MATCH_RULE_PRIMARY p
13759: WHERE p.match_rule_id = p_rule_id
13760: AND a.ENTITY_NAME <> 'PARTY'
13761: AND p.attribute_id = a.attribute_id
13762: AND ATTRIBUTE_NAME <> 'CONTACT_POINT_TYPE'

Line 13814: HZ_MATCH_RULE_PRIMARY p

13810: FIRST := TRUE;
13811: FOR PRIMATTRS IN (
13812: SELECT ATTRIBUTE_NAME
13813: FROM HZ_TRANS_ATTRIBUTES_VL a,
13814: HZ_MATCH_RULE_PRIMARY p
13815: WHERE p.match_rule_id = p_rule_id
13816: AND a.ENTITY_NAME = 'PARTY_SITES'
13817: AND p.attribute_id = a.attribute_id)
13818: LOOP

Line 13841: HZ_MATCH_RULE_PRIMARY p

13837: FIRST := TRUE;
13838: FOR PRIMATTRS IN (
13839: SELECT ATTRIBUTE_NAME
13840: FROM HZ_TRANS_ATTRIBUTES_VL a,
13841: HZ_MATCH_RULE_PRIMARY p
13842: WHERE p.match_rule_id = p_rule_id
13843: AND a.ENTITY_NAME = 'CONTACT_POINTS'
13844: AND p.attribute_id = a.attribute_id)
13845: LOOP

Line 13952: HZ_MATCH_RULE_PRIMARY p

13948: FIRST := TRUE;
13949: FOR PRIMATTRS IN (
13950: SELECT ATTRIBUTE_NAME
13951: FROM HZ_TRANS_ATTRIBUTES_VL a,
13952: HZ_MATCH_RULE_PRIMARY p
13953: WHERE p.match_rule_id = p_rule_id
13954: AND a.ENTITY_NAME = 'CONTACTS'
13955: AND p.attribute_id = a.attribute_id)
13956: LOOP

Line 13979: HZ_MATCH_RULE_PRIMARY p

13975: FIRST := TRUE;
13976: FOR PRIMATTRS IN (
13977: SELECT ATTRIBUTE_NAME
13978: FROM HZ_TRANS_ATTRIBUTES_VL a,
13979: HZ_MATCH_RULE_PRIMARY p
13980: WHERE p.match_rule_id = p_rule_id
13981: AND a.ENTITY_NAME = 'CONTACT_POINTS'
13982: AND p.attribute_id = a.attribute_id)
13983: LOOP

Line 14095: HZ_MATCH_RULE_PRIMARY p

14091: FIRST := TRUE;
14092: FOR PRIMATTRS IN (
14093: SELECT ATTRIBUTE_NAME
14094: FROM HZ_TRANS_ATTRIBUTES_VL a,
14095: HZ_MATCH_RULE_PRIMARY p
14096: WHERE p.match_rule_id = p_rule_id
14097: AND a.ENTITY_NAME = 'CONTACT_POINTS'
14098: AND p.attribute_id = a.attribute_id)
14099: LOOP

Line 14170: HZ_MATCH_RULE_PRIMARY p

14166:
14167: FOR CUSTATTRS IN (
14168: SELECT distinct ATTRIBUTE_NAME, CUSTOM_ATTRIBUTE_PROCEDURE
14169: FROM HZ_TRANS_ATTRIBUTES_VL a,
14170: HZ_MATCH_RULE_PRIMARY p
14171: WHERE p.match_rule_id = p_rule_id
14172: AND p.attribute_id = a.attribute_id
14173: AND a.ENTITY_NAME = p_entity
14174: AND (a.SOURCE_TABLE = 'CUSTOM'

Line 14236: HZ_MATCH_RULE_PRIMARY p

14232: SELECT COUNT(*) INTO l_num_attrs
14233: FROM (
14234: SELECT a.attribute_id
14235: FROM HZ_TRANS_ATTRIBUTES_VL a,
14236: HZ_MATCH_RULE_PRIMARY p
14237: WHERE p.match_rule_id = p_rule_id
14238: AND p.attribute_id = a.attribute_id
14239: AND a.ENTITY_NAME = 'PARTY'
14240:

Line 14261: HZ_MATCH_RULE_PRIMARY p

14257: SELECT COUNT(*) INTO l_num_attrs
14258: FROM (
14259: SELECT a.attribute_id
14260: FROM HZ_TRANS_ATTRIBUTES_VL a,
14261: HZ_MATCH_RULE_PRIMARY p
14262: WHERE p.match_rule_id = p_rule_id
14263: AND p.attribute_id = a.attribute_id
14264: AND a.ENTITY_NAME = 'PARTY_SITES'
14265:

Line 14327: HZ_MATCH_RULE_PRIMARY p

14323: SELECT COUNT(*) INTO l_num_attrs
14324: FROM (
14325: SELECT a.attribute_id
14326: FROM HZ_TRANS_ATTRIBUTES_VL a,
14327: HZ_MATCH_RULE_PRIMARY p
14328: WHERE p.match_rule_id = p_rule_id
14329: AND p.attribute_id = a.attribute_id
14330: AND a.ENTITY_NAME = 'CONTACTS'
14331:

Line 14366: HZ_MATCH_RULE_PRIMARY p

14362: SELECT COUNT(*) INTO l_num_attrs
14363: FROM (
14364: SELECT a.attribute_id
14365: FROM HZ_TRANS_ATTRIBUTES_VL a,
14366: HZ_MATCH_RULE_PRIMARY p
14367: WHERE p.match_rule_id = p_rule_id
14368: AND p.attribute_id = a.attribute_id
14369: AND a.ENTITY_NAME = 'CONTACT_POINTS'
14370:

Line 14455: HZ_MATCH_RULE_PRIMARY p

14451: SELECT COUNT(*) INTO l_num_attrs
14452: FROM (
14453: SELECT a.attribute_id
14454: FROM HZ_TRANS_ATTRIBUTES_VL a,
14455: HZ_MATCH_RULE_PRIMARY p
14456: WHERE p.match_rule_id = p_rule_id
14457: AND p.attribute_id = a.attribute_id
14458: AND a.ENTITY_NAME = 'PARTY'
14459:

Line 14481: HZ_MATCH_RULE_PRIMARY p

14477: SELECT COUNT(*) INTO l_num_attrs
14478: FROM (
14479: SELECT a.attribute_id
14480: FROM HZ_TRANS_ATTRIBUTES_VL a,
14481: HZ_MATCH_RULE_PRIMARY p
14482: WHERE p.match_rule_id = p_rule_id
14483: AND p.attribute_id = a.attribute_id
14484: AND a.ENTITY_NAME = 'PARTY_SITES'
14485:

Line 14509: HZ_MATCH_RULE_PRIMARY p

14505: SELECT COUNT(*) INTO l_num_attrs
14506: FROM (
14507: SELECT a.attribute_id
14508: FROM HZ_TRANS_ATTRIBUTES_VL a,
14509: HZ_MATCH_RULE_PRIMARY p
14510: WHERE p.match_rule_id = p_rule_id
14511: AND p.attribute_id = a.attribute_id
14512: AND a.ENTITY_NAME = 'CONTACTS'
14513:

Line 14536: HZ_MATCH_RULE_PRIMARY p

14532: SELECT COUNT(*) INTO l_num_attrs
14533: FROM (
14534: SELECT a.attribute_id
14535: FROM HZ_TRANS_ATTRIBUTES_VL a,
14536: HZ_MATCH_RULE_PRIMARY p
14537: WHERE p.match_rule_id = p_rule_id
14538: AND p.attribute_id = a.attribute_id
14539: AND a.ENTITY_NAME = 'CONTACT_POINTS'
14540:

Line 14596: HZ_MATCH_RULE_PRIMARY p

14592: SELECT COUNT(*) INTO l_num_attrs
14593: FROM (
14594: SELECT a.attribute_id
14595: FROM HZ_TRANS_ATTRIBUTES_VL a,
14596: HZ_MATCH_RULE_PRIMARY p
14597: WHERE p.match_rule_id = p_rule_id
14598: AND p.attribute_id = a.attribute_id
14599: AND a.ENTITY_NAME = 'PARTY'
14600: AND (a.SOURCE_TABLE = 'HZ_PARTIES' OR

Line 14625: HZ_MATCH_RULE_PRIMARY p

14621: FIRST := TRUE;
14622: FOR ATTRS IN (
14623: SELECT distinct a.ATTRIBUTE_NAME, decode(a.SOURCE_TABLE, 'HZ_ORGANIZATION_PROFILES, HZ_PERSON_PROFILES', 'HZ_ORGANIZATION_PROFILES', 'HZ_PERSON_PROFILES, HZ_ORGANIZATION_PROFILES', 'HZ_ORGANIZATION_PROFILES', a.SOURCE_TABLE) SOURCE_TABLE
14624: FROM HZ_TRANS_ATTRIBUTES_VL a,
14625: HZ_MATCH_RULE_PRIMARY p
14626: WHERE p.match_rule_id = p_rule_id
14627: AND p.attribute_id = a.attribute_id
14628: AND a.ENTITY_NAME = 'PARTY'
14629: AND (a.SOURCE_TABLE = 'HZ_PARTIES' OR

Line 14660: HZ_MATCH_RULE_PRIMARY p

14656: FIRST := TRUE;
14657: FOR ATTRS IN (
14658: SELECT distinct a.ATTRIBUTE_NAME
14659: FROM HZ_TRANS_ATTRIBUTES_VL a,
14660: HZ_MATCH_RULE_PRIMARY p
14661: WHERE p.match_rule_id = p_rule_id
14662: AND p.attribute_id = a.attribute_id
14663: AND a.ENTITY_NAME = 'PARTY'
14664: AND (a.SOURCE_TABLE = 'HZ_PARTIES' OR

Line 14704: HZ_MATCH_RULE_PRIMARY p

14700: SELECT COUNT(*) INTO l_num_attrs
14701: FROM (
14702: SELECT a.attribute_id
14703: FROM HZ_TRANS_ATTRIBUTES_VL a,
14704: HZ_MATCH_RULE_PRIMARY p
14705: WHERE p.match_rule_id = p_rule_id
14706: AND p.attribute_id = a.attribute_id
14707: AND a.ENTITY_NAME = 'PARTY'
14708: AND (a.SOURCE_TABLE = 'HZ_PARTIES' OR

Line 14733: HZ_MATCH_RULE_PRIMARY p

14729: FIRST := TRUE;
14730: FOR ATTRS IN (
14731: SELECT distinct a.ATTRIBUTE_NAME, decode(a.SOURCE_TABLE, 'HZ_ORGANIZATION_PROFILES, HZ_PERSON_PROFILES', 'HZ_PERSON_PROFILES','HZ_PERSON_PROFILES, HZ_ORGANIZATION_PROFILES', 'HZ_PERSON_PROFILES', a.SOURCE_TABLE) SOURCE_TABLE
14732: FROM HZ_TRANS_ATTRIBUTES_VL a,
14733: HZ_MATCH_RULE_PRIMARY p
14734: WHERE p.match_rule_id = p_rule_id
14735: AND p.attribute_id = a.attribute_id
14736: AND a.ENTITY_NAME = 'PARTY'
14737: AND (a.SOURCE_TABLE = 'HZ_PARTIES' OR

Line 14768: HZ_MATCH_RULE_PRIMARY p

14764: FIRST := TRUE;
14765: FOR ATTRS IN (
14766: SELECT distinct a.ATTRIBUTE_NAME
14767: FROM HZ_TRANS_ATTRIBUTES_VL a,
14768: HZ_MATCH_RULE_PRIMARY p
14769: WHERE p.match_rule_id = p_rule_id
14770: AND p.attribute_id = a.attribute_id
14771: AND a.ENTITY_NAME = 'PARTY'
14772: AND (a.SOURCE_TABLE = 'HZ_PARTIES' OR

Line 14833: HZ_MATCH_RULE_PRIMARY p

14829: l(' SELECT party_site_id');
14830: FOR ATTRS IN (
14831: SELECT distinct a.ATTRIBUTE_NAME, a.SOURCE_TABLE
14832: FROM HZ_TRANS_ATTRIBUTES_VL a,
14833: HZ_MATCH_RULE_PRIMARY p
14834: WHERE p.match_rule_id = p_rule_id
14835: AND p.attribute_id = a.attribute_id
14836: AND a.ENTITY_NAME = 'PARTY_SITES'
14837: AND a.SOURCE_TABLE <> 'CUSTOM'

Line 14869: HZ_MATCH_RULE_PRIMARY p

14865: l(' l_party_site_id');
14866: FOR ATTRS IN (
14867: SELECT distinct a.ATTRIBUTE_NAME, a.SOURCE_TABLE
14868: FROM HZ_TRANS_ATTRIBUTES_VL a,
14869: HZ_MATCH_RULE_PRIMARY p
14870: WHERE p.match_rule_id = p_rule_id
14871: AND p.attribute_id = a.attribute_id
14872: AND a.ENTITY_NAME = 'PARTY_SITES'
14873: AND a.SOURCE_TABLE <> 'CUSTOM'

Line 14923: HZ_MATCH_RULE_PRIMARY p

14919: l(' SELECT org_contact_id');
14920: FOR ATTRS IN (
14921: SELECT distinct a.ATTRIBUTE_NAME, a.SOURCE_TABLE
14922: FROM HZ_TRANS_ATTRIBUTES_VL a,
14923: HZ_MATCH_RULE_PRIMARY p
14924: WHERE p.match_rule_id = p_rule_id
14925: AND p.attribute_id = a.attribute_id
14926: AND a.ENTITY_NAME = 'CONTACTS'
14927: AND a.SOURCE_TABLE <> 'CUSTOM'

Line 14964: HZ_MATCH_RULE_PRIMARY p

14960: l(' l_org_contact_id');
14961: FOR ATTRS IN (
14962: SELECT distinct a.ATTRIBUTE_NAME, a.SOURCE_TABLE
14963: FROM HZ_TRANS_ATTRIBUTES_VL a,
14964: HZ_MATCH_RULE_PRIMARY p
14965: WHERE p.match_rule_id = p_rule_id
14966: AND p.attribute_id = a.attribute_id
14967: AND a.ENTITY_NAME = 'CONTACTS'
14968: AND a.SOURCE_TABLE <> 'CUSTOM'

Line 15018: HZ_MATCH_RULE_PRIMARY p

15014: l(' SELECT contact_point_id, contact_point_type');
15015: FOR ATTRS IN (
15016: SELECT distinct a.ATTRIBUTE_NAME, a.SOURCE_TABLE
15017: FROM HZ_TRANS_ATTRIBUTES_VL a,
15018: HZ_MATCH_RULE_PRIMARY p
15019: WHERE p.match_rule_id = p_rule_id
15020: AND p.attribute_id = a.attribute_id
15021: AND a.ENTITY_NAME = 'CONTACT_POINTS'
15022: AND a.SOURCE_TABLE <> 'CUSTOM'

Line 15057: HZ_MATCH_RULE_PRIMARY p

15053:
15054: FOR ATTRS IN (
15055: SELECT distinct a.ATTRIBUTE_NAME, a.SOURCE_TABLE
15056: FROM HZ_TRANS_ATTRIBUTES_VL a,
15057: HZ_MATCH_RULE_PRIMARY p
15058: WHERE p.match_rule_id = p_rule_id
15059: AND p.attribute_id = a.attribute_id
15060: AND a.ENTITY_NAME = 'CONTACT_POINTS'
15061: AND a.SOURCE_TABLE <> 'CUSTOM'

Line 15105: FROM hz_primary_trans f, hz_match_rule_primary a

15101: ) IS
15102:
15103: CURSOR c_trans_func IS
15104: SELECT f.FUNCTION_ID
15105: FROM hz_primary_trans f, hz_match_rule_primary a
15106: WHERE a.MATCH_RULE_ID = p_rule_id
15107: AND a.PRIMARY_ATTRIBUTE_ID = f.PRIMARY_ATTRIBUTE_ID
15108:
15109: UNION

Line 15119: FROM hz_primary_trans f, hz_match_rule_primary a

15115:
15116: ---Start of Code Change for Match Rule Set
15117: CURSOR c_ruleset_trans_func IS
15118: SELECT f.FUNCTION_ID
15119: FROM hz_primary_trans f, hz_match_rule_primary a
15120: WHERE a.MATCH_RULE_ID IN (SELECT UNIQUE CONDITION_MATCH_RULE_ID
15121: FROM HZ_MATCH_RULE_CONDITIONS
15122: WHERE MATCH_RULE_SET_ID = p_rule_id
15123: )

Line 15554: FROM HZ_MATCH_RULE_PRIMARY p,

15550:
15551: l_num_primary NUMBER;
15552: BEGIN
15553: SELECT count(1) INTO l_num_primary
15554: FROM HZ_MATCH_RULE_PRIMARY p,
15555: HZ_TRANS_ATTRIBUTES_VL a
15556: WHERE p.match_rule_id = p_rule_id
15557: AND p.ATTRIBUTE_ID = a.ATTRIBUTE_ID
15558: AND ENTITY_NAME = p_entity;