Product: | IGI - Public Sector Financials International |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGI_ITR_CHARGE_HEADERS_SS_V |
SELECT HEADER.ROWID ROW_ID
, HEADER.IT_HEADER_ID IT_HEADER_ID
, HEADER.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, HEADER.NAME NAME
, LOOKUPS.MEANING SUBMIT_DESC
, HEADER.IT_PERIOD_NAME IT_PERIOD_NAME
, HEADER.SUBMIT_FLAG SUBMIT_FLAG
, HEADER.IT_ORIGINATOR_ID IT_ORIGINATOR_ID
, FND.USER_NAME ORIGINATOR_NAME
, HEADER.GL_DATE GL_DATE
, HEADER.CURRENCY_CODE CURRENCY_CODE
, HEADER.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, HEADER.EMPLOYEE_ID EMPLOYEE_ID
, HEADER.CREATION_DATE CREATION_DATE
, HEADER.CREATED_BY CREATED_BY
, HEADER.ENTERED_DR TOTAL_DR
, HEADER.ENTERED_CR TOTAL_CR
, HEADER.SUBMIT_DATE SUBMIT_DATE
, HEADER.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HEADER.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HEADER.LAST_UPDATED_BY LAST_UPDATED_BY
, HEADER.CHARGE_CENTER_ID CHARGE_CENTER_ID
, CENT.NAME CHARGE_CENTER
FROM IGI_ITR_CHARGE_CENTER CENT
, IGI_ITR_CHARGE_HEADERS HEADER
, IGI_LOOKUPS LOOKUPS
, FND_USER FND
WHERE CENT.CHARGE_CENTER_ID=HEADER.CHARGE_CENTER_ID
AND LOOKUPS.LOOKUP_CODE = HEADER.SUBMIT_FLAG
AND LOOKUPS.LOOKUP_TYPE = 'ITR_CHARGE_STATUS'
AND FND.USER_ID = HEADER.IT_ORIGINATOR_ID