VIEW: APPS.IGI_ITR_CHARGE_LINES_SS_V

Source

View Text - Preformatted

SELECT LINES.ROWID ROW_ID, LINES.IT_LINE_NUM IT_LINE_NUM, LINES.IT_SERVICE_LINE_ID IT_SERVICE_LINE_ID, LINES.DESCRIPTION DESCRIPTION, LINES.SUBMIT_DATE SUBMIT_DATE, LINES.REJECTION_NOTE REJECTION_NOTE, LINES.IT_HEADER_ID IT_HEADER_ID, LINES.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, LINES.CREATION_CODE_COMBINATION_ID CREATION_CODE_COMBINATION_ID, LINES.RECEIVING_CODE_COMBINATION_ID RECEIVING_CODE_COMBINATION_ID, LINES.CHARGE_CENTER_ID CHARGE_CENTER_ID, LINES.CHARGE_SERVICE_ID CHARGE_SERVICE_ID, SERVI.NAME SERVICE_TYPE, LINES.CREA_COST_CENTER CREA_COST_CENTER, LINES.CREA_CONF_SEGMENT_VALUE CREA_CONF_SEGMENT_VALUE, LINES.RECV_COST_CENTER RECV_COST_CENTER, LINES.RECV_CONF_SEGMENT_VALUE RECV_CONF_SEGMENT_VALUE, LINES.STATUS_FLAG STATUS_FLAG, LINES.POSTING_FLAG POSTING_FLAG, LINES.ENTERED_CR ENTERED_CR, LINES.ENTERED_DR ENTERED_DR, LINES.SUGGESTED_AMOUNT SUGGESTED_AMOUNT, LINES.SUGGESTED_RECV_CCID SUGGESTED_RECV_CCID, LINES.EFFECTIVE_DATE EFFECTIVE_DATE, CC.NAME CHARGE_CENTER, LINES.FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE, LINES.ENCUMBRANCE_FLAG ENCUMBRANCE_FLAG, LINES.ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT, LINES.UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT, LINES.GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE, LINES.GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME, LINES.GL_CANCELLED_DATE GL_CANCELLED_DATE, LINES.PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG, LINES.JE_HEADER_ID JE_HEADER_ID, 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, IGIL.MEANING MEANING, LINES.RECEIVER_ID, LINES.CHARGE_RANGE_ID, SER.SERVICE_ID FROM IGI_ITR_CHARGE_HEADERS HEAD, IGI_ITR_CHARGE_LINES LINES, IGI_ITR_CHARGE_SERVICE_SS_V SERVI, IGI_ITR_CHARGE_CENTER CC, IGI_LOOKUPS IGIL, FND_USER F, IGI_ITR_SERVICE SER WHERE CC.CHARGE_CENTER_ID = LINES.CHARGE_CENTER_ID AND HEAD.IT_HEADER_ID = LINES.IT_HEADER_ID AND SERVI.CHARGE_SERVICE_ID = LINES.CHARGE_SERVICE_ID AND SER.SERVICE_ID = LINES.SERVICE_ID AND LINES.RECEIVER_ID = F.USER_ID AND IGIL.LOOKUP_CODE = LINES.STATUS_FLAG AND IGIL.LOOKUP_TYPE = 'ITR_SERVICE_STATUS'

View Text - HTML Formatted

SELECT LINES.ROWID ROW_ID
, LINES.IT_LINE_NUM IT_LINE_NUM
, LINES.IT_SERVICE_LINE_ID IT_SERVICE_LINE_ID
, LINES.DESCRIPTION DESCRIPTION
, LINES.SUBMIT_DATE SUBMIT_DATE
, LINES.REJECTION_NOTE REJECTION_NOTE
, LINES.IT_HEADER_ID IT_HEADER_ID
, LINES.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, LINES.CREATION_CODE_COMBINATION_ID CREATION_CODE_COMBINATION_ID
, LINES.RECEIVING_CODE_COMBINATION_ID RECEIVING_CODE_COMBINATION_ID
, LINES.CHARGE_CENTER_ID CHARGE_CENTER_ID
, LINES.CHARGE_SERVICE_ID CHARGE_SERVICE_ID
, SERVI.NAME SERVICE_TYPE
, LINES.CREA_COST_CENTER CREA_COST_CENTER
, LINES.CREA_CONF_SEGMENT_VALUE CREA_CONF_SEGMENT_VALUE
, LINES.RECV_COST_CENTER RECV_COST_CENTER
, LINES.RECV_CONF_SEGMENT_VALUE RECV_CONF_SEGMENT_VALUE
, LINES.STATUS_FLAG STATUS_FLAG
, LINES.POSTING_FLAG POSTING_FLAG
, LINES.ENTERED_CR ENTERED_CR
, LINES.ENTERED_DR ENTERED_DR
, LINES.SUGGESTED_AMOUNT SUGGESTED_AMOUNT
, LINES.SUGGESTED_RECV_CCID SUGGESTED_RECV_CCID
, LINES.EFFECTIVE_DATE EFFECTIVE_DATE
, CC.NAME CHARGE_CENTER
, LINES.FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE
, LINES.ENCUMBRANCE_FLAG ENCUMBRANCE_FLAG
, LINES.ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT
, LINES.UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT
, LINES.GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE
, LINES.GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME
, LINES.GL_CANCELLED_DATE GL_CANCELLED_DATE
, LINES.PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG
, LINES.JE_HEADER_ID JE_HEADER_ID
, 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
, IGIL.MEANING MEANING
, LINES.RECEIVER_ID
, LINES.CHARGE_RANGE_ID
, SER.SERVICE_ID
FROM IGI_ITR_CHARGE_HEADERS HEAD
, IGI_ITR_CHARGE_LINES LINES
, IGI_ITR_CHARGE_SERVICE_SS_V SERVI
, IGI_ITR_CHARGE_CENTER CC
, IGI_LOOKUPS IGIL
, FND_USER F
, IGI_ITR_SERVICE SER
WHERE CC.CHARGE_CENTER_ID = LINES.CHARGE_CENTER_ID
AND HEAD.IT_HEADER_ID = LINES.IT_HEADER_ID
AND SERVI.CHARGE_SERVICE_ID = LINES.CHARGE_SERVICE_ID
AND SER.SERVICE_ID = LINES.SERVICE_ID
AND LINES.RECEIVER_ID = F.USER_ID
AND IGIL.LOOKUP_CODE = LINES.STATUS_FLAG
AND IGIL.LOOKUP_TYPE = 'ITR_SERVICE_STATUS'