DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 8145: HZ_CODE_ASSIGNMENTS a,

8141: AND (nvl(RELATIONSHIP_CODE,'DUMMY')
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

Line 8161: -- HZ_CODE_ASSIGNMENTS a,

8157: --OR RELATIONSHIP_TYPE
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