[Home] [Help] [Dependency Information]
Object Name: | IGC_CC_EVENT_JE_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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
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 |
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;
|
|
|