VIEW: APPS.IGI_ITR_CH_LINES_APP_V

Source

View Text - Preformatted

SELECT LINES.ROWID ROW_ID, LINES.STATUS_FLAG STATUS_FLAG, LINES.IT_LINE_NUM IT_LINE_NUM, FU.USER_NAME ORIGINATOR_NAME, HEADER.NAME HEADER_NAME, LINES.DESCRIPTION DESCRIPTION, CC.NAME CHARGE_CENTER, LINES.REJECTION_NOTE REJECTION_NOTE, LINES.POSTING_FLAG POSTING_FLAG, LINES.SUGGESTED_AMOUNT SUGGESTED_AMOUNT, LINES.ENTERED_DR ENTERED_DR, LINES.ENTERED_CR ENTERED_CR, LINES.IT_HEADER_ID IT_HEADER_ID, LINES.CHARGE_CENTER_ID CHARGE_CENTER_ID, HEADER.CURRENCY_CODE CURRENCY_CODE, HEADER.IT_ORIGINATOR_ID IT_ORIGINATOR_ID, LINES.CODE_COMBINATION_ID CODE_COMBINATION_ID, LINES.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, /*DECODE(LINES.POSTING_FLAG,'','',JL.MEANING) POSTING_FLAG_DSP, */ LINES.SUBMIT_DATE SUBMIT_DATE, LINES.EFFECTIVE_DATE EFFECTIVE_DATE, LINES.CREATION_DATE CREATION_DATE, LINES.CREATED_BY CREATED_BY, LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE, LINES.LAST_UPDATED_BY LAST_UPDATED_BY FROM FND_USER FU, IGI_ITR_CHARGE_CENTER CC, IGI_ITR_CHARGE_HEADERS HEADER, IGI_ITR_CHARGE_LINES LINES WHERE HEADER.IT_HEADER_ID = LINES.IT_HEADER_ID AND CC.CHARGE_CENTER_ID = LINES.CHARGE_CENTER_ID AND FU.USER_ID = HEADER.IT_ORIGINATOR_ID

View Text - HTML Formatted

SELECT LINES.ROWID ROW_ID
, LINES.STATUS_FLAG STATUS_FLAG
, LINES.IT_LINE_NUM IT_LINE_NUM
, FU.USER_NAME ORIGINATOR_NAME
, HEADER.NAME HEADER_NAME
, LINES.DESCRIPTION DESCRIPTION
, CC.NAME CHARGE_CENTER
, LINES.REJECTION_NOTE REJECTION_NOTE
, LINES.POSTING_FLAG POSTING_FLAG
, LINES.SUGGESTED_AMOUNT SUGGESTED_AMOUNT
, LINES.ENTERED_DR ENTERED_DR
, LINES.ENTERED_CR ENTERED_CR
, LINES.IT_HEADER_ID IT_HEADER_ID
, LINES.CHARGE_CENTER_ID CHARGE_CENTER_ID
, HEADER.CURRENCY_CODE CURRENCY_CODE
, HEADER.IT_ORIGINATOR_ID IT_ORIGINATOR_ID
, LINES.CODE_COMBINATION_ID CODE_COMBINATION_ID
, LINES.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, /*DECODE(LINES.POSTING_FLAG
, ''
, ''
, JL.MEANING) POSTING_FLAG_DSP
, */ LINES.SUBMIT_DATE SUBMIT_DATE
, LINES.EFFECTIVE_DATE EFFECTIVE_DATE
, LINES.CREATION_DATE CREATION_DATE
, LINES.CREATED_BY CREATED_BY
, LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY LAST_UPDATED_BY
FROM FND_USER FU
, IGI_ITR_CHARGE_CENTER CC
, IGI_ITR_CHARGE_HEADERS HEADER
, IGI_ITR_CHARGE_LINES LINES
WHERE HEADER.IT_HEADER_ID = LINES.IT_HEADER_ID
AND CC.CHARGE_CENTER_ID = LINES.CHARGE_CENTER_ID
AND FU.USER_ID = HEADER.IT_ORIGINATOR_ID