Table: IGS_FI_BILL_ALL | Oracle EBS ETRM Search

Table: IGS_FI_BILL_ALL 12.1.1 hub

owner IGS·IGS - Student System·23 columns

IGS_FI_BILL_ALL is the relation where the Billing Header information is recorded. Here the Bill Numbers are generated and Bill header details such as Bill Date, Due Date, Billed Person, Sub Account and Balances are recorded.

IGS.IGS_FI_BILL_ALL·Explore IGS module →

Table: FTE_INVOICE_HEADERS 12.2.2 standalone

owner FTE·FTE - Transportation Execution·55 columns

Table to store invoice header information

FTE.FTE_INVOICE_HEADERS·Explore FTE module →

View: IGS_FI_ACCT_V 12.1.1

IGS - Student System·17 columns

This view contains information from two views IGS_FI_INV_INT and IGS_FI_CREDITS_V and a table IGS_FI_CR_ACTIVITES using UNION to collate information for Account History Form.

APPS.IGS_FI_ACCT_V·↳ IGS_EN_GEN_003·↳ IGS_FI_CREDITS_V·↳ IGS_FI_CR_ACTIVITIES·Explore IGS module →

Table: AR_BR_TRX_BATCH_RPT 12.1.1 link

owner AR·AR - Receivables·24 columns

Report table for the Automatic Transaction Batch report

AR.AR_BR_TRX_BATCH_RPT·Explore AR module →

View: IGS_FI_BILL 12.1.1

IGS - Student System·23 columns

This is a flat view on the Multi Org table IGS_FI_BILL_ALL.

APPS.IGS_FI_BILL·↳ IGS_FI_BILL_ALL·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 →

View: IGSFV_PERSON_DEPOSITS 12.1.1

IGS - Student System·77 columns

Stores all Student Deposits in Student Finance

APPS.IGSFV_PERSON_DEPOSITS·↳ GL_CODE_COMBINATIONS·↳ HZ_PARTIES·↳ IBY_PAYEE·Explore IGS module →

View: IGSFV_PARTY_CREDITS 12.1.1

IGS - Student System·86 columns

Stores all Party Credits in Student Finance

APPS.IGSFV_PARTY_CREDITS·↳ GL_CODE_COMBINATIONS·↳ HZ_PARTIES·↳ IBY_PAYEE·Explore IGS module →

View: IGS_FI_INV_INT 12.1.1

IGS - Student System·78 columns

APPS.IGS_FI_INV_INT·↳ IGS_FI_INV_INT_ALL·Explore IGS module →

Table: FTE_INVOICE_HEADERS 12.1.1 standalone

owner FTE·FTE - Transportation Execution·55 columns

Table to store invoice header information

FTE.FTE_INVOICE_HEADERS·Explore FTE module →

Table: IGS_FI_INV_INT_ALL 12.1.1 hub-leaning

owner IGS·IGS - Student System·77 columns

This interface table stores invoice data generated by invoice process.

IGS.IGS_FI_INV_INT_ALL·Explore IGS module →

Table: AR_BR_TRX_BATCH_RPT 12.2.2 link

owner AR·AR - Receivables·24 columns

Report table for the Automatic Transaction Batch report

AR.AR_BR_TRX_BATCH_RPT·Explore AR 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: IGSBV_PARTY_CHARGES 12.1.1

IGS - Student System·56 columns

Contains details of charges for a person

APPS.IGSBV_PARTY_CHARGES·↳ IGS_FI_INVLN_INT_ALL·↳ IGS_FI_INV_INT_ALL·Explore IGS module →

View: IGSBV_PERSON_DEPOSITS 12.1.1

IGS - Student System·58 columns

Stores all Student Deposits in Student Finance

APPS.IGSBV_PERSON_DEPOSITS·↳ HZ_PARTIES·↳ IGS_FI_CREDITS_ALL·↳ IGS_FI_CR_ACTIVITIES·Explore IGS module →

View: IGSBV_PARTY_CREDITS 12.1.1

IGS - Student System·62 columns

Stores all Party Credits in Student Finance

APPS.IGSBV_PARTY_CREDITS·↳ HZ_PARTIES·↳ IGS_FI_CREDITS_ALL·↳ IGS_FI_CR_ACTIVITIES·Explore IGS module →

View: IGS_AS_ORDER_PAYMENT_INFO_V 12.1.1

IGS - Student System·48 columns

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

APPS.IGS_AS_ORDER_PAYMENT_INFO_V·↳ IGS_AS_ORDER_HDR·↳ IGS_FI_APPLICATIONS·↳ IGS_FI_CREDITS_ALL·Explore IGS module →

View: IGS_FI_INV_IGF_V 12.1.1

IGS - Student System·76 columns

This view is used to fetch all the charges from the view igs_fi_inv_int. A link with igs_fi_fee_type is also made to fetch the fee class defined for the fee type.This view has been primarily created for Financial Aid Disbursement to access

APPS.IGS_FI_INV_IGF_V·↳ IGS_FI_FEE_TYPE·↳ IGS_FI_INV_INT·Explore IGS module →

View: IGSFV_PARTY_CHARGES 12.1.1

IGS - Student System·72 columns

Contains details of charges for a person

APPS.IGSFV_PARTY_CHARGES·↳ GL_CODE_COMBINATIONS·↳ HZ_PARTIES·↳ IGS_FI_1098T_SETUP·Explore IGS module →

View: IGS_FI_INV_INT_V 12.1.1

IGS - Student System·79 columns

This view is created by joining view IGS_FI_INV_INT and IGS_LOOKUPS_VIEW to resolve meaning of lookup codes.

APPS.IGS_FI_INV_INT_V·↳ IGS_FI_INV_INT·↳ IGS_LOOKUP_VALUES·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 →

VIEW: AR.AR_BR_TRX_BATCH_RPT# 12.2.2

VIEW: XNB.XNB_BILL_SUMMARIES# 12.2.2

VIEW: FTE.FTE_INVOICE_HEADERS# 12.2.2

TABLE: ISC.MLOG$_ISC_DBI_FTE_INVOICES 12.1.1

owner ISC

VIEW: APPS.IGS_FI_ACCT_V 12.1.1

View: IGS_FI_BILL 12.2.2

IGS - Student System (Obsolete)

This is a flat view on the Multi Org table IGS_FI_BILL_ALL.

Not implemented in this database·Explore IGS module →

VIEW: APPS.PAY_IN_MEDICAL_WEB_ADI_V 12.2.2

View: IGS_FI_INV_INT 12.2.2

IGS - Student System (Obsolete)

Not implemented in this database·Explore IGS module →

VIEW: AR.AR_BR_TRX_BATCH_RPT# 12.2.2

owner AR

VIEW: XNB.XNB_BILL_SUMMARIES# 12.2.2

owner XNB

TABLE: ISC.ISC_DBI_TMP_FTE_INVOICES 12.1.1

owner ISC

VIEW: FTE.FTE_INVOICE_HEADERS# 12.2.2

owner FTE

VIEW: APPS.PAY_IN_MEDICAL_WEB_ADI_V 12.1.1

TABLE: XNB.XNB_BILL_SUMMARIES 12.1.1

owner XNB

TABLE: FTE.FTE_INVOICE_HEADERS 12.2.2

owner FTE

VIEW: APPS.IGS_FI_BILL 12.1.1

TABLE: FTE.FTE_INVOICE_HEADERS 12.1.1

owner FTE

TABLE: XNB.XNB_BILL_SUMMARIES 12.2.2

owner XNB

VIEW: APPS.PAY_IN_MEDICAL_WEB_ADI_V 12.2.2

VIEW: APPS.IGS_FI_CR_ACTIVITIES_V 12.1.1

APPS.FTE_FPA_UTIL SQL Statements 12.1.1

APPS.XNB_BILL_SUMMARIES_PKG SQL Statements 12.1.1

TABLE: ISC.ISC_DBI_FTE_INVOICES_F 12.1.1

owner ISC

TABLE: AR.AR_BR_TRX_BATCH_RPT 12.2.2

owner AR

View: IGS_FI_ACCT_V 12.2.2

IGS - Student System (Obsolete)

This view contains information from two views IGS_FI_INV_INT and IGS_FI_CREDITS_V and a table IGS_FI_CR_ACTIVITES using UNION to collate information for Account History Form.

Not implemented in this database·Explore IGS module →

VIEW: APPS.PAY_IN_MEDICAL_WEB_ADI_V 12.1.1

APPS.FTE_FPA_UTIL SQL Statements 12.2.2

VIEW: APPS.IGS_FI_INV_INT 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 →

Results for “bill_number”