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

VIEW: APPS.IGS_FI_FEE_TYPE

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
FEE_TYPE VARCHAR2 (10) Yes
S_FEE_TYPE VARCHAR2 (10) Yes
S_FEE_TRIGGER_CAT VARCHAR2 (10) Yes
DESCRIPTION VARCHAR2 (60) Yes
OPTIONAL_PAYMENT_IND VARCHAR2 (1) Yes
DESIGNATED_PAYMENT_FLAG VARCHAR2 (1)
This flag indicates whether the particular Fee Type can be included in Targeted Applications in the context of self-service or lockbox.
CLOSED_IND VARCHAR2 (1) Yes
COMMENTS VARCHAR2 (2000)
ORG_ID NUMBER (15)
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)
FEE_CLASS VARCHAR2 (30)
This column is used to group the fee types so that once a charge is created for the person for any of the fee type, the Financial Aid Disbursement can look at this value tagged for tthe particular fee type for the disbursement of funds.
SUBACCOUNT_ID NUMBER (15)
OBSOLETE. Sub Account Identifier.
Query Text

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


SELECT ROW_ID
,      FEE_TYPE
,      S_FEE_TYPE
,      S_FEE_TRIGGER_CAT
,      DESCRIPTION
,      OPTIONAL_PAYMENT_IND
,      DESIGNATED_PAYMENT_FLAG
,      CLOSED_IND
,      COMMENTS
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FEE_CLASS
,      SUBACCOUNT_ID
FROM APPS.IGS_FI_FEE_TYPE;

Dependencies

[top of page]

APPS.IGS_FI_FEE_TYPE references the following:

SchemaAPPS
SynonymIGS_FI_FEE_TYPE_ALL
APPS.IGS_FI_FEE_TYPE is referenced by following:

SchemaAPPS
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGS_AS_SS_DOC_REQUEST - show dependent code
Package BodyIGS_EN_VAL_USFT - show dependent code
Package BodyIGS_FI_1098T_EXTRACT_DATA - show dependent code
Package BodyIGS_FI_ACCT_STP_CNV - show dependent code
ViewIGS_FI_ADL_APP_RUL_V
ViewIGS_FI_APP_RULES_V
Package BodyIGS_FI_BAL_EX_F_TYPS_PKG - show dependent code
ViewIGS_FI_BAL_EX_F_TYPS_V
Package BodyIGS_FI_BILL_EXTRACT - show dependent code
Package BodyIGS_FI_CHARGES_API_PVT - show dependent code
ViewIGS_FI_CNG_FCAT_LBL_SCA_PR_V
Package BodyIGS_FI_COM_REC_INTERFACE - show dependent code
Package BodyIGS_FI_FEE_AS_PKG - show dependent code
ViewIGS_FI_FEE_RET_SCHD_F_TYPE_V
Package BodyIGS_FI_FEE_TYPE_PKG - show dependent code
ViewIGS_FI_FEE_TYPE_V
ViewIGS_FI_FIN_LT_PLAN_V
ViewIGS_FI_F_CAT_FEE_LBL_ALL_V
Package BodyIGS_FI_F_CAT_FEE_LBL_PKG - show dependent code
ViewIGS_FI_F_CAT_FEE_LBL_SCA_PRR_V
ViewIGS_FI_F_CAT_FEE_LBL_SCA_V
Package BodyIGS_FI_GEN_001 - show dependent code
Package BodyIGS_FI_GEN_004 - show dependent code
Package BodyIGS_FI_GEN_005 - show dependent code
Package BodyIGS_FI_GEN_006 - show dependent code
PL/SQL PackageIGS_FI_GEN_008 - show dependent code
Package BodyIGS_FI_GEN_008 - show dependent code
Package BodyIGS_FI_GEN_REFUNDS - show dependent code
PL/SQL PackageIGS_FI_GEN_REFUNDS - show dependent code
ViewIGS_FI_INV_IGF_V
Package BodyIGS_FI_INV_INT_PKG - show dependent code
Package BodyIGS_FI_LOAD_EXT_CHG - show dependent code
Package BodyIGS_FI_PAYMENT_PLANS - show dependent code
Package BodyIGS_FI_PRC_ACCT_PKG - show dependent code
Package BodyIGS_FI_PRC_BALANCES - show dependent code
PL/SQL PackageIGS_FI_PRC_FEE_ASS - show dependent code
Package BodyIGS_FI_PRC_FEE_ROLLV - show dependent code
Package BodyIGS_FI_PRC_FIN_LT_CHG - show dependent code
Package BodyIGS_FI_PRC_IMPCLC_ANC_CHGS - show dependent code
Package BodyIGS_FI_PRC_LOCKBOX - show dependent code
Package BodyIGS_FI_PRC_REFUNDS - show dependent code
Package BodyIGS_FI_PRC_SP_FEES - show dependent code
Package BodyIGS_FI_PRC_WAIVERS - show dependent code
Package BodyIGS_FI_REFUNDS_PKG - show dependent code
Package BodyIGS_FI_SS_CHARGES_API_PVT - show dependent code
Package BodyIGS_FI_VAL_CFAR - show dependent code
Package BodyIGS_FI_VAL_CFT - show dependent code
Package BodyIGS_FI_VAL_CGFT - show dependent code
Package BodyIGS_FI_VAL_CTFT - show dependent code
Package BodyIGS_FI_VAL_ER - show dependent code
Package BodyIGS_FI_VAL_FAR - show dependent code
Package BodyIGS_FI_VAL_FAS - show dependent code
Package BodyIGS_FI_VAL_FCFL - show dependent code
Package BodyIGS_FI_VAL_FRTNS - show dependent code
Package BodyIGS_FI_VAL_FT - show dependent code
Package BodyIGS_FI_VAL_FTCI - show dependent code
Package BodyIGS_FI_VAL_FTG - show dependent code
Package BodyIGS_FI_VAL_UFT - show dependent code
Package BodyIGS_FI_WAV_UTILS_002 - show dependent code
PL/SQL PackageIGS_FI_WAV_UTILS_002 - show dependent code
Package BodyIGS_HE_EXTRACT_FIELDS_PKG - show dependent code
Package BodyIGS_PS_CREATE_GENERIC_PKG - show dependent code
Package BodyIGS_PS_GEN_001 - show dependent code
Package BodyIGS_ST_GEN_003 - show dependent code