VIEW: APPS.IGI_ITR_CHARGE_HEADERS_SS_V

Source

View Text - Preformatted

SELECT HEADER.ROWID ROW_ID, HEADER.IT_HEADER_ID IT_HEADER_ID,HEADER.NAME NAME, HEADER.SET_OF_BOOKS_ID SET_OF_BOOKS_ID,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,GLL.NAME LEDGER_NAME FROM IGI_ITR_CHARGE_CENTER CENT, IGI_ITR_CHARGE_HEADERS HEADER, IGI_LOOKUPS LOOKUPS, FND_USER FND, GL_LEDGERS gll 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 AND CENT.SET_OF_BOOKS_ID = GLL.LEDGER_ID AND HEADER.SET_OF_BOOKS_ID = GLL.LEDGER_ID

View Text - HTML Formatted

SELECT HEADER.ROWID ROW_ID
, HEADER.IT_HEADER_ID IT_HEADER_ID
, HEADER.NAME NAME
, HEADER.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, 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
, GLL.NAME LEDGER_NAME
FROM IGI_ITR_CHARGE_CENTER CENT
, IGI_ITR_CHARGE_HEADERS HEADER
, IGI_LOOKUPS LOOKUPS
, FND_USER FND
, GL_LEDGERS GLL
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
AND CENT.SET_OF_BOOKS_ID = GLL.LEDGER_ID
AND HEADER.SET_OF_BOOKS_ID = GLL.LEDGER_ID