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

VIEW: APPS.IGS_FI_F_TYP_CA_INST_LKP_V

Object Details
Object Name: IGS_FI_F_TYP_CA_INST_LKP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_F_TYP_CA_INST_LKP_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)
FEE_TYPE VARCHAR2 (10) Yes
FEE_CAL_TYPE VARCHAR2 (10) Yes
FEE_CI_SEQUENCE_NUMBER NUMBER (6) Yes
FEE_TYPE_CI_STATUS VARCHAR2 (10) Yes
START_DT_ALIAS VARCHAR2 (10) Yes
START_DAI_SEQUENCE_NUMBER NUMBER (6) Yes
END_DT_ALIAS VARCHAR2 (10) Yes
END_DAI_SEQUENCE_NUMBER NUMBER (6) Yes
RETRO_DT_ALIAS VARCHAR2 (10)
RETRO_DAI_SEQUENCE_NUMBER NUMBER (6)
S_CHG_METHOD_TYPE VARCHAR2 (30)
RUL_SEQUENCE_NUMBER NUMBER (6)
SCOPE_RUL_SEQUENCE_NUM NUMBER (6)
Rule Sequence Number which defines the Fee Assessment Scope for a Fee Type Calendar Instance
FIN_CAL_TYPE VARCHAR2 (10)
Obsolete Column
FIN_CI_SEQUENCE_NUMBER NUMBER (6)
Obsolete Column
ACCOUNT_CD VARCHAR2 (40)
Obsolete Column
PAYMENT_HIERARCHY_RANK NUMBER (5)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

START_DT DATE
Yes
END_DT DATE
Yes
CAL_STATUS VARCHAR2 (10) Yes
DESCRIPTION VARCHAR2 (30)
S_CAL_CAT VARCHAR2 (30) Yes
S_CAL_STATUS VARCHAR2 (30) Yes
MEANING VARCHAR2 (80)
RULE_DESCRIPTION VARCHAR2 (255)
RULE_TEXT VARCHAR2 (2000)
SCOPE_RULE_DESCRIPTION VARCHAR2 (255)
Scope Rule Description
SCOPE_RULE_TEXT VARCHAR2 (2000)
Scope Rule Text
ELM_RNG_ORDER_NAME VARCHAR2 (30)
Element Range Order Name which defines the order in which fee assessment computes fees.
ELM_RNG_ORDER_DESC VARCHAR2 (60)
Free Format description for the Element Range Order Name
STRT_DT_CAL_TYPE VARCHAR2 (10) Yes
STRT_DT_CI_SEQUENCE_NUMBER NUMBER (6) Yes
STRT_DT_ALIAS_VAL DATE

STRT_DT_DESCRIPTION VARCHAR2 (60) Yes
END_DT_CAL_TYPE VARCHAR2 (10) Yes
END_DT_CI_SEQUENCE_NUMBER NUMBER (6) Yes
END_DT_ALIAS_VAL DATE

END_DT_DESCRIPTION VARCHAR2 (60) Yes
RETRO_DT_CAL_TYPE VARCHAR2 (10)
RETRO_DT_CI_SEQUENCE_NUMBER NUMBER (6)
RETRO_DT_ALIAS_VAL DATE

RETRO_DT_DESCRIPTION VARCHAR2 (60)
FSST_DESCRIPTION VARCHAR2 (60) Yes
FSST_CLOSED_IND VARCHAR2 (1) Yes
SUBACCOUNT_ID NUMBER (15)
Obsolete - This field displays the Sub Account Identifier
SUBACCOUNT_NAME VARCHAR2 (0)
Obsolete - This field displays the Sub Account Name
INITIAL_DEFAULT_AMOUNT NUMBER

The amount that is used by the Fee Assessment if run in the Initial Default/Initial Prior modes
ACCT_HIER_ID NUMBER (15)
REC_GL_CCID NUMBER (38)
REV_ACCOUNT_CD VARCHAR2 (40)
REC_ACCOUNT_CD VARCHAR2 (40)
NAME VARCHAR2 (30)
RET_GL_CCID NUMBER (38)
RET_ACCOUNT_CD VARCHAR2 (40)
RETENTION_LEVEL_CODE VARCHAR2 (30)
Retention Level
RETENTION_LEVEL_MEANING VARCHAR2 (80)
Lookup Meaning for Retention Level
COMPLETE_RET_FLAG VARCHAR2 (1)
Complete Withdrawal Retention Rule Indicator
NONZERO_BILLABLE_CP_FLAG VARCHAR2 (1)
Flag to identify if fee needs to be assessed for any student unit attempt with zero billable credit point.
MAX_CHG_ELEMENTS NUMBER (7)
The maximum number of charge elements that will be considered for charge amount calculation during Fee Assessment
FEE_CAL_ALT_CD VARCHAR2 (10)
Fee Calendar Instance Alternate Code
Query Text

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


SELECT ROW_ID
,      FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      FEE_TYPE_CI_STATUS
,      START_DT_ALIAS
,      START_DAI_SEQUENCE_NUMBER
,      END_DT_ALIAS
,      END_DAI_SEQUENCE_NUMBER
,      RETRO_DT_ALIAS
,      RETRO_DAI_SEQUENCE_NUMBER
,      S_CHG_METHOD_TYPE
,      RUL_SEQUENCE_NUMBER
,      SCOPE_RUL_SEQUENCE_NUM
,      FIN_CAL_TYPE
,      FIN_CI_SEQUENCE_NUMBER
,      ACCOUNT_CD
,      PAYMENT_HIERARCHY_RANK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      START_DT
,      END_DT
,      CAL_STATUS
,      DESCRIPTION
,      S_CAL_CAT
,      S_CAL_STATUS
,      MEANING
,      RULE_DESCRIPTION
,      RULE_TEXT
,      SCOPE_RULE_DESCRIPTION
,      SCOPE_RULE_TEXT
,      ELM_RNG_ORDER_NAME
,      ELM_RNG_ORDER_DESC
,      STRT_DT_CAL_TYPE
,      STRT_DT_CI_SEQUENCE_NUMBER
,      STRT_DT_ALIAS_VAL
,      STRT_DT_DESCRIPTION
,      END_DT_CAL_TYPE
,      END_DT_CI_SEQUENCE_NUMBER
,      END_DT_ALIAS_VAL
,      END_DT_DESCRIPTION
,      RETRO_DT_CAL_TYPE
,      RETRO_DT_CI_SEQUENCE_NUMBER
,      RETRO_DT_ALIAS_VAL
,      RETRO_DT_DESCRIPTION
,      FSST_DESCRIPTION
,      FSST_CLOSED_IND
,      SUBACCOUNT_ID
,      SUBACCOUNT_NAME
,      INITIAL_DEFAULT_AMOUNT
,      ACCT_HIER_ID
,      REC_GL_CCID
,      REV_ACCOUNT_CD
,      REC_ACCOUNT_CD
,      NAME
,      RET_GL_CCID
,      RET_ACCOUNT_CD
,      RETENTION_LEVEL_CODE
,      RETENTION_LEVEL_MEANING
,      COMPLETE_RET_FLAG
,      NONZERO_BILLABLE_CP_FLAG
,      MAX_CHG_ELEMENTS
,      FEE_CAL_ALT_CD
FROM APPS.IGS_FI_F_TYP_CA_INST_LKP_V;

Dependencies

[top of page]

APPS.IGS_FI_F_TYP_CA_INST_LKP_V references the following:

SchemaAPPS
SynonymIGS_CA_DA
ViewIGS_CA_DA_INST_V
PL/SQL PackageIGS_CA_GEN_001 - show dependent code
PL/SQL PackageIGS_CA_GEN_002 - show dependent code
ViewIGS_CA_INST
SynonymIGS_CA_STAT
SynonymIGS_CA_TYPE
SynonymIGS_FI_ELM_RNG_ORDS
SynonymIGS_FI_FEE_STR_STAT
ViewIGS_FI_F_TYP_CA_INST
SynonymIGS_FI_HIER_ACCOUNTS
ViewIGS_LOOKUP_VALUES
SynonymIGS_RU_DESCRIPTION
SynonymIGS_RU_NAMED_RULE
APPS.IGS_FI_F_TYP_CA_INST_LKP_V is referenced by following:

SchemaAPPS
Package BodyIGS_FI_ANC_RATES_PKG - show dependent code
Package BodyIGS_FI_PRC_ACCT_PKG - show dependent code
Package BodyIGS_FI_PRC_FIN_LT_CHG - show dependent code