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

VIEW: APPS.IGS_FI_CR_TYPES_V

Object Details
Object Name: IGS_FI_CR_TYPES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_CR_TYPES_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CREDIT_TYPE_ID NUMBER (15) Yes
CREDIT_TYPE_NAME VARCHAR2 (60) Yes
DESCRIPTION VARCHAR2 (240)
CREDIT_CLASS VARCHAR2 (80) Yes
CREDIT_CLASS_CODE VARCHAR2 (40) Yes
SUBACCOUNT_NAME VARCHAR2 (0)
OBSOLETE.
SUBACCOUNT_ID NUMBER (15)
OBSOLETE.
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE

REFUND_ALLOWED VARCHAR2 (1)
PAYMENT_PRIORITY NUMBER

DR_ACCOUNT_CD VARCHAR2 (40)
DR_ACCOUNT_DESC VARCHAR2 (60)
Debit Account Code Description.
CR_ACCOUNT_CD VARCHAR2 (40)
CR_ACCOUNT_DESC VARCHAR2 (60)
Credit Account Code Description.
DR_GL_CCID NUMBER (15)
CR_GL_CCID NUMBER (15)
TITLE4_TYPE_IND VARCHAR2 (1) Yes Denotes if the Credit type is of Financial Aid Title IV type.
ORG_ID NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
PAYMENT_CREDIT_TYPE_ID NUMBER (15)
Payment Credit Type Identifier.
PAYMENT_CREDIT_TYPE_NAME VARCHAR2 (60)
Payment Credit Type name.
FORFEITURE_GL_CCID NUMBER (38)
Forfeiture GL Flexfield Account.
FORFEITURE_ACCOUNT_CD VARCHAR2 (40)
Forfeiture Account Code String.
FORFEITURE_ACCOUNT_DESC VARCHAR2 (60)
Forfeiture Account Code Description.
APPL_HIERARCHY_ID NUMBER (15)
Application Hierarchy Identifier
HIERARCHY_NAME VARCHAR2 (60)
Application Hierarchy Name
VERSION_NUMBER NUMBER

Application Hierarchy Version Number
Query Text

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


SELECT ROW_ID
,      CREDIT_TYPE_ID
,      CREDIT_TYPE_NAME
,      DESCRIPTION
,      CREDIT_CLASS
,      CREDIT_CLASS_CODE
,      SUBACCOUNT_NAME
,      SUBACCOUNT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      REFUND_ALLOWED
,      PAYMENT_PRIORITY
,      DR_ACCOUNT_CD
,      DR_ACCOUNT_DESC
,      CR_ACCOUNT_CD
,      CR_ACCOUNT_DESC
,      DR_GL_CCID
,      CR_GL_CCID
,      TITLE4_TYPE_IND
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      PAYMENT_CREDIT_TYPE_ID
,      PAYMENT_CREDIT_TYPE_NAME
,      FORFEITURE_GL_CCID
,      FORFEITURE_ACCOUNT_CD
,      FORFEITURE_ACCOUNT_DESC
,      APPL_HIERARCHY_ID
,      HIERARCHY_NAME
,      VERSION_NUMBER
FROM APPS.IGS_FI_CR_TYPES_V;

Dependencies

[top of page]

APPS.IGS_FI_CR_TYPES_V references the following:

SchemaAPPS
ViewIGS_FI_ACC
SynonymIGS_FI_A_HIERARCHIES
ViewIGS_FI_CR_TYPES
ViewIGS_LOOKUPS_VIEW
APPS.IGS_FI_CR_TYPES_V is referenced by following:

SchemaAPPS
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGS_FI_PRC_STDNT_DPSTS - show dependent code