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.AMS_LISTIMPORT_PVT dependencies on HZ_RELATIONSHIP_TYPES

Line 8146: HZ_RELATIONSHIP_TYPES b

8142: not IN ( SELECT
8143: b.FORWARD_REL_CODE
8144: FROM
8145: HZ_CODE_ASSIGNMENTS a,
8146: HZ_RELATIONSHIP_TYPES b
8147: WHERE
8148: a.owner_table_name = 'HZ_RELATIONSHIP_TYPES' and
8149: a.owner_table_id = b.RELATIONSHIP_TYPE_ID and
8150: a.class_code= 'PARTY_REL_GRP_CONTACTS' and

Line 8148: a.owner_table_name = 'HZ_RELATIONSHIP_TYPES' and

8144: FROM
8145: HZ_CODE_ASSIGNMENTS a,
8146: HZ_RELATIONSHIP_TYPES b
8147: WHERE
8148: a.owner_table_name = 'HZ_RELATIONSHIP_TYPES' and
8149: a.owner_table_id = b.RELATIONSHIP_TYPE_ID and
8150: a.class_code= 'PARTY_REL_GRP_CONTACTS' and
8151: b.subject_type = 'PERSON' and
8152: b.object_type = 'ORGANIZATION' and

Line 8162: -- HZ_RELATIONSHIP_TYPES b

8158: -- not IN ( SELECT
8159: -- b.RELATIONSHIP_TYPE
8160: -- FROM
8161: -- HZ_CODE_ASSIGNMENTS a,
8162: -- HZ_RELATIONSHIP_TYPES b
8163: -- WHERE
8164: -- a.owner_table_name = 'HZ_RELATIONSHIP_TYPES' and
8165: -- a.owner_table_id = b.RELATIONSHIP_TYPE_ID and
8166: -- a.class_code= 'PARTY_REL_GRP_CONTACTS' and

Line 8164: -- a.owner_table_name = 'HZ_RELATIONSHIP_TYPES' and

8160: -- FROM
8161: -- HZ_CODE_ASSIGNMENTS a,
8162: -- HZ_RELATIONSHIP_TYPES b
8163: -- WHERE
8164: -- a.owner_table_name = 'HZ_RELATIONSHIP_TYPES' and
8165: -- a.owner_table_id = b.RELATIONSHIP_TYPE_ID and
8166: -- a.class_code= 'PARTY_REL_GRP_CONTACTS' and
8167: -- b.subject_type = 'PERSON' and
8168: -- b.object_type = 'ORGANIZATION' and