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_IMP_DQM_STAGE dependencies on HZ_MATCH_RULE_SECONDARY

Line 111: from hz_match_rule_secondary a

107: where entity_name = p_et_name
108: and attribute_name = p_attr_name)
109: union
110: select 'Y'
111: from hz_match_rule_secondary a
112: where match_rule_id = p_match_rule_id
113: and a.attribute_id in (
114: select attribute_id
115: from hz_trans_attributes_b

Line 975: from hz_match_rule_secondary

971: from hz_match_rule_primary
972: where match_rule_id = p_rule_id
973: union
974: select attribute_id
975: from hz_match_rule_secondary
976: where match_rule_id = p_rule_id)
977: ) LOOP
978: IF is_first THEN
979: is_first := false;

Line 1122: from hz_match_rule_secondary

1118: from hz_match_rule_primary
1119: where match_rule_id = p_rule_id
1120: union
1121: select attribute_id
1122: from hz_match_rule_secondary
1123: where match_rule_id = p_rule_id)
1124: and entity_name = p_entity_name
1125: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'
1126: and custom_attribute_procedure is null

Line 1252: from hz_match_rule_secondary g, hz_secondary_trans f

1248: where match_rule_id = p_match_rule_id
1249: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1250: union
1251: select function_id
1252: from hz_match_rule_secondary g, hz_secondary_trans f
1253: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID
1254: and match_rule_id = p_match_rule_id)
1255: order by STAGED_ATTRIBUTE_COLUMN
1256: ) LOOP

Line 1292: from hz_match_rule_secondary g, hz_secondary_trans f

1288: where match_rule_id = p_rule_id
1289: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1290: union
1291: select function_id
1292: from hz_match_rule_secondary g, hz_secondary_trans f
1293: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID
1294: and match_rule_id = p_rule_id)
1295: and nvl(active_flag, 'Y') <> 'N'
1296: and staged_attribute_table = p_entity_name

Line 1447: from hz_match_rule_secondary g, hz_secondary_trans f

1443: where match_rule_id = p_rule_id
1444: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1445: union
1446: select function_id
1447: from hz_match_rule_secondary g, hz_secondary_trans f
1448: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID
1449: and match_rule_id = p_rule_id)
1450: order by STAGED_ATTRIBUTE_COLUMN
1451: ) LOOP

Line 1485: from hz_match_rule_secondary g, hz_secondary_trans f

1481: where e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1482: and match_rule_id = p_rule_id
1483: union
1484: select function_id
1485: from hz_match_rule_secondary g, hz_secondary_trans f
1486: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID
1487: and match_rule_id = p_rule_id)
1488: and nvl(active_flag, 'Y') <> 'N'
1489: and staged_attribute_table = p_entity_name

Line 1622: from hz_match_rule_primary a, hz_match_rule_secondary b

1618: ) RETURN VARCHAR2 IS
1619:
1620: using_address VARCHAR2(1) := 'N';
1621: CURSOR c1 is select 'Y'
1622: from hz_match_rule_primary a, hz_match_rule_secondary b
1623: where a.match_rule_id = b.match_rule_id
1624: and a.match_rule_id = p_rule_id
1625: -- check if one really needs the below condition
1626: -- and a.attribute_id = b.attribute_id

Line 1655: from hz_match_rule_primary a, hz_match_rule_secondary b

1651: ) RETURN VARCHAR2 IS
1652:
1653: using_raw_ph_no VARCHAR2(1) := 'N';
1654: CURSOR c1 is select 'Y'
1655: from hz_match_rule_primary a, hz_match_rule_secondary b
1656: where a.match_rule_id = b.match_rule_id
1657: and a.match_rule_id = p_rule_id
1658: -- check if one really needs the below condition
1659: -- and a.attribute_id = b.attribute_id

Line 1688: from hz_match_rule_primary a, hz_match_rule_secondary b

1684: ) RETURN VARCHAR2 IS
1685:
1686: using_contact_name VARCHAR2(1) := 'N';
1687: CURSOR c1 is select 'Y'
1688: from hz_match_rule_primary a, hz_match_rule_secondary b
1689: where a.match_rule_id = b.match_rule_id
1690: and a.match_rule_id = p_rule_id
1691: -- check if one really needs the below condition
1692: -- and a.attribute_id = b.attribute_id

Line 1720: from hz_match_rule_primary a, hz_match_rule_secondary b

1716: ) RETURN VARCHAR2 IS
1717:
1718: using_contact_name VARCHAR2(1) := 'N';
1719: CURSOR c1 is select 'Y'
1720: from hz_match_rule_primary a, hz_match_rule_secondary b
1721: where a.match_rule_id = b.match_rule_id
1722: and a.match_rule_id = p_rule_id
1723: and a.attribute_id = b.attribute_id
1724: and a.attribute_id in (

Line 1765: from hz_match_rule_secondary f, hz_secondary_trans g

1761: where match_rule_id = p_rule_id
1762: and d.primary_attribute_id = e.primary_attribute_id
1763: union
1764: select function_id
1765: from hz_match_rule_secondary f, hz_secondary_trans g
1766: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID -- b.attribute_id = c.attribute_id
1767: and match_rule_id = p_rule_id)
1768: and nvl(active_flag, 'Y') <> 'N'
1769: and entity_name = p_et_name

Line 1814: from hz_match_rule_secondary f, hz_secondary_trans g

1810: where match_rule_id = p_rule_id
1811: and d.primary_attribute_id = e.primary_attribute_id
1812: union
1813: select function_id
1814: from hz_match_rule_secondary f, hz_secondary_trans g
1815: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID -- b.attribute_id = c.attribute_id
1816: and match_rule_id = p_rule_id)
1817: and nvl(active_flag, 'Y') <> 'N'
1818: and entity_name = p_entity_name

Line 1859: from hz_match_rule_secondary f, hz_secondary_trans g

1855: where match_rule_id = p_rule_id
1856: and d.primary_attribute_id = e.primary_attribute_id
1857: union
1858: select function_id
1859: from hz_match_rule_secondary f, hz_secondary_trans g
1860: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID -- b.attribute_id = c.attribute_id
1861: and match_rule_id = p_rule_id)
1862: and nvl(active_flag, 'Y') <> 'N'
1863: and entity_name = p_entity_name

Line 2675: l(' from hz_match_rule_secondary b ');

2671: l(' from hz_match_rule_primary b ');
2672: l(' where match_rule_id = '|| p_rule_id);
2673: l(' union ');
2674: l(' select attribute_id ');
2675: l(' from hz_match_rule_secondary b ');
2676: l(' where match_rule_id = '|| p_rule_id ||' ) and rownum = 1; ');
2677: l(' ');
2678: l(' BEGIN ');
2679: x_bool := 'N';

Line 2815: l(' from hz_match_rule_secondary b ');

2811: l(' from hz_match_rule_primary b ');
2812: l(' where match_rule_id = '|| p_rule_id);
2813: l(' union ');
2814: l(' select attribute_id ');
2815: l(' from hz_match_rule_secondary b ');
2816: l(' where match_rule_id = '|| p_rule_id ||' ) and rownum = 1; ');
2817: l(' ');
2818: l(' l_os VARCHAR2(30); ');
2819: l(' BEGIN --');

Line 3495: from hz_match_rule_secondary

3491: union
3492: select STAGED_ATTRIBUTE_COLUMN
3493: from hz_trans_functions_b
3494: where attribute_id in (select attribute_id
3495: from hz_match_rule_secondary
3496: where match_rule_id = p_rule_id)
3497: order by STAGED_ATTRIBUTE_COLUMN
3498: ) LOOP
3499: l( ' H_' || TX.STAGED_ATTRIBUTE_COLUMN || ' CharList2000;');

Line 3511: from hz_match_rule_secondary

3507: from hz_match_rule_primary
3508: where match_rule_id = p_rule_id
3509: union
3510: select attribute_id
3511: from hz_match_rule_secondary
3512: where match_rule_id = p_rule_id)
3513: and custom_attribute_procedure is null
3514: ) LOOP
3515: l( ' H_' || TX2.attribute_id || 'E CharList2000;');

Line 3537: from hz_match_rule_secondary g, hz_secondary_trans f

3533: where match_rule_id = p_rule_id
3534: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
3535: union
3536: select function_id
3537: from hz_match_rule_secondary g, hz_secondary_trans f
3538: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID
3539: and match_rule_id = p_rule_id)
3540: order by STAGED_ATTRIBUTE_COLUMN ) LOOP
3541: -- l( ' H_' || TX.STAGED_ATTRIBUTE_COLUMN || ' CharList2000;');

Line 3570: from hz_match_rule_secondary g, hz_secondary_trans f

3566: where match_rule_id = p_rule_id
3567: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
3568: union
3569: select function_id
3570: from hz_match_rule_secondary g, hz_secondary_trans f
3571: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID
3572: and match_rule_id = p_rule_id)
3573: order by STAGED_ATTRIBUTE_COLUMN ) LOOP
3574: -- l( ' H_' || TX.STAGED_ATTRIBUTE_COLUMN || ' CharList2000;');

Line 3596: from hz_match_rule_secondary g, hz_secondary_trans f

3592: where match_rule_id = p_rule_id
3593: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
3594: union
3595: select function_id
3596: from hz_match_rule_secondary g, hz_secondary_trans f
3597: where f.SECONDARY_ATTRIBUTE_ID = g.SECONDARY_ATTRIBUTE_ID
3598: and match_rule_id = p_rule_id)
3599: order by STAGED_ATTRIBUTE_COLUMN ) LOOP
3600: -- l( ' H_' || TX.STAGED_ATTRIBUTE_COLUMN || ' CharList2000;');

Line 3680: from hz_match_rule_secondary

3676: from hz_match_rule_primary
3677: where match_rule_id = p_rule_id
3678: union
3679: select attribute_id
3680: from hz_match_rule_secondary
3681: where match_rule_id = p_rule_id);
3682: END IF;
3683: EXCEPTION
3684: WHEN OTHERS THEN

Line 3816: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f

3812: --AND userenv('LANG') = 'US'
3813: AND nvl(f.ACTIVE_FLAG,'Y') = 'N'
3814: UNION
3815: SELECT 1
3816: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f
3817: WHERE s.match_rule_id = p_rule_id
3818: AND pt.SECONDARY_ATTRIBUTE_ID = s.SECONDARY_ATTRIBUTE_ID
3819: AND f.function_id = pt.function_id
3820: --Fix for bug 4669257. Removing the hardcoded reference below.