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_PRIMARY_TRANS

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 2737: HZ_PRIMARY_TRANS pt

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
2741:

Line 3485: HZ_PRIMARY_TRANS pt

3481: l(' l_prim_temp := null;');
3482: FOR PRIMTRANS IN (
3483: SELECT f.STAGED_ATTRIBUTE_COLUMN, f.TRANSFORMATION_NAME, nvl(f.PRIMARY_FLAG,'N') PRIMARY_FLAG, f.PROCEDURE_NAME
3484: FROM HZ_TRANS_FUNCTIONS_VL f,
3485: HZ_PRIMARY_TRANS pt
3486: WHERE pt.PRIMARY_ATTRIBUTE_ID = PRIMATTRS.PRIMARY_ATTRIBUTE_ID
3487: AND pt.FUNCTION_ID = f.FUNCTION_ID)
3488: LOOP
3489: IF FIRST1 THEN

Line 3582: HZ_PRIMARY_TRANS pfunc

3578: SELECT f.STAGED_ATTRIBUTE_COLUMN
3579: FROM HZ_TRANS_FUNCTIONS_VL f,
3580: HZ_TRANS_ATTRIBUTES_VL a,
3581: HZ_MATCH_RULE_PRIMARY pattr,
3582: HZ_PRIMARY_TRANS pfunc
3583: WHERE pattr.MATCH_RULE_ID = p_rule_id
3584: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3585: AND a.ENTITY_NAME = 'PARTY'
3586: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 3731: HZ_PRIMARY_TRANS pt

3727: FIRST1 := TRUE;
3728: FOR PRIMTRANS IN (
3729: SELECT f.STAGED_ATTRIBUTE_COLUMN
3730: FROM HZ_TRANS_FUNCTIONS_VL f,
3731: HZ_PRIMARY_TRANS pt
3732: WHERE pt.PRIMARY_ATTRIBUTE_ID = PATTRS.PRIMARY_ATTRIBUTE_ID
3733: AND pt.FUNCTION_ID = f.FUNCTION_ID) LOOP
3734: IF FIRST1 THEN
3735: l(' l_sqlstr := l_sqlstr || '' ('||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||' like :'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||'||'''' %'''' '';');

Line 3766: HZ_PRIMARY_TRANS pt

3762: FIRST1 := TRUE;
3763: FOR PRIMTRANS IN (
3764: SELECT f.STAGED_ATTRIBUTE_COLUMN
3765: FROM HZ_TRANS_FUNCTIONS_VL f,
3766: HZ_PRIMARY_TRANS pt
3767: WHERE pt.PRIMARY_ATTRIBUTE_ID = PATTRS.PRIMARY_ATTRIBUTE_ID
3768: AND pt.FUNCTION_ID = f.FUNCTION_ID) LOOP
3769: IF FIRST1 THEN
3770: l(' l_sqlstr := l_sqlstr || '' ('||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||' like :'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||'||'''' %'''' '';');

Line 3803: HZ_PRIMARY_TRANS pt

3799: FIRST1 := TRUE;
3800: FOR DENTRANS IN (
3801: SELECT f.STAGED_ATTRIBUTE_COLUMN
3802: FROM HZ_TRANS_FUNCTIONS_VL f,
3803: HZ_PRIMARY_TRANS pt
3804: WHERE pt.PRIMARY_ATTRIBUTE_ID = DENATTR.PRIMARY_ATTRIBUTE_ID
3805: AND pt.FUNCTION_ID = f.FUNCTION_ID) LOOP
3806: IF FIRST1 THEN
3807: l(' l_sqlstr := l_sqlstr || '' (D_PS like ''''% ''''||:'||DENTRANS.STAGED_ATTRIBUTE_COLUMN||'||'''' %'''' '';');

Line 9086: HZ_PRIMARY_TRANS pt

9082: FIRST1 := TRUE;
9083: FOR PRIMTRANS IN (
9084: SELECT f.STAGED_ATTRIBUTE_COLUMN, f.TRANSFORMATION_NAME, nvl(f.PRIMARY_FLAG,'N') PRIMARY_FLAG
9085: FROM HZ_TRANS_FUNCTIONS_VL f,
9086: HZ_PRIMARY_TRANS pt
9087: WHERE pt.PRIMARY_ATTRIBUTE_ID = PRIMATTRS.PRIMARY_ATTRIBUTE_ID
9088: AND pt.FUNCTION_ID = f.FUNCTION_ID)
9089: LOOP
9090: IF FIRST1 THEN

Line 9130: HZ_PRIMARY_TRANS pfunc

9126: SELECT f.STAGED_ATTRIBUTE_COLUMN
9127: FROM HZ_TRANS_FUNCTIONS_VL f,
9128: HZ_TRANS_ATTRIBUTES_VL a,
9129: HZ_MATCH_RULE_PRIMARY pattr,
9130: HZ_PRIMARY_TRANS pfunc
9131: WHERE pattr.MATCH_RULE_ID = p_rule_id
9132: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9133: AND a.ENTITY_NAME = 'PARTY'
9134: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 12824: HZ_PRIMARY_TRANS pfunc

12820: f.STAGED_ATTRIBUTE_COLUMN
12821: FROM HZ_TRANS_FUNCTIONS_VL f,
12822: HZ_TRANS_ATTRIBUTES_VL a,
12823: HZ_MATCH_RULE_PRIMARY pattr,
12824: HZ_PRIMARY_TRANS pfunc
12825: WHERE pattr.MATCH_RULE_ID = p_rule_id
12826: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
12827: AND a.ENTITY_NAME = 'PARTY'
12828: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13039: HZ_PRIMARY_TRANS pfunc

13035: f.STAGED_ATTRIBUTE_COLUMN
13036: FROM HZ_TRANS_FUNCTIONS_VL f,
13037: HZ_TRANS_ATTRIBUTES_VL a,
13038: HZ_MATCH_RULE_PRIMARY pattr,
13039: HZ_PRIMARY_TRANS pfunc
13040: WHERE pattr.MATCH_RULE_ID = p_rule_id
13041: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13042: AND a.ENTITY_NAME = p_entity
13043: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13155: HZ_PRIMARY_TRANS pfunc

13151: SELECT a.ATTRIBUTE_ID, a.ATTRIBUTE_NAME
13152: FROM HZ_TRANS_FUNCTIONS_VL f,
13153: HZ_TRANS_ATTRIBUTES_VL a,
13154: HZ_MATCH_RULE_PRIMARY pattr,
13155: HZ_PRIMARY_TRANS pfunc
13156: WHERE pattr.MATCH_RULE_ID = p_rule_id
13157: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13158: AND a.ENTITY_NAME = p_entity
13159: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13285: HZ_PRIMARY_TRANS pfunc

13281: f.STAGED_ATTRIBUTE_COLUMN
13282: FROM HZ_TRANS_FUNCTIONS_VL f,
13283: HZ_TRANS_ATTRIBUTES_VL a,
13284: HZ_MATCH_RULE_PRIMARY pattr,
13285: HZ_PRIMARY_TRANS pfunc
13286: WHERE pattr.MATCH_RULE_ID = p_rule_id
13287: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13288: AND a.ENTITY_NAME = p_entity
13289: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13353: HZ_PRIMARY_TRANS pfunc

13349: f.STAGED_ATTRIBUTE_COLUMN
13350: FROM HZ_TRANS_FUNCTIONS_VL f,
13351: HZ_TRANS_ATTRIBUTES_VL a,
13352: HZ_MATCH_RULE_PRIMARY pattr,
13353: HZ_PRIMARY_TRANS pfunc
13354: WHERE pattr.MATCH_RULE_ID = p_rule_id
13355: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13356: AND a.ENTITY_NAME = p_entity
13357: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13508: HZ_PRIMARY_TRANS pfunc

13504: f.STAGED_ATTRIBUTE_COLUMN
13505: FROM HZ_TRANS_FUNCTIONS_VL f,
13506: HZ_TRANS_ATTRIBUTES_VL a,
13507: HZ_MATCH_RULE_PRIMARY pattr,
13508: HZ_PRIMARY_TRANS pfunc
13509: WHERE pattr.MATCH_RULE_ID = p_rule_id
13510: AND pattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13511: AND a.ENTITY_NAME = 'PARTY'
13512: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 15049: FROM hz_primary_trans f, hz_match_rule_primary a

15045: ) IS
15046:
15047: CURSOR c_trans_func IS
15048: SELECT f.FUNCTION_ID
15049: FROM hz_primary_trans f, hz_match_rule_primary a
15050: WHERE a.MATCH_RULE_ID = p_rule_id
15051: AND a.PRIMARY_ATTRIBUTE_ID = f.PRIMARY_ATTRIBUTE_ID
15052:
15053: UNION

Line 15063: FROM hz_primary_trans f, hz_match_rule_primary a

15059:
15060: ---Start of Code Change for Match Rule Set
15061: CURSOR c_ruleset_trans_func IS
15062: SELECT f.FUNCTION_ID
15063: FROM hz_primary_trans f, hz_match_rule_primary a
15064: WHERE a.MATCH_RULE_ID IN (SELECT UNIQUE CONDITION_MATCH_RULE_ID
15065: FROM HZ_MATCH_RULE_CONDITIONS
15066: WHERE MATCH_RULE_SET_ID = p_rule_id
15067: )