Product: | IGI - Public Sector Financials International |
---|---|
Description: | Based on FND_USER, GL_JE_CATEGORIES_TL, IGI_ITR_CHARGE_HEADERS and IGI_LOOKUPS |
Implementation/DBA Data: | APPS.IGI_ITR_CHARGE_HEADERS_V |
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')