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

TABLE: IGI.IGI_ITR_CHARGE_LINES_AUDIT_TMP

Object Details
Object Name: IGI_ITR_CHARGE_LINES_AUDIT_TMP
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_ITR_CHARGE_LINES_AUDIT_TMP
Subobject Name:
Status: VALID


IGI_ITR_CHARGE_LINES_AUDIT_TMP stores lines for upgrade purposes.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
IT_HEADER_ID NUMBER (15)
Cross charge header identifier
IT_LINE_NUM NUMBER (15)
Cross charge line number
SET_OF_BOOKS_ID NUMBER (15)
Set of Books identifier
RECEIVING_CODE_COMBINATION_ID NUMBER (15)
Key Flexfield combination defining column
CHARGE_CENTER_ID NUMBER (15)
Internal trading charge center identifier
EFFECTIVE_DATE DATE

Cross charge line default date
ENTERED_DR NUMBER

Cross charge line debit amount in entered currency
ENTERED_CR NUMBER

Cross charge line credit amount in entered currency
DESCRIPTION VARCHAR2 (240)
Cross charge line description
STATUS_FLAG VARCHAR2 (1)
Values are A for Accept, R for Reject, or E for Reauthorize.
POSTING_FLAG VARCHAR2 (1)
Values are S for Submit, F for Fundsfail, O for Postfail, D for Deleted, or P for Posted.
SUBMIT_DATE DATE

Date cross charge submitted
SUGGESTED_AMOUNT NUMBER

Amount for rejected cross charges
REJECTION_NOTE VARCHAR2 (240)
Rejected cross charge line detail
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
IT_SERVICE_LINE_ID NUMBER (15)
Service Line Identifier
CREATION_CODE_COMBINATION_ID NUMBER (15)
Creation Code Combination Identifier
CHARGE_SERVICE_ID NUMBER (15)
Service linked to Charge Identifier
PACKET_ID NUMBER (15)
GL_BC_PACKET Identifier
FAILED_FUNDS_LOOKUP_CODE VARCHAR2 (1)
Funds Status Code
ENCUMBRANCE_FLAG VARCHAR2 (1)
Y / N
ENCUMBERED_AMOUNT NUMBER

Charge Amount Encumbered
UNENCUMBERED_AMOUNT NUMBER

Charge Amount Unencumbered
GL_ENCUMBERED_DATE DATE

GL Encumbered Date
GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (15)
GL Encumbered Period
GL_CANCELLED_DATE DATE

GL Cancelled Date
PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
Y / N
JE_HEADER_ID NUMBER (15)
Journal Header Identifier
REVERSAL_FLAG VARCHAR2 (1)
Y / N
LINK_REFERENCE_NUM NUMBER (15)
Link reference number for charge service lines
ITR_AUDIT_LINE_ID NUMBER

Audit Line Identifier
CODE_COMBINATION_ID NUMBER (15)
Key Flexfield combination defining column. This would not be used in the new solution for 11.5.5.
Query Text

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


SELECT IT_HEADER_ID
,      IT_LINE_NUM
,      SET_OF_BOOKS_ID
,      RECEIVING_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
,      CREATION_CODE_COMBINATION_ID
,      CHARGE_SERVICE_ID
,      PACKET_ID
,      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
,      REVERSAL_FLAG
,      LINK_REFERENCE_NUM
,      ITR_AUDIT_LINE_ID
,      CODE_COMBINATION_ID
FROM IGI.IGI_ITR_CHARGE_LINES_AUDIT_TMP;

Dependencies

[top of page]

IGI.IGI_ITR_CHARGE_LINES_AUDIT_TMP does not reference any database object

IGI.IGI_ITR_CHARGE_LINES_AUDIT_TMP is referenced by following:

SchemaAPPS
SynonymIGI_ITR_CHARGE_LINES_AUDIT_TMP