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_SECONDARY_TRANS

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 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 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 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.