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

VIEW: IGC.IGC_CC_INTERFACE#

Object Details
Object Name: IGC_CC_INTERFACE#
Object Type: VIEW
Owner: IGC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CC_HEADER_ID NUMBER
Yes
CC_VERSION_NUM NUMBER

CC_ACCT_LINE_ID NUMBER

CC_DET_PF_LINE_ID NUMBER

CODE_COMBINATION_ID NUMBER (15) Yes
BATCH_LINE_NUM NUMBER
Yes
CC_TRANSACTION_DATE DATE
Yes
CC_FUNC_DR_AMT NUMBER

CC_FUNC_CR_AMT NUMBER

JE_SOURCE_NAME VARCHAR2 (25)
JE_CATEGORY_NAME VARCHAR2 (25)
PERIOD_SET_NAME VARCHAR2 (15)
PERIOD_NAME VARCHAR2 (15)
ACTUAL_FLAG VARCHAR2 (1) Yes
BUDGET_DEST_FLAG VARCHAR2 (1) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
ENCUMBRANCE_TYPE_ID NUMBER (15)
CBC_RESULT_CODE VARCHAR2 (3)
STATUS_CODE VARCHAR2 (2)
BUDGET_VERSION_ID NUMBER (15)
BUDGET_AMT NUMBER

COMMITMENT_ENCMBRNC_AMT NUMBER

OBLIGATION_ENCMBRNC_AMT NUMBER

CC_ENCMBRNC_DATE DATE

FUNDS_AVAILABLE_AMT NUMBER

CURRENCY_CODE VARCHAR2 (15) Yes
DOCUMENT_TYPE VARCHAR2 (25) Yes
TRANSACTION_DESCRIPTION VARCHAR2 (240)
PA_FLAG VARCHAR2 (1)
RESULT_CODE_SOURCE VARCHAR2 (1)
BATCH_ID NUMBER (20)
REFERENCE_1 VARCHAR2 (240)
REFERENCE_2 VARCHAR2 (240)
REFERENCE_3 VARCHAR2 (240)
REFERENCE_4 VARCHAR2 (240)
REFERENCE_5 VARCHAR2 (240)
REFERENCE_6 VARCHAR2 (240)
REFERENCE_7 VARCHAR2 (240)
REFERENCE_8 VARCHAR2 (240)
REFERENCE_9 VARCHAR2 (240)
REFERENCE_10 VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
EVENT_ID NUMBER

PROJECT_LINE VARCHAR2 (1)
PA_BURDEN_FLAG VARCHAR2 (1)
ENCUMBRANCE_TYPE_KEY VARCHAR2 (30)
Query Text

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


SELECT CC_HEADER_ID
,      CC_VERSION_NUM
,      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
,      CC_ENCMBRNC_DATE
,      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
,      EVENT_ID
,      PROJECT_LINE
,      PA_BURDEN_FLAG
,      ENCUMBRANCE_TYPE_KEY
FROM IGC.IGC_CC_INTERFACE#;

Dependencies

[top of page]

IGC.IGC_CC_INTERFACE# references the following:

SchemaIGC
TableIGC_CC_INTERFACE
IGC.IGC_CC_INTERFACE# is referenced by following:

SchemaAPPS
SynonymIGC_CC_INTERFACE