FND Design Data [Home] [Help]

View: IGC_CC_INTERFACE_V

Product: IGC - Contract Commitment
Description:
Implementation/DBA Data: ViewAPPS.IGC_CC_INTERFACE_V
View Text

SELECT CC_HEADER_ID
, CC_ACCT_LINE_ID
, CC_DET_PF_LINE_ID
, CODE_COMBINATION_ID
, BATCH_LINE_NUM
, CC_TRANSACTION_DATE
, CC_FUNC_DR_AMT
, CC_FUNC_CR_AMT
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, PERIOD_SET_NAME
, PERIOD_NAME
, ACTUAL_FLAG
, BUDGET_DEST_FLAG
, SET_OF_BOOKS_ID
, ENCUMBRANCE_TYPE_ID
, CBC_RESULT_CODE
, STATUS_CODE
, BUDGET_VERSION_ID
, BUDGET_AMT
, COMMITMENT_ENCMBRNC_AMT
, OBLIGATION_ENCMBRNC_AMT
, FUNDS_AVAILABLE_AMT
, CURRENCY_CODE
, DOCUMENT_TYPE
, TRANSACTION_DESCRIPTION
, PA_FLAG
, RESULT_CODE_SOURCE
, BATCH_ID
, REFERENCE_1
, REFERENCE_2
, REFERENCE_3
, REFERENCE_4
, REFERENCE_5
, REFERENCE_6
, REFERENCE_7
, REFERENCE_8
, REFERENCE_9
, REFERENCE_10
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CC_VERSION_NUM
, CC_ENCMBRNC_DATE
FROM IGC_CC_INTERFACE

Columns

Name
CC_HEADER_ID
CC_ACCT_LINE_ID
CC_DET_PF_LINE_ID
CODE_COMBINATION_ID
BATCH_LINE_NUM
CC_TRANSACTION_DATE
CC_FUNC_DR_AMT
CC_FUNC_CR_AMT
JE_SOURCE_NAME
JE_CATEGORY_NAME
PERIOD_SET_NAME
PERIOD_NAME
ACTUAL_FLAG
BUDGET_DEST_FLAG
SET_OF_BOOKS_ID
ENCUMBRANCE_TYPE_ID
CBC_RESULT_CODE
STATUS_CODE
BUDGET_VERSION_ID
BUDGET_AMT
COMMITMENT_ENCMBRNC_AMT
OBLIGATION_ENCMBRNC_AMT
FUNDS_AVAILABLE_AMT
CURRENCY_CODE
DOCUMENT_TYPE
TRANSACTION_DESCRIPTION
PA_FLAG
RESULT_CODE_SOURCE
BATCH_ID
REFERENCE_1
REFERENCE_2
REFERENCE_3
REFERENCE_4
REFERENCE_5
REFERENCE_6
REFERENCE_7
REFERENCE_8
REFERENCE_9
REFERENCE_10
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
CC_VERSION_NUM
CC_ENCMBRNC_DATE