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_PRIMARY

Line 102: from hz_match_rule_primary a

98: ) RETURN VARCHAR2
99: IS
100: using_allow_cust VARCHAR2(1) := 'N';
101: CURSOR c1 is select 'Y'
102: from hz_match_rule_primary a
103: where match_rule_id = p_match_rule_id
104: and a.attribute_id in (
105: select attribute_id
106: from hz_trans_attributes_b

Line 971: from hz_match_rule_primary

967: and custom_attribute_procedure is null
968: /* and attribute_name not in
969: ('SIC_CODE', 'SIC_CODE_TYPE', 'TAX_NAME', 'CATEGORY_CODE', 'IDENTIFYING_ADDRESS_FLAG', 'STATUS', 'PRIMARY_FLAG', 'REFERENCE_USE_FLAG' ) */
970: and attribute_id in ( select attribute_id
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

Line 1118: from hz_match_rule_primary

1114: END IF;
1115: FOR TX IN ( select attribute_id || 'E' as STAGED_ATTRIBUTE_COLUMN
1116: from hz_trans_attributes_b
1117: where attribute_id in (select attribute_id
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

Line 1247: from hz_match_rule_primary e, hz_primary_trans d

1243: from hz_trans_attributes_b
1244: where attribute_name = p_attr_name
1245: and entity_name = p_entity_name)
1246: and function_id in (select function_id
1247: from hz_match_rule_primary e, hz_primary_trans d
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

Line 1287: from hz_match_rule_primary e, hz_primary_trans d

1283: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1284: from hz_trans_functions_b
1285: where function_id in
1286: (select function_id
1287: from hz_match_rule_primary e, hz_primary_trans d
1288: where match_rule_id = p_rule_id
1289: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1290: union
1291: select function_id

Line 1442: from hz_match_rule_primary e, hz_primary_trans d

1438: from hz_trans_attributes_b
1439: where attribute_name = p_attr_name
1440: and entity_name = p_entity_name)
1441: and function_id in (select function_id
1442: from hz_match_rule_primary e, hz_primary_trans d
1443: where match_rule_id = p_rule_id
1444: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1445: union
1446: select function_id

Line 1480: from hz_match_rule_primary e, hz_primary_trans d

1476: END IF;
1477: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1478: from hz_trans_functions_b
1479: where function_id in (select function_id
1480: from hz_match_rule_primary e, hz_primary_trans d
1481: where e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1482: and match_rule_id = p_rule_id
1483: union
1484: select function_id

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 1760: from hz_match_rule_primary d, hz_primary_trans e

1756: where b.attribute_id = c.attribute_id
1757: --Fix for bug 4669257. Removing the hardcoded reference below.
1758: --and userenv('LANG') = 'US'
1759: and b.function_id in (select function_id
1760: from hz_match_rule_primary d, hz_primary_trans e
1761: where match_rule_id = p_rule_id
1762: and d.primary_attribute_id = e.primary_attribute_id
1763: union
1764: select function_id

Line 1809: from hz_match_rule_primary d, hz_primary_trans e

1805: --Fix for bug 4669257. Removing the hardcoded reference below.
1806: --and userenv('LANG') = 'US'
1807: and b.function_id in
1808: (select function_id
1809: from hz_match_rule_primary d, hz_primary_trans e
1810: where match_rule_id = p_rule_id
1811: and d.primary_attribute_id = e.primary_attribute_id
1812: union
1813: select function_id

Line 1854: from hz_match_rule_primary d, hz_primary_trans e

1850: --Fix for bug 4669257. Removing the hardcoded reference below.
1851: --and userenv('LANG') = 'US'
1852: and b.function_id in
1853: (select function_id
1854: from hz_match_rule_primary d, hz_primary_trans e
1855: where match_rule_id = p_rule_id
1856: and d.primary_attribute_id = e.primary_attribute_id
1857: union
1858: select function_id

Line 2671: l(' from hz_match_rule_primary b ');

2667: -- l(' and userenv(''LANG'') = ''US'' ');
2668: l(' and attribute_name = ''CONTACT_NAME'' ');
2669: l(' and attribute_id in ( ');
2670: l(' select attribute_id ');
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 ');

Line 2811: l(' from hz_match_rule_primary b ');

2807: -- l(' and userenv(''LANG'') = ''US'' ');
2808: l(' and attribute_name = ''CONTACT_NAME'' ');
2809: l(' and attribute_id in ( ');
2810: l(' select attribute_id ');
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 ');

Line 3489: from hz_match_rule_primary

3485:
3486: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
3487: from hz_trans_functions_b
3488: where attribute_id in (select attribute_id
3489: from hz_match_rule_primary
3490: where match_rule_id = p_rule_id)
3491: union
3492: select STAGED_ATTRIBUTE_COLUMN
3493: from hz_trans_functions_b

Line 3507: from hz_match_rule_primary

3503: from hz_trans_attributes_vl
3504: --Fix for bug 4669257. Removing the hardcoded reference below.
3505: -- where userenv('LANG') = 'US'
3506: where attribute_id in (select attribute_id
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

Line 3532: from hz_match_rule_primary e, hz_primary_trans d

3528: from hz_trans_attributes_b
3529: where attribute_name = 'CONTACT_NAME'
3530: and entity_name = 'CONTACTS')
3531: and function_id in (select function_id
3532: from hz_match_rule_primary e, hz_primary_trans d
3533: where match_rule_id = p_rule_id
3534: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
3535: union
3536: select function_id

Line 3565: from hz_match_rule_primary e, hz_primary_trans d

3561: from hz_trans_attributes_b
3562: where attribute_name = 'RAW_PHONE_NUMBER'
3563: and entity_name = 'CONTACT_POINTS')
3564: and function_id in (select function_id
3565: from hz_match_rule_primary e, hz_primary_trans d
3566: where match_rule_id = p_rule_id
3567: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
3568: union
3569: select function_id

Line 3591: from hz_match_rule_primary e, hz_primary_trans d

3587: from hz_trans_attributes_b
3588: where attribute_name = 'ADDRESS'
3589: and entity_name = 'PARTY_SITES')
3590: and function_id in (select function_id
3591: from hz_match_rule_primary e, hz_primary_trans d
3592: where match_rule_id = p_rule_id
3593: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
3594: union
3595: select function_id

Line 3679: from hz_match_rule_primary

3675: and custom_attribute_procedure is null
3676: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'
3677: -- and attribute_name not in ('SIC_CODE', 'SIC_CODE_TYPE', 'TAX_NAME', 'CATEGORY_CODE', 'IDENTIFYING_ADDRESS_FLAG', 'STATUS', 'PRIMARY_FLAG', 'REFERENCE_USE_FLAG' )
3678: and attribute_id in ( select attribute_id
3679: from hz_match_rule_primary
3680: where match_rule_id = p_rule_id
3681: union
3682: select attribute_id
3683: from hz_match_rule_secondary

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

3806: ) IS
3807:
3808: CURSOR check_inactive IS
3809: SELECT 1
3810: FROM hz_match_rule_primary p, hz_primary_trans pt, hz_trans_functions_vl f
3811: WHERE p.match_rule_id = p_rule_id
3812: AND pt.PRIMARY_ATTRIBUTE_ID = p.PRIMARY_ATTRIBUTE_ID
3813: AND f.function_id = pt.function_id
3814: --Fix for bug 4669257. Removing the hardcoded reference below.