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_TRANS_FUNCTIONS_VL

Line 387: FROM hz_primary_trans pt, hz_trans_functions_vl f

383: END IF;
384:
385: FIRST := TRUE;
386: FOR trans in ( SELECT staged_attribute_column
387: FROM hz_primary_trans pt, hz_trans_functions_vl f
388: where f.function_id = pt.function_id
389: and pt.primary_attribute_id = attrs.primary_attribute_id
390: )
391: LOOP

Line 439: FROM hz_primary_trans pt, hz_trans_functions_vl f

435: END IF;
436:
437: FIRST := TRUE;
438: FOR trans in ( SELECT staged_attribute_column
439: FROM hz_primary_trans pt, hz_trans_functions_vl f
440: where f.function_id = pt.function_id
441: and pt.primary_attribute_id = attrs.primary_attribute_id
442: )
443: LOOP

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 508: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f

504: AND f.function_id = pt.function_id
505: AND f.ACTIVE_FLAG = 'N'
506: UNION
507: SELECT 1
508: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f
509: WHERE s.match_rule_id = p_rule_id
510: AND pt.SECONDARY_ATTRIBUTE_ID = s.SECONDARY_ATTRIBUTE_ID
511: AND f.function_id = pt.function_id
512: AND f.ACTIVE_FLAG = 'N';

Line 2285: FROM hz_trans_functions_vl f, hz_secondary_trans st,

2281: l(' x_matchidx OUT NUMBER');
2282: FIRST := TRUE;
2283: FOR TX IN (
2284: SELECT f.staged_attribute_column
2285: FROM hz_trans_functions_vl f, hz_secondary_trans st,
2286: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
2287: WHERE sa.match_rule_id = p_rule_id
2288: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
2289: AND st.function_id = f.function_id

Line 2325: HZ_TRANS_FUNCTIONS_VL f

2321: FOR SECTRANS IN (
2322: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
2323: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
2324: FROM HZ_SECONDARY_TRANS s,
2325: HZ_TRANS_FUNCTIONS_VL f
2326: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
2327: AND s.FUNCTION_ID = f.FUNCTION_ID
2328: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP
2329: IF FIRST THEN

Line 2393: FROM hz_trans_functions_vl f, hz_secondary_trans st,

2389: END IF;
2390: FIRST := TRUE;
2391: FOR TX IN (
2392: SELECT f.staged_attribute_column
2393: FROM hz_trans_functions_vl f, hz_secondary_trans st,
2394: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
2395: WHERE sa.match_rule_id = p_rule_id
2396: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
2397: AND st.function_id = f.function_id

Line 2424: HZ_TRANS_FUNCTIONS_VL f

2420: FOR SECTRANS IN (
2421: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
2422: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
2423: FROM HZ_SECONDARY_TRANS s,
2424: HZ_TRANS_FUNCTIONS_VL f
2425: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
2426: AND s.FUNCTION_ID = f.FUNCTION_ID
2427: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP
2428: IF FIRST THEN

Line 2736: FROM HZ_TRANS_FUNCTIONS_VL f,

2732: l(' l_prim_temp_den := null;');
2733: FIRST1 := TRUE;
2734: FOR PRIMTRANS IN (
2735: SELECT f.STAGED_ATTRIBUTE_COLUMN, f.TRANSFORMATION_NAME, nvl(f.PRIMARY_FLAG,'N') PRIMARY_FLAG
2736: FROM HZ_TRANS_FUNCTIONS_VL f,
2737: HZ_PRIMARY_TRANS pt
2738: WHERE pt.PRIMARY_ATTRIBUTE_ID = PRIMATTRS.PRIMARY_ATTRIBUTE_ID
2739: AND pt.FUNCTION_ID = f.FUNCTION_ID) LOOP
2740: IF PRIMATTRS.FILTER_FLAG <> 'Y' THEN

Line 2849: FROM hz_trans_functions_vl f, hz_secondary_trans st,

2845:
2846: FIRST := TRUE;
2847: FOR TX IN (
2848: SELECT f.staged_attribute_column, a.attribute_name, f.procedure_name
2849: FROM hz_trans_functions_vl f, hz_secondary_trans st,
2850: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
2851: WHERE sa.match_rule_id = p_rule_id
2852: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
2853: AND st.function_id = f.function_id

Line 3138: FROM hz_trans_functions_vl f, hz_secondary_trans st,

3134: l(' FUNCTION GET_PARTY_SCORE ');
3135: FIRST := TRUE;
3136: FOR TX IN (
3137: SELECT f.staged_attribute_column
3138: FROM hz_trans_functions_vl f, hz_secondary_trans st,
3139: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
3140: WHERE sa.match_rule_id = p_rule_id
3141: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
3142: AND st.function_id = f.function_id

Line 3179: HZ_TRANS_FUNCTIONS_VL f

3175: FOR SECTRANS IN (
3176: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
3177: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
3178: FROM HZ_SECONDARY_TRANS s,
3179: HZ_TRANS_FUNCTIONS_VL f
3180: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
3181: AND s.FUNCTION_ID = f.FUNCTION_ID
3182: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP
3183: IF FIRST THEN

Line 3491: FROM HZ_TRANS_FUNCTIONS_VL f,

3487: l(' -- Setup query string for '||PRIMATTRS.ATTRIBUTE_NAME);
3488: l(' l_prim_temp := null;');
3489: FOR PRIMTRANS IN (
3490: SELECT f.STAGED_ATTRIBUTE_COLUMN, f.TRANSFORMATION_NAME, nvl(f.PRIMARY_FLAG,'N') PRIMARY_FLAG, f.PROCEDURE_NAME
3491: FROM HZ_TRANS_FUNCTIONS_VL f,
3492: HZ_PRIMARY_TRANS pt
3493: WHERE pt.PRIMARY_ATTRIBUTE_ID = PRIMATTRS.PRIMARY_ATTRIBUTE_ID
3494: AND pt.FUNCTION_ID = f.FUNCTION_ID)
3495: LOOP

Line 3586: FROM HZ_TRANS_FUNCTIONS_VL f,

3582: FIRST := TRUE;
3583: cnt := 1;
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

Line 3600: FROM HZ_TRANS_FUNCTIONS_VL f,

3596:
3597: UNION
3598:
3599: SELECT f.STAGED_ATTRIBUTE_COLUMN
3600: FROM HZ_TRANS_FUNCTIONS_VL f,
3601: HZ_TRANS_ATTRIBUTES_VL a
3602: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3603: AND a.entity_name = 'PARTY'
3604: AND a.attribute_name='PARTY_TYPE'

Line 3737: FROM HZ_TRANS_FUNCTIONS_VL f,

3733:
3734: FIRST1 := TRUE;
3735: FOR PRIMTRANS IN (
3736: SELECT f.STAGED_ATTRIBUTE_COLUMN
3737: FROM HZ_TRANS_FUNCTIONS_VL f,
3738: HZ_PRIMARY_TRANS pt
3739: WHERE pt.PRIMARY_ATTRIBUTE_ID = PATTRS.PRIMARY_ATTRIBUTE_ID
3740: AND pt.FUNCTION_ID = f.FUNCTION_ID) LOOP
3741: IF FIRST1 THEN

Line 3772: FROM HZ_TRANS_FUNCTIONS_VL f,

3768:
3769: FIRST1 := TRUE;
3770: FOR PRIMTRANS IN (
3771: SELECT f.STAGED_ATTRIBUTE_COLUMN
3772: FROM HZ_TRANS_FUNCTIONS_VL f,
3773: HZ_PRIMARY_TRANS pt
3774: WHERE pt.PRIMARY_ATTRIBUTE_ID = PATTRS.PRIMARY_ATTRIBUTE_ID
3775: AND pt.FUNCTION_ID = f.FUNCTION_ID) LOOP
3776: IF FIRST1 THEN

Line 3809: FROM HZ_TRANS_FUNCTIONS_VL f,

3805: l(' l_sqlstr := l_sqlstr || '' AND (:attr IS NULL OR '';');
3806: FIRST1 := TRUE;
3807: FOR DENTRANS IN (
3808: SELECT f.STAGED_ATTRIBUTE_COLUMN
3809: FROM HZ_TRANS_FUNCTIONS_VL f,
3810: HZ_PRIMARY_TRANS pt
3811: WHERE pt.PRIMARY_ATTRIBUTE_ID = DENATTR.PRIMARY_ATTRIBUTE_ID
3812: AND pt.FUNCTION_ID = f.FUNCTION_ID) LOOP
3813: IF FIRST1 THEN

Line 4883: FROM hz_trans_functions_vl f, hz_secondary_trans st,

4879: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
4880: l('');
4881: FOR TX IN (
4882: SELECT distinct f.staged_attribute_column
4883: FROM hz_trans_functions_vl f, hz_secondary_trans st,
4884: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
4885: WHERE sa.match_rule_id = p_rule_id
4886: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
4887: AND st.function_id = f.function_id

Line 5863: FROM hz_trans_functions_vl f, hz_secondary_trans st,

5859: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
5860: l('');
5861: FOR TX IN (
5862: SELECT distinct f.staged_attribute_column
5863: FROM hz_trans_functions_vl f, hz_secondary_trans st,
5864: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
5865: WHERE sa.match_rule_id = p_rule_id
5866: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
5867: AND st.function_id = f.function_id

Line 5918: FROM HZ_TRANS_FUNCTIONS_VL f,

5914: FOR TX IN (
5915: SELECT a.attribute_name,
5916: f.PROCEDURE_NAME,
5917: f.STAGED_ATTRIBUTE_COLUMN
5918: FROM HZ_TRANS_FUNCTIONS_VL f,
5919: HZ_TRANS_ATTRIBUTES_VL a
5920: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5921: AND a.entity_name = 'PARTY'
5922: AND a.attribute_name='PARTY_TYPE'

Line 7490: FROM hz_trans_functions_vl f, hz_secondary_trans st,

7486: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
7487: l('');
7488: FOR TX IN (
7489: SELECT distinct f.staged_attribute_column
7490: FROM hz_trans_functions_vl f, hz_secondary_trans st,
7491: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
7492: WHERE sa.match_rule_id = p_rule_id
7493: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
7494: AND st.function_id = f.function_id

Line 7764: FROM hz_trans_functions_vl f, hz_secondary_trans st,

7760: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
7761: l('');
7762: FOR TX IN (
7763: SELECT distinct f.staged_attribute_column
7764: FROM hz_trans_functions_vl f, hz_secondary_trans st,
7765: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
7766: WHERE sa.match_rule_id = p_rule_id
7767: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
7768: AND st.function_id = f.function_id

Line 8032: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8028: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
8029: l('');
8030: FOR TX IN (
8031: SELECT distinct f.staged_attribute_column
8032: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8033: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8034: WHERE sa.match_rule_id = p_rule_id
8035: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8036: AND st.function_id = f.function_id

Line 8219: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8215: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
8216: l('');
8217: FOR TX IN (
8218: SELECT distinct f.staged_attribute_column
8219: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8220: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8221: WHERE sa.match_rule_id = p_rule_id
8222: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8223: AND st.function_id = f.function_id

Line 8326: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8322: l(' l_max_id := l_party_site_id;');
8323: l(' l_max_idx := l_match_idx;');
8324: FOR TX IN (
8325: SELECT distinct f.staged_attribute_column
8326: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8327: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8328: WHERE sa.match_rule_id = p_rule_id
8329: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8330: AND st.function_id = f.function_id

Line 8359: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8355: l(' l_max_id := l_org_contact_id;');
8356: l(' l_max_idx := l_match_idx;');
8357: FOR TX IN (
8358: SELECT distinct f.staged_attribute_column
8359: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8360: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8361: WHERE sa.match_rule_id = p_rule_id
8362: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8363: AND st.function_id = f.function_id

Line 8396: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8392: l(' l_max_id := l_contact_pt_id;');
8393: l(' l_max_idx := l_match_idx;');
8394: FOR TX IN (
8395: SELECT distinct f.staged_attribute_column
8396: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8397: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8398: WHERE sa.match_rule_id = p_rule_id
8399: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8400: AND st.function_id = f.function_id

Line 8870: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8866: l(' FUNCTION GET_PARTY_SCORE ');
8867: FIRST := TRUE;
8868: FOR TX IN (
8869: SELECT f.staged_attribute_column
8870: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8871: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8872: WHERE sa.match_rule_id = p_rule_id
8873: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8874: AND st.function_id = f.function_id

Line 8909: HZ_TRANS_FUNCTIONS_VL f

8905: FOR SECTRANS IN (
8906: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
8907: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
8908: FROM HZ_SECONDARY_TRANS s,
8909: HZ_TRANS_FUNCTIONS_VL f
8910: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
8911: AND s.FUNCTION_ID = f.FUNCTION_ID
8912: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP
8913: IF FIRST THEN

Line 9131: FROM HZ_TRANS_FUNCTIONS_VL f,

9127: ORDER BY SCORE) LOOP
9128: FIRST1 := TRUE;
9129: FOR PRIMTRANS IN (
9130: SELECT f.STAGED_ATTRIBUTE_COLUMN, f.TRANSFORMATION_NAME, nvl(f.PRIMARY_FLAG,'N') PRIMARY_FLAG
9131: FROM HZ_TRANS_FUNCTIONS_VL f,
9132: HZ_PRIMARY_TRANS pt
9133: WHERE pt.PRIMARY_ATTRIBUTE_ID = PRIMATTRS.PRIMARY_ATTRIBUTE_ID
9134: AND pt.FUNCTION_ID = f.FUNCTION_ID)
9135: LOOP

Line 9173: FROM HZ_TRANS_FUNCTIONS_VL f,

9169: FIRST := TRUE;
9170: cnt := 1;
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

Line 9187: FROM HZ_TRANS_FUNCTIONS_VL f,

9183:
9184: UNION
9185:
9186: SELECT f.STAGED_ATTRIBUTE_COLUMN
9187: FROM HZ_TRANS_FUNCTIONS_VL f,
9188: HZ_TRANS_ATTRIBUTES_VL a
9189: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9190: AND a.entity_name = 'PARTY'
9191: AND a.attribute_name='PARTY_TYPE'

Line 9753: FROM hz_trans_functions_vl f, hz_secondary_trans st,

9749: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
9750: l('');
9751: FOR TX IN (
9752: SELECT distinct f.staged_attribute_column
9753: FROM hz_trans_functions_vl f, hz_secondary_trans st,
9754: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
9755: WHERE sa.match_rule_id = p_rule_id
9756: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
9757: AND st.function_id = f.function_id

Line 10498: FROM hz_trans_functions_vl f, hz_secondary_trans st,

10494: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
10495: l('');
10496: FOR TX IN (
10497: SELECT distinct f.staged_attribute_column
10498: FROM hz_trans_functions_vl f, hz_secondary_trans st,
10499: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
10500: WHERE sa.match_rule_id = p_rule_id
10501: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
10502: AND st.function_id = f.function_id

Line 10561: FROM HZ_TRANS_FUNCTIONS_VL f,

10557: FOR TX IN (
10558: SELECT a.attribute_name,
10559: f.PROCEDURE_NAME,
10560: f.STAGED_ATTRIBUTE_COLUMN
10561: FROM HZ_TRANS_FUNCTIONS_VL f,
10562: HZ_TRANS_ATTRIBUTES_VL a
10563: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10564: AND a.entity_name = 'PARTY'
10565: AND a.attribute_name='PARTY_TYPE'

Line 11893: FROM hz_trans_functions_vl f, hz_secondary_trans st,

11889: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
11890: l('');
11891: FOR TX IN (
11892: SELECT distinct f.staged_attribute_column
11893: FROM hz_trans_functions_vl f, hz_secondary_trans st,
11894: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
11895: WHERE sa.match_rule_id = p_rule_id
11896: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
11897: AND st.function_id = f.function_id

Line 12134: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12130: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
12131: l('');
12132: FOR TX IN (
12133: SELECT distinct f.staged_attribute_column
12134: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12135: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12136: WHERE sa.match_rule_id = p_rule_id
12137: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12138: AND st.function_id = f.function_id

Line 12366: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12362: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
12363: l('');
12364: FOR TX IN (
12365: SELECT distinct f.staged_attribute_column
12366: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12367: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12368: WHERE sa.match_rule_id = p_rule_id
12369: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12370: AND st.function_id = f.function_id

Line 12532: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12528: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
12529: l('');
12530: FOR TX IN (
12531: SELECT distinct f.staged_attribute_column
12532: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12533: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12534: WHERE sa.match_rule_id = p_rule_id
12535: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12536: AND st.function_id = f.function_id

Line 12622: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12618: l(' l_max_id := l_party_site_id;');
12619: l(' l_max_idx := l_match_idx;');
12620: FOR TX IN (
12621: SELECT distinct f.staged_attribute_column
12622: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12623: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12624: WHERE sa.match_rule_id = p_rule_id
12625: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12626: AND st.function_id = f.function_id

Line 12655: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12651: l(' l_max_id := l_org_contact_id;');
12652: l(' l_max_idx := l_match_idx;');
12653: FOR TX IN (
12654: SELECT distinct f.staged_attribute_column
12655: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12656: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12657: WHERE sa.match_rule_id = p_rule_id
12658: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12659: AND st.function_id = f.function_id

Line 12688: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12684: l(' l_max_id := l_contact_pt_id;');
12685: l(' l_max_idx := l_match_idx;');
12686: FOR TX IN (
12687: SELECT distinct f.staged_attribute_column
12688: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12689: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12690: WHERE sa.match_rule_id = p_rule_id
12691: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12692: AND st.function_id = f.function_id

Line 12877: FROM HZ_TRANS_FUNCTIONS_VL f,

12873: for FUNCS IN (
12874: SELECT a.ATTRIBUTE_NAME,
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

Line 12892: FROM HZ_TRANS_FUNCTIONS_VL f,

12888:
12889: SELECT a.ATTRIBUTE_NAME,
12890: f.PROCEDURE_NAME,
12891: f.STAGED_ATTRIBUTE_COLUMN
12892: FROM HZ_TRANS_FUNCTIONS_VL f,
12893: HZ_TRANS_ATTRIBUTES_VL a,
12894: HZ_MATCH_RULE_SECONDARY sattr,
12895: HZ_SECONDARY_TRANS sfunc
12896: WHERE sattr.MATCH_RULE_ID = p_rule_id

Line 12907: FROM HZ_TRANS_FUNCTIONS_VL f,

12903:
12904: SELECT a.attribute_name,
12905: f.PROCEDURE_NAME,
12906: f.STAGED_ATTRIBUTE_COLUMN
12907: FROM HZ_TRANS_FUNCTIONS_VL f,
12908: HZ_TRANS_ATTRIBUTES_VL a
12909: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
12910: AND a.entity_name = 'PARTY'
12911: AND a.attribute_name='PARTY_TYPE'

Line 13092: FROM HZ_TRANS_FUNCTIONS_VL f,

13088: for FUNCS IN (
13089: SELECT a.ATTRIBUTE_NAME,
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

Line 13107: FROM HZ_TRANS_FUNCTIONS_VL f,

13103:
13104: SELECT a.ATTRIBUTE_NAME,
13105: f.PROCEDURE_NAME,
13106: f.STAGED_ATTRIBUTE_COLUMN
13107: FROM HZ_TRANS_FUNCTIONS_VL f,
13108: HZ_TRANS_ATTRIBUTES_VL a,
13109: HZ_MATCH_RULE_SECONDARY sattr,
13110: HZ_SECONDARY_TRANS sfunc
13111: WHERE sattr.MATCH_RULE_ID = p_rule_id

Line 13208: FROM HZ_TRANS_FUNCTIONS_VL f,

13204: l('BEGIN');
13205:
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

Line 13221: FROM HZ_TRANS_FUNCTIONS_VL f,

13217:
13218: UNION
13219:
13220: SELECT a.ATTRIBUTE_ID, a.ATTRIBUTE_NAME
13221: FROM HZ_TRANS_FUNCTIONS_VL f,
13222: HZ_TRANS_ATTRIBUTES_VL a,
13223: HZ_MATCH_RULE_SECONDARY sattr,
13224: HZ_SECONDARY_TRANS sfunc
13225: WHERE sattr.MATCH_RULE_ID = p_rule_id

Line 13338: FROM HZ_TRANS_FUNCTIONS_VL f,

13334: for FUNCS IN (
13335: SELECT a.ATTRIBUTE_NAME,
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

Line 13353: FROM HZ_TRANS_FUNCTIONS_VL f,

13349:
13350: SELECT a.ATTRIBUTE_NAME,
13351: f.PROCEDURE_NAME,
13352: f.STAGED_ATTRIBUTE_COLUMN
13353: FROM HZ_TRANS_FUNCTIONS_VL f,
13354: HZ_TRANS_ATTRIBUTES_VL a,
13355: HZ_MATCH_RULE_SECONDARY sattr,
13356: HZ_SECONDARY_TRANS sfunc
13357: WHERE sattr.MATCH_RULE_ID = p_rule_id

Line 13406: FROM HZ_TRANS_FUNCTIONS_VL f,

13402: for FUNCS IN (
13403: SELECT a.ATTRIBUTE_NAME,
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

Line 13421: FROM HZ_TRANS_FUNCTIONS_VL f,

13417:
13418: SELECT a.ATTRIBUTE_NAME,
13419: f.PROCEDURE_NAME,
13420: f.STAGED_ATTRIBUTE_COLUMN
13421: FROM HZ_TRANS_FUNCTIONS_VL f,
13422: HZ_TRANS_ATTRIBUTES_VL a,
13423: HZ_MATCH_RULE_SECONDARY sattr,
13424: HZ_SECONDARY_TRANS sfunc
13425: WHERE sattr.MATCH_RULE_ID = p_rule_id

Line 13561: FROM HZ_TRANS_FUNCTIONS_VL f,

13557: for FUNCS IN (
13558: SELECT a.ATTRIBUTE_NAME,a.attribute_id,
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

Line 13576: FROM HZ_TRANS_FUNCTIONS_VL f,

13572:
13573: SELECT a.ATTRIBUTE_NAME,a.attribute_id,
13574: f.PROCEDURE_NAME,
13575: f.STAGED_ATTRIBUTE_COLUMN
13576: FROM HZ_TRANS_FUNCTIONS_VL f,
13577: HZ_TRANS_ATTRIBUTES_VL a,
13578: HZ_MATCH_RULE_SECONDARY sattr,
13579: HZ_SECONDARY_TRANS sfunc
13580: WHERE sattr.MATCH_RULE_ID = p_rule_id

Line 13591: FROM HZ_TRANS_FUNCTIONS_VL f,

13587:
13588: SELECT a.attribute_name,a.attribute_id,
13589: f.PROCEDURE_NAME,
13590: f.STAGED_ATTRIBUTE_COLUMN
13591: FROM HZ_TRANS_FUNCTIONS_VL f,
13592: HZ_TRANS_ATTRIBUTES_VL a
13593: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13594: AND a.entity_name = 'PARTY'
13595: AND a.attribute_name='PARTY_TYPE'

Line 15150: l(' SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL ');

15146:
15147: l('FUNCTION check_staged RETURN BOOLEAN IS');
15148: l('');
15149: l(' CURSOR c_check_staged IS ');
15150: l(' SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL ');
15151: l(' WHERE nvl(STAGED_FLAG,''N'') = ''N'' ');
15152: l(' AND FUNCTION_ID in (');
15153: FIRST := TRUE;
15154: IF l_rule_type <> 'SET' then ---Code Change for Match Rule Set