Product: | IGI - Public Sector Financials International |
---|---|
Description: | Based on IGI_ITR_CHARGE_CENTER and IGI_ITR_CHARGE_LINES |
Implementation/DBA Data: | APPS.IGI_ITR_CHARGE_LINES_ENTRY_V |
SELECT LINES.ROWID ROW_ID
, LINES.IT_LINE_NUM IT_LINE_NUM
, LINES.DESCRIPTION DESCRIPTION
, LINES.SUBMIT_DATE SUBMIT_DATE
, LINES.REJECTION_NOTE REJECTION_NOTE
, LINES.IT_HEADER_ID
, LINES.SET_OF_BOOKS_ID
, LINES.CODE_COMBINATION_ID
, LINES.CHARGE_CENTER_ID
, LINES.STATUS_FLAG
, LINES.POSTING_FLAG
, LINES.ENTERED_CR
, LINES.ENTERED_DR
, LINES.SUGGESTED_AMOUNT
, LINES.EFFECTIVE_DATE
, CC.NAME CHARGE_CENTER
, LINES.CREATION_DATE
, LINES.CREATED_BY
, LINES.LAST_UPDATE_LOGIN
, LINES.LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY
FROM IGI_ITR_CHARGE_CENTER CC
, IGI_ITR_CHARGE_LINES LINES
WHERE CC.CHARGE_CENTER_ID = LINES.CHARGE_CENTER_ID