DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 8144: HZ_CODE_ASSIGNMENTS a,

8140: AND (nvl(RELATIONSHIP_CODE,'DUMMY')
8141: not IN ( SELECT
8142: b.FORWARD_REL_CODE
8143: FROM
8144: HZ_CODE_ASSIGNMENTS a,
8145: HZ_RELATIONSHIP_TYPES b
8146: WHERE
8147: a.owner_table_name = 'HZ_RELATIONSHIP_TYPES' and
8148: a.owner_table_id = b.RELATIONSHIP_TYPE_ID and

Line 8160: -- HZ_CODE_ASSIGNMENTS a,

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