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

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
3496: IF FIRST1 THEN

Line 3589: HZ_PRIMARY_TRANS pfunc

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'
3593: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 3738: HZ_PRIMARY_TRANS pt

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
3742: l(' l_sqlstr := l_sqlstr || '' ('||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||' like :'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||'||'''' %'''' '';');

Line 3773: HZ_PRIMARY_TRANS pt

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
3777: l(' l_sqlstr := l_sqlstr || '' ('||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||' like :'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||'||'''' %'''' '';');

Line 3810: HZ_PRIMARY_TRANS pt

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
3814: l(' l_sqlstr := l_sqlstr || '' (D_PS like ''''% ''''||:'||DENTRANS.STAGED_ATTRIBUTE_COLUMN||'||'''' %'''' '';');

Line 9132: HZ_PRIMARY_TRANS pt

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
9136: IF FIRST1 THEN

Line 9176: HZ_PRIMARY_TRANS pfunc

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'
9180: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 12880: HZ_PRIMARY_TRANS pfunc

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'
12884: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13095: HZ_PRIMARY_TRANS pfunc

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
13099: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13211: HZ_PRIMARY_TRANS pfunc

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
13215: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13341: HZ_PRIMARY_TRANS pfunc

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
13345: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13409: HZ_PRIMARY_TRANS pfunc

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
13413: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

Line 13564: HZ_PRIMARY_TRANS pfunc

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'
13568: AND pattr.PRIMARY_ATTRIBUTE_ID = pfunc.PRIMARY_ATTRIBUTE_ID

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