View: GL_INTERCOMPANY_ACCTS_V

View Text

SELECT INT.ROWID ROW_ID
, INT.JE_SOURCE_NAME JE_SOURCE_NAME
, SRC.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, INT.JE_CATEGORY_NAME JE_CATEGORY_NAME
, CAT.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, INT.DR_CR_CODE DR_CR_CODE
, INT.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, LOOK.DESCRIPTION TYPE
FROM GL_JE_CATEGORIES CAT
, GL_JE_SOURCES SRC
, GL_INTERCOMPANY_ACCOUNTS INT
, GL_LOOKUPS LOOK
WHERE INT.JE_SOURCE_NAME = SRC.JE_SOURCE_NAME
AND INT.JE_CATEGORY_NAME = CAT.JE_CATEGORY_NAME
AND INT.DR_CR_CODE = LOOK.LOOKUP_CODE
AND LOOK.LOOKUP_TYPE = 'DR_CR'

Columns