DBA Data[Home] [Help]

VIEW: APPS.AMS_DS_ORIG_SYS_REFERENCES_V

Source

View Text - Preformatted

SELECT ORIG_SYSTEM,ORIG_SYSTEM_REFERENCE,OWNER_TABLE_NAME,OWNER_TABLE_ID,STATUS FROM hz_orig_sys_references WHERE STATUS = 'A' and owner_table_name = 'HZ_PARTIES'
View Text - HTML Formatted

SELECT ORIG_SYSTEM
, ORIG_SYSTEM_REFERENCE
, OWNER_TABLE_NAME
, OWNER_TABLE_ID
, STATUS
FROM HZ_ORIG_SYS_REFERENCES
WHERE STATUS = 'A'
AND OWNER_TABLE_NAME = 'HZ_PARTIES'