VIEW: APPS.IGI_ITR_CHARGE_HEADERS_V

Source

View Text - Preformatted

SELECT HEADER.ROWID ROW_ID, HEADER.NAME NAME, LOOKUPS.MEANING SUBMIT_DESC, HEADER.DESCRIPTION DESCRIPTION, FU.USER_NAME ORIGINATOR_NAME, HEADER.IT_PERIOD_NAME IT_PERIOD_NAME, HEADER.IT_HEADER_ID IT_HEADER_ID, HEADER.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, HEADER.CODE_COMBINATION_ID CODE_COMBINATION_ID, HEADER.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, HEADER.SUBMIT_FLAG SUBMIT_FLAG, HEADER.IT_ORIGINATOR_ID IT_ORIGINATOR_ID, HEADER.IT_CATEGORY IT_CATEGORY, GJC.USER_JE_CATEGORY_NAME CATEGORY_DISPLAY, HEADER.IT_SOURCE IT_SOURCE, HEADER.GL_DATE GL_DATE, HEADER.SUBMIT_DATE SUBMIT_DATE, HEADER.CURRENCY_CODE CURRENCY_CODE, HEADER.ENTERED_DR ENTERED_DR, HEADER.ENTERED_CR ENTERED_CR, HEADER.CREATION_DATE CREATION_DATE, HEADER.CREATED_BY CREATED_BY, HEADER.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HEADER.LAST_UPDATE_DATE LAST_UPDATE_DATE, HEADER.LAST_UPDATED_BY LAST_UPDATED_BY FROM FND_USER FU, GL_JE_CATEGORIES_TL GJC, IGI_ITR_CHARGE_HEADERS HEADER, IGI_LOOKUPS LOOKUPS WHERE LOOKUPS.LOOKUP_CODE = HEADER.SUBMIT_FLAG AND LOOKUPS.LOOKUP_TYPE = 'ITR_SUBMIT' AND FU.USER_ID = HEADER.IT_ORIGINATOR_ID AND GJC.JE_CATEGORY_NAME = HEADER.IT_CATEGORY AND GJC.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT HEADER.ROWID ROW_ID
, HEADER.NAME NAME
, LOOKUPS.MEANING SUBMIT_DESC
, HEADER.DESCRIPTION DESCRIPTION
, FU.USER_NAME ORIGINATOR_NAME
, HEADER.IT_PERIOD_NAME IT_PERIOD_NAME
, HEADER.IT_HEADER_ID IT_HEADER_ID
, HEADER.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, HEADER.CODE_COMBINATION_ID CODE_COMBINATION_ID
, HEADER.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, HEADER.SUBMIT_FLAG SUBMIT_FLAG
, HEADER.IT_ORIGINATOR_ID IT_ORIGINATOR_ID
, HEADER.IT_CATEGORY IT_CATEGORY
, GJC.USER_JE_CATEGORY_NAME CATEGORY_DISPLAY
, HEADER.IT_SOURCE IT_SOURCE
, HEADER.GL_DATE GL_DATE
, HEADER.SUBMIT_DATE SUBMIT_DATE
, HEADER.CURRENCY_CODE CURRENCY_CODE
, HEADER.ENTERED_DR ENTERED_DR
, HEADER.ENTERED_CR ENTERED_CR
, HEADER.CREATION_DATE CREATION_DATE
, HEADER.CREATED_BY CREATED_BY
, HEADER.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HEADER.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HEADER.LAST_UPDATED_BY LAST_UPDATED_BY
FROM FND_USER FU
, GL_JE_CATEGORIES_TL GJC
, IGI_ITR_CHARGE_HEADERS HEADER
, IGI_LOOKUPS LOOKUPS
WHERE LOOKUPS.LOOKUP_CODE = HEADER.SUBMIT_FLAG
AND LOOKUPS.LOOKUP_TYPE = 'ITR_SUBMIT'
AND FU.USER_ID = HEADER.IT_ORIGINATOR_ID
AND GJC.JE_CATEGORY_NAME = HEADER.IT_CATEGORY
AND GJC.LANGUAGE = USERENV('LANG')