Table: IGS_FI_OTC_CHARGES | Oracle EBS ETRM Search

Table: IGS_FI_OTC_CHARGES 12.1.1 link

owner IGS·IGS - Student System·8 columns

Contains information on the charges (of type external) that are created at the time of receipt creation. Provides a repository of all charges that are tied to the receipt, if any, that were created when the student pays over the counter.

IGS.IGS_FI_OTC_CHARGES·Explore IGS module →

Table: IGS_FI_PP_INS_APPLS 12.1.1 link

owner IGS·IGS - Student System·17 columns

This table stores credit information for a particular installment.

IGS.IGS_FI_PP_INS_APPLS·Explore IGS module →

View: IGS_FI_CR_ACTIVITIES_V 12.1.1

IGS - Student System·25 columns

Retrieves the records from the Credit Activities table.

APPS.IGS_FI_CR_ACTIVITIES_V·↳ IGS_FI_ACC·↳ IGS_FI_CR_ACTIVITIES·↳ IGS_LOOKUP_VALUES·Explore IGS module →

Table: IGS_FI_APPLICATIONS 12.1.1 link

owner IGS·IGS - Student System·27 columns

Contains application information about credits and charges transaction that are applied.

IGS.IGS_FI_APPLICATIONS·Explore IGS module →

View: IGS_FI_PP_INS_APPLS_V 12.1.1

IGS - Student System·20 columns

This view displays the credit information for a particular installment.

APPS.IGS_FI_PP_INS_APPLS_V·↳ IGS_FI_CREDITS·↳ IGS_FI_PP_INS_APPLS·Explore IGS module →

Table: BIL_BI_PIPELINE_STG 12.1.1 standalone

owner BIL·BIL - Sales Intelligence·19 columns

Staging table for sales open and pipeline amounts

BIL.BIL_BI_PIPELINE_STG·Explore BIL module →

Table: IGS_FI_CREDITS_ALL 12.1.1 hub

owner IGS·IGS - Student System·74 columns

This table contains information about all credit or payment transactions and is the central repository for all credits and payments related information in Student Finance.

IGS.IGS_FI_CREDITS_ALL·Explore IGS module →

Table: IGS_FI_CR_ACTIVITIES 12.1.1 satellite-leaning

owner IGS·IGS - Student System·25 columns

Contains steps for the life cycle of credit transactions. This captures one record in this table when a new credit transaction is created in IGS_FI_CREDITS_ALL table with STATUS 'CLEARED'.

IGS.IGS_FI_CR_ACTIVITIES·Explore IGS module →

View: IGS_FI_CREDITS 12.1.1

IGS - Student System·75 columns

This view is a multi-org filter flat view based on table IGS_FI_CREDITS_ALL.

APPS.IGS_FI_CREDITS·↳ IGS_FI_CREDITS_ALL·Explore IGS module →

View: IGS_FI_APPLICATIONS_V 12.1.1

IGS - Student System·34 columns

No Longer Used

APPS.IGS_FI_APPLICATIONS_V·↳ IGS_FI_APPLICATIONS·↳ IGS_FI_GEN_007·↳ IGS_FI_INV_INT·Explore IGS module →

View: IGS_FI_CREDITS_V 12.1.1

IGS - Student System·91 columns

This is a multi-org view based on org filtered view IGS_FI_CREDITS and join with view IGS_LOOKUPS_VIEW and IGS_FI_CR_TYPES view to resolve Lookup Meaning and Credit Type Names from IDs

APPS.IGS_FI_CREDITS_V·↳ IGF_LOOKUPS_VIEW·↳ IGS_CA_INST·↳ IGS_EN_GEN_003·Explore IGS module →

View: IGS_FI_OTC_CHARGES_V 12.1.1

IGS - Student System·85 columns

The view contains information on the charges(of type external) that are created at the time of receipt creation.

APPS.IGS_FI_OTC_CHARGES_V·↳ IGS_FI_ACC·↳ IGS_FI_INVLN_INT·↳ IGS_FI_INV_INT·Explore IGS module →

PACKAGE: APPS.IGS_FI_GEN_007 12.1.1

used by 34

TABLE: IGS.IGS_FI_OTC_CHARGES 12.1.1

owner IGS

TABLE: BIL.BIL_BI_PIPELINE_STG 12.1.1

owner BIL

PACKAGE BODY: APPS.IGS_FI_GEN_007 12.1.1

used by 34

APPS.IGS_FI_PRC_WAIVERS SQL Statements 12.1.1

APPS.IGS_FI_OTC_CHARGES_PKG SQL Statements 12.1.1

View: IGS_FI_CREDITS 12.2.2

IGS - Student System (Obsolete)

This view is a multi-org filter flat view based on table IGS_FI_CREDITS_ALL.

Not implemented in this database·Explore IGS module →

PACKAGE BODY: APPS.IGS_FI_DEPOSITS_PRCSS 12.1.1

used by 1

TABLE: IGS.IGS_FI_PP_INS_APPLS 12.1.1

owner IGS

PACKAGE BODY: APPS.IGS_FI_UPG_RETENTION 12.1.1

TABLE: IGS.IGS_FI_CR_ACTIVITIES 12.1.1

owner IGS

PACKAGE: APPS.IGS_FI_DEPOSITS_PRCSS 12.1.1

used by 1

APPS.IGS_FI_GEN_GL SQL Statements 12.1.1

VIEW: APPS.IGS_FI_CR_ACTIVITIES_V 12.1.1

PACKAGE: APPS.IGS_FI_UPG_RETENTION 12.1.1

VIEW: APPS.IGS_FI_PP_INS_APPLS_V 12.1.1

VIEW: APPS.IGS_FI_APPLICATIONS_V 12.1.1

View: IGS_FI_CR_ACTIVITIES_V 12.2.2

IGS - Student System (Obsolete)

Retrieves the records from the Credit Activities table.

Not implemented in this database·Explore IGS module →

TABLE: IGS.IGS_FI_APPLICATIONS 12.1.1

owner IGS

Table: IGS_FI_OTC_CHARGES 12.2.2

IGS - Student System (Obsolete)

Contains information on the charges (of type external) that are created at the time of receipt creation. Provides a repository of all charges that are tied to the receipt, if any, that were created when the student pays over the counter.

Not implemented in this database·Explore IGS module →

View: IGS_FI_PP_INS_APPLS_V 12.2.2

IGS - Student System (Obsolete)

This view displays the credit information for a particular installment.

Not implemented in this database·Explore IGS module →

APPS.IGS_FI_GEN_007 SQL Statements 12.1.1

VIEW: APPS.IGS_FI_CREDITS 12.1.1

Table: IGS_FI_CREDITS_ALL 12.2.2

IGS - Student System (Obsolete)

This table contains information about all credit or payment transactions and is the central repository for all credits and payments related information in Student Finance.

Not implemented in this database·Explore IGS module →

PACKAGE BODY: APPS.IGS_FI_GEN_GL 12.1.1

used by 49

PACKAGE BODY: APPS.IGS_FI_PRC_WAIVERS 12.1.1

used by 2

View: IGS_FI_APPLICATIONS_V 12.2.2

IGS - Student System (Obsolete)

No Longer Used

Not implemented in this database·Explore IGS module →

VIEW: APPS.IGS_AS_ORDER_PAYMENT_INFO_V 12.1.1

APPS.IGS_FI_PP_INS_APPLS_PKG SQL Statements 12.1.1

PACKAGE: APPS.IGS_FI_OTC_CHARGES_PKG 12.1.1

used by 2

PACKAGE BODY: APPS.IGS_FI_OTC_CHARGES_PKG 12.1.1

used by 2

PACKAGE: APPS.IGS_FI_GEN_GL 12.1.1

used by 49

PACKAGE: APPS.IGS_FI_PRC_WAIVERS 12.1.1

used by 2

PACKAGE BODY: APPS.IGS_FI_POSTING_PROCESS 12.1.1

PACKAGE: APPS.IGS_FI_POSTING_PROCESS 12.1.1

APPS.IGS_FI_APPLICATIONS_PKG SQL Statements 12.1.1

View: IGS_AS_ORDER_PAYMENT_INFO_V 12.2.2

IGS - Student System (Obsolete)

This view is used to get the payment related information corresponding to the order for document placed by the user.

Not implemented in this database·Explore IGS module →

APPS.IGS_FI_CR_ACTIVITIES_PKG SQL Statements 12.1.1

Results for “credit_id”