eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: IGI.IGI_ITR_CHARGE_LINES#

Object Details

Object Name:	IGI_ITR_CHARGE_LINES#
Object Type:	VIEW
Owner:	IGI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
IT_HEADER_ID	NUMBER	(15)	Yes
IT_LINE_NUM	NUMBER	(15)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
CODE_COMBINATION_ID	NUMBER	(15)
CHARGE_CENTER_ID	NUMBER	(15)	Yes
EFFECTIVE_DATE	DATE
ENTERED_DR	NUMBER
ENTERED_CR	NUMBER
DESCRIPTION	VARCHAR2	(240)
STATUS_FLAG	VARCHAR2	(1)
POSTING_FLAG	VARCHAR2	(1)
SUBMIT_DATE	DATE
SUGGESTED_AMOUNT	NUMBER
REJECTION_NOTE	VARCHAR2	(240)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
IT_SERVICE_LINE_ID	NUMBER	(15)
RECEIVING_CODE_COMBINATION_ID	NUMBER	(15)
CREATION_CODE_COMBINATION_ID	NUMBER	(15)
CHARGE_SERVICE_ID	NUMBER	(15)
CREA_COST_CENTER	VARCHAR2	(30)
CREA_CONF_SEGMENT_VALUE	VARCHAR2	(30)
RECV_COST_CENTER	VARCHAR2	(30)
RECV_CONF_SEGMENT_VALUE	VARCHAR2	(30)
SUGGESTED_RECV_CCID	NUMBER	(15)
FAILED_FUNDS_LOOKUP_CODE	VARCHAR2	(1)
ENCUMBRANCE_FLAG	VARCHAR2	(1)
ENCUMBERED_AMOUNT	NUMBER
UNENCUMBERED_AMOUNT	NUMBER
GL_ENCUMBERED_DATE	DATE
GL_ENCUMBERED_PERIOD_NAME	VARCHAR2	(15)
GL_CANCELLED_DATE	DATE
PREVENT_ENCUMBRANCE_FLAG	VARCHAR2	(1)
JE_HEADER_ID	NUMBER	(15)
RECEIVER_ID	NUMBER	(15)
CHARGE_RANGE_ID	NUMBER	(15)
PACKET_ID	NUMBER	(15)
REVERSAL_FLAG	VARCHAR2	(1)
LINK_REFERNCE_NUM	NUMBER	(15)
SERVICE_ID	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT IT_HEADER_ID
,      IT_LINE_NUM
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      CHARGE_CENTER_ID
,      EFFECTIVE_DATE
,      ENTERED_DR
,      ENTERED_CR
,      DESCRIPTION
,      STATUS_FLAG
,      POSTING_FLAG
,      SUBMIT_DATE
,      SUGGESTED_AMOUNT
,      REJECTION_NOTE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      IT_SERVICE_LINE_ID
,      RECEIVING_CODE_COMBINATION_ID
,      CREATION_CODE_COMBINATION_ID
,      CHARGE_SERVICE_ID
,      CREA_COST_CENTER
,      CREA_CONF_SEGMENT_VALUE
,      RECV_COST_CENTER
,      RECV_CONF_SEGMENT_VALUE
,      SUGGESTED_RECV_CCID
,      FAILED_FUNDS_LOOKUP_CODE
,      ENCUMBRANCE_FLAG
,      ENCUMBERED_AMOUNT
,      UNENCUMBERED_AMOUNT
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      GL_CANCELLED_DATE
,      PREVENT_ENCUMBRANCE_FLAG
,      JE_HEADER_ID
,      RECEIVER_ID
,      CHARGE_RANGE_ID
,      PACKET_ID
,      REVERSAL_FLAG
,      LINK_REFERNCE_NUM
,      SERVICE_ID
FROM IGI.IGI_ITR_CHARGE_LINES#;

Dependencies

[top of page]

IGI.IGI_ITR_CHARGE_LINES# references the following:

IGI: IGI_ITR_CHARGE_LINES

IGI.IGI_ITR_CHARGE_LINES# is referenced by following:

APPS: IGI_ITR_CHARGE_LINES