VIEW: APPS.IGS_PE_FUND_SOURCE_V

Source

View Text - Preformatted

SELECT FS.ROWID ROW_ID, FS.FUND_SOURCE_ID, FS.PERSON_ID, FS. FUND_SOURCE_CODE, L1.MEANING FUND_SOURCE_M, FS.NAME, FS.AMOUNT, FS.RELATIONSHIP_CODE, L2.MEANING RELATIONSHIP_M, FS.DOCUMENT_IND, FS.NOTES, FS.CREATED_BY, FS.CREATION_DATE, FS.LAST_UPDATED_BY, FS.LAST_UPDATE_DATE, FS.LAST_UPDATE_LOGIN FROM IGS_PE_FUND_SOURCE FS, IGS_LOOKUPS_VIEW L1, FND_LOOKUP_VALUES L2 WHERE FS.FUND_SOURCE_CODE = L1.LOOKUP_CODE(+) AND L1.LOOKUP_TYPE(+) = 'PE_FUND_TYPE' AND L2.LOOKUP_TYPE(+) = 'PARTY_RELATIONS_TYPE' AND FS.RELATIONSHIP_CODE = L2.LOOKUP_CODE(+) AND L2.VIEW_APPLICATION_ID(+) = 222 AND L2.LANGUAGE(+) = USERENV('LANG') AND L2.SECURITY_GROUP_ID(+) = 0

View Text - HTML Formatted

SELECT FS.ROWID ROW_ID
, FS.FUND_SOURCE_ID
, FS.PERSON_ID
, FS. FUND_SOURCE_CODE
, L1.MEANING FUND_SOURCE_M
, FS.NAME
, FS.AMOUNT
, FS.RELATIONSHIP_CODE
, L2.MEANING RELATIONSHIP_M
, FS.DOCUMENT_IND
, FS.NOTES
, FS.CREATED_BY
, FS.CREATION_DATE
, FS.LAST_UPDATED_BY
, FS.LAST_UPDATE_DATE
, FS.LAST_UPDATE_LOGIN
FROM IGS_PE_FUND_SOURCE FS
, IGS_LOOKUPS_VIEW L1
, FND_LOOKUP_VALUES L2
WHERE FS.FUND_SOURCE_CODE = L1.LOOKUP_CODE(+)
AND L1.LOOKUP_TYPE(+) = 'PE_FUND_TYPE'
AND L2.LOOKUP_TYPE(+) = 'PARTY_RELATIONS_TYPE'
AND FS.RELATIONSHIP_CODE = L2.LOOKUP_CODE(+)
AND L2.VIEW_APPLICATION_ID(+) = 222
AND L2.LANGUAGE(+) = USERENV('LANG')
AND L2.SECURITY_GROUP_ID(+) = 0