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

VIEW: APPS.IGC_CC_EVENT_JE_LINES_V

Object Details
Object Name: IGC_CC_EVENT_JE_LINES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View for Journal Line used in SLA transaction objects set-up


[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER

Event identifier
LINE_NUMBER NUMBER

Row number
CC_ACCT_LINE_ID NUMBER

Account line defining column
CC_DET_PF_LINE_ID NUMBER

Detail payment forecast line defining column
CODE_COMBINATION_ID NUMBER (15) Yes Key Flexfield combination defining column
BATCH_LINE_NUM NUMBER
Yes Line number of batch
CC_FUNC_DR_AMT NUMBER

Transactional debit amount
CC_FUNC_CR_AMT NUMBER

Transactional credit amount
CC_FUNC_AMT NUMBER

Transactional functional amount
ENCUMBRANCE_TYPE_ID NUMBER (15)
Encumbrance type defining column
CBC_RESULT_CODE VARCHAR2 (3)
Result code for transaction line
STATUS_CODE VARCHAR2 (2)
Status code for batch
BUDGET_VERSION_ID NUMBER (15)
Budget version defining column
CURRENCY_CODE VARCHAR2 (15) Yes Currency code for functional currency for this transaction
TRANSACTION_DESCRIPTION VARCHAR2 (240)
Description for this transaction
PA_FLAG VARCHAR2 (1)
Flag to indicate whethere there are any associated Projects
PACKET_ID NUMBER (20)
Batch Identifier
PROJECT_LINE VARCHAR2 (1)
Line information of project
APPLIED_TO_APPL_ID NUMBER

Application id 8407
APPLIED_TO_ENTITY_CODE CHAR (12)
Applied to entity 'CC_CONTRACTS'
APPLIED_TO_HEADER_ID_1 NUMBER
Yes Document identifier defining column
APPLIED_TO_DIST_LINK_TYPE CHAR (2)
Applied to type 'CC'
APPLIED_TO_DIST_ID_1 NUMBER

Account line defining column
ENTERED_CURRENCY_CODE VARCHAR2 (15)
Entered Currency Code
CONVERSION_TYPE VARCHAR2 (30)
Conversion Type
CONVERSION_DATE DATE

Conversion Date
CONVERSION_RATE NUMBER

Conversion Rate
ENTERED_AMOUNT NUMBER

Entered Amount
CC_DET_PF_ENCMBRNC_STATUS VARCHAR2 (1)
Detailed Payment forecast Encumbrance Status
CC_ACCT_ENCMBRNC_STATUS VARCHAR2 (1)
CC Account Encumbrance Status
CC_ENTERED_AMOUNT NUMBER

CC Entered Amount
CC_ACCOUNTED_AMOUNT NUMBER

CC Accounted Amount
ENCUMBRANCE_TYPE_KEY VARCHAR2 (30)
Encumbrance Type Key
Query Text

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


SELECT EVENT_ID
,      LINE_NUMBER
,      CC_ACCT_LINE_ID
,      CC_DET_PF_LINE_ID
,      CODE_COMBINATION_ID
,      BATCH_LINE_NUM
,      CC_FUNC_DR_AMT
,      CC_FUNC_CR_AMT
,      CC_FUNC_AMT
,      ENCUMBRANCE_TYPE_ID
,      CBC_RESULT_CODE
,      STATUS_CODE
,      BUDGET_VERSION_ID
,      CURRENCY_CODE
,      TRANSACTION_DESCRIPTION
,      PA_FLAG
,      PACKET_ID
,      PROJECT_LINE
,      APPLIED_TO_APPL_ID
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_HEADER_ID_1
,      APPLIED_TO_DIST_LINK_TYPE
,      APPLIED_TO_DIST_ID_1
,      ENTERED_CURRENCY_CODE
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      ENTERED_AMOUNT
,      CC_DET_PF_ENCMBRNC_STATUS
,      CC_ACCT_ENCMBRNC_STATUS
,      CC_ENTERED_AMOUNT
,      CC_ACCOUNTED_AMOUNT
,      ENCUMBRANCE_TYPE_KEY
FROM APPS.IGC_CC_EVENT_JE_LINES_V;

Dependencies

[top of page]

APPS.IGC_CC_EVENT_JE_LINES_V references the following:

SchemaAPPS
SynonymIGC_CC_ACCT_LINES
SynonymIGC_CC_DET_PF
SynonymIGC_CC_HEADERS_ALL
SynonymIGC_CC_INTERFACE
APPS.IGC_CC_EVENT_JE_LINES_V is referenced by following:

SchemaAPPS
Package BodyXLA_08407_AAD_S_000013_BC_PKG - show dependent code