Table: IGS_FI_LB_CR_TYPES | Oracle EBS ETRM Search

Table: IGS_FI_LB_CR_TYPES 12.1.1 link

owner IGS·IGS - Student System·8 columns

Table to store the mapping of bank-supplied codes to pre-defined Credit Types in the context of a Lockbox.

IGS.IGS_FI_LB_CR_TYPES·Explore IGS module →

Table: IGS_FI_BAL_EX_C_TYPS 12.1.1 link

owner IGS·IGS - Student System·9 columns

This table captures information of Credit Types that need to be ignored for Balance Calculation.

IGS.IGS_FI_BAL_EX_C_TYPS·Explore IGS module →

Table: IGS_FI_A_HIERARCHIES 12.1.1 hub-leaning

owner IGS·IGS - Student System·12 columns

Captures application hierarchies setup information from the Define Application Hierarchy form along with information about the credit type associated with this hierarchy.

IGS.IGS_FI_A_HIERARCHIES·Explore IGS module →

View: IGS_FI_BAL_EX_C_TYPS_V 12.1.1

IGS - Student System·12 columns

This view is created by joining table IGS_FI_BAL_EX_C_TYPS and view IGS_FI_CR_TYPE to obtain Credit Type Name and Description by resolving foreign keys

APPS.IGS_FI_BAL_EX_C_TYPS_V·↳ IGS_FI_BAL_EX_C_TYPS·↳ IGS_FI_CR_TYPES·Explore IGS module →

Table: ASF_WIN_LOSS_PRODCAT_MV 12.1.1 standalone

ASF - Sales Online·13 columns

APPS.ASF_WIN_LOSS_PRODCAT_MV·Explore ASF module →

Table: ASF_WIN_LOSS_COMPTATOR_MV 12.1.1 standalone

ASF - Sales Online·15 columns

APPS.ASF_WIN_LOSS_COMPTATOR_MV·Explore ASF module →

Table: CN_CREDIT_TYPES_ALL_TL 12.2.2 standalone

owner CN·CN - Incentive Compensation·12 columns

Credit Types Information

CN.CN_CREDIT_TYPES_ALL_TL·Explore CN module →

View: IGS_FI_LB_CR_TYPES_V 12.1.1

IGS - Student System·10 columns

Form view used to show the mapping of bank-supplied codes with pre-defined Credit Types in the context of a Lockbox.

APPS.IGS_FI_LB_CR_TYPES_V·↳ IGS_FI_CR_TYPES·↳ IGS_FI_LB_CR_TYPES·Explore IGS module →

Table: ASF_OPP_CMP_FRCST_MV 12.1.1 standalone

ASF - Sales Online·17 columns

APPS.ASF_OPP_CMP_FRCST_MV·Explore ASF module →

Table: ASF_WIN_WON_TOP5_MV 12.1.1 standalone

ASF - Sales Online·20 columns

APPS.ASF_WIN_WON_TOP5_MV·Explore ASF module →

View: IGS_FI_A_HIERARCHIES_V 12.1.1

IGS - Student System·14 columns

This view is created to obtain credit type name from IGS_FI_CR_TYPES view resolving foreign keys

APPS.IGS_FI_A_HIERARCHIES_V·↳ IGS_FI_A_HIERARCHIES·Explore IGS module →

Table: ASF_WIN_LOSS_MV 12.1.1 standalone

ASF - Sales Online·11 columns

APPS.ASF_WIN_LOSS_MV·Explore ASF module →

Table: CN_CREDIT_TYPES_ALL_TL 12.1.1 standalone

owner CN·CN - Incentive Compensation·11 columns

Credit Types Information

CN.CN_CREDIT_TYPES_ALL_TL·Explore CN module →

View: IGS_FI_BILL_DPSTS_V 12.1.1

IGS - Student System·15 columns

View for retrieving the records from Billing Deposits.

APPS.IGS_FI_BILL_DPSTS_V·↳ IGS_FI_BILL_DPSTS·↳ IGS_FI_CREDITS·↳ IGS_FI_CR_ACTIVITIES·Explore IGS module →

Table: BIL_BI_FST_DTL_F 12.1.1 standalone

owner BIL·BIL - Sales Intelligence·23 columns

Sales Forecast Base Summary table contains the summarized data for forecast by period for each sales group and salesperson.

BIL.BIL_BI_FST_DTL_F·Explore BIL module →

Table: ASF_OPP_CHN_FRCST_MV 12.1.1 standalone

ASF - Sales Online·17 columns

APPS.ASF_OPP_CHN_FRCST_MV·Explore ASF module →

Table: ASF_OPP_PRD_MV 12.1.1 standalone

ASF - Sales Online·15 columns

APPS.ASF_OPP_PRD_MV·Explore ASF module →

Table: ASF_SC_BIN_FRCST_MV 12.1.1 standalone

ASF - Sales Online·15 columns

APPS.ASF_SC_BIN_FRCST_MV·Explore ASF module →

Table: ASF_VAR_MV 12.1.1 standalone

ASF - Sales Online·16 columns

APPS.ASF_VAR_MV·Explore ASF module →

Table: BIL_OBI_FST_PG_MV 12.1.1 standalone

FND - Application Object Library·26 columns

APPS.BIL_OBI_FST_PG_MV·Explore FND module →

Table: BIL_BI_FST_DTL_STG 12.1.1 standalone

owner BIL·BIL - Sales Intelligence·31 columns

Staging table used to populate the fact table BIL_BI_FST_DTL_F

BIL.BIL_BI_FST_DTL_STG·Explore BIL module →

Table: IGS_FI_WAIVER_PGMS 12.1.1 satellite-leaning

owner IGS·IGS - Student System·19 columns

Stores the Waiver Programs defined in the system and the related information.

IGS.IGS_FI_WAIVER_PGMS·Explore IGS module →

Table: CN_CREDIT_TYPES_ALL_B 12.1.1 hub-leaning

owner CN·CN - Incentive Compensation·29 columns

Credit Types

CN.CN_CREDIT_TYPES_ALL_B·Explore CN module →

Table: ASF_WIN_LOSS_TOP5_MV 12.1.1 standalone

ASF - Sales Online·20 columns

APPS.ASF_WIN_LOSS_TOP5_MV·Explore ASF module →

Table: AS_SALES_CREDITS_LOG 12.2.2 standalone

owner OSM·AS - Sales Foundation·20 columns

Holds sales credit change history

OSM.AS_SALES_CREDITS_LOG·Explore AS module →

Table: AS_SALES_CREDITS_LOG 12.1.1 standalone

owner OSM·AS - Sales Foundation·20 columns

Holds sales credit change history

OSM.AS_SALES_CREDITS_LOG·Explore AS module →

Table: BIL_BI_PROCESSED_FST_ID 12.1.1 standalone

owner BIL·BIL - Sales Intelligence·21 columns

Table that stores all processed forecasts. It is cummulative for all runs of the concurrent program tat populates the fact table.

BIL.BIL_BI_PROCESSED_FST_ID·Explore BIL module →

View: IGS_FI_PLN_CREDITS_V 12.1.1

IGS - Student System·23 columns

APPS.IGS_FI_PLN_CREDITS_V·↳ IGF_AP_BATCH_AW_MAP·↳ IGF_AP_FA_BASE_REC·↳ IGF_AW_AWARD·Explore IGS module →

Table: ASF_OPP_TOP_FRCST_MV 12.1.1 standalone

ASF - Sales Online·25 columns

APPS.ASF_OPP_TOP_FRCST_MV·Explore ASF module →

Table: AS_INTERNAL_FORECASTS 12.2.2 satellite-leaning

owner OSM·AS - Sales Foundation·62 columns

Table to store the summary forecast information for individual or group

OSM.AS_INTERNAL_FORECASTS·Explore AS module →

Table: CN_POSTING_DETAILS_SUM_ALL 12.1.1 standalone

owner CN·CN - Incentive Compensation·41 columns

This table contains the summarized information from cn_posting_details

CN.CN_POSTING_DETAILS_SUM_ALL·Explore CN 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_CR_TYPES 12.1.1

IGS - Student System·46 columns

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

APPS.IGS_FI_CR_TYPES·↳ IGS_FI_CR_TYPES_ALL·Explore IGS module →

Table: CN_CREDIT_TYPES_ALL_B 12.2.2 hub

owner CN·CN - Incentive Compensation·30 columns

Credit Types

CN.CN_CREDIT_TYPES_ALL_B·Explore CN module →

View: ASF_FRCST_SUM_REPRT_V 12.2.2

ASF - Sales Online·50 columns

APPS.ASF_FRCST_SUM_REPRT_V·↳ AS_MC_SALES_CREDITS_DEN·↳ AS_OPP_WORKSHEET_LINES·↳ AS_SALES_CREDITS_DENORM·Explore ASF module →

View: ASF_FRCST_SUM_REPRT_V 12.1.1

ASF - Sales Online·50 columns

APPS.ASF_FRCST_SUM_REPRT_V·↳ AS_MC_SALES_CREDITS_DEN·↳ AS_OPP_WORKSHEET_LINES·↳ AS_SALES_CREDITS_DENORM·Explore ASF module →

Table: CN_SRP_PMT_PLANS_ALL 12.1.1 satellite-leaning

owner CN·CN - Incentive Compensation·37 columns

CN_SRP_PMT_PLANS contains information of payment plans assigned to salespeople. You need one row for each payment plan assignment to a saleperson which is date effective.

CN.CN_SRP_PMT_PLANS_ALL·Explore CN module →

Table: CN_SRP_PERIOD_PAYEES_ALL 12.1.1 standalone

owner CN·CN - Incentive Compensation·33 columns

Internal process tables which maintains information for a payee as part of calculation

CN.CN_SRP_PERIOD_PAYEES_ALL·Explore CN module →

Table: CN_PMT_PLANS_ALL 12.2.2 satellite-leaning

owner CN·CN - Incentive Compensation·39 columns

This table stores information regarding the payment plans used to affect the compensation paid to sales people

CN.CN_PMT_PLANS_ALL·Explore CN module →

Table: CN_SRP_PERIOD_PAYEES_ALL 12.2.2 standalone

owner CN·CN - Incentive Compensation·33 columns

Internal process tables which maintains information for a payee as part of calculation

CN.CN_SRP_PERIOD_PAYEES_ALL·Explore CN module →

Table: CN_PAYMENT_TRANSACTIONS_ALL 12.1.1 standalone

owner CN·CN - Incentive Compensation·58 columns

This table is used by the payment module to store the details for each payment worksheet. The records that are created in this table are dependent on the value of the profile Pay by Transaction. When this profile is set to Y(es), the data i

CN.CN_PAYMENT_TRANSACTIONS_ALL·Explore CN module →

Table: AS_PROD_WORKSHEET_LINES 12.2.2 link

owner OSM·AS - Sales Foundation·64 columns

Table to store the forecast information on all possible product categories for individual or sales group

OSM.AS_PROD_WORKSHEET_LINES·Explore AS module →

Table: CN_SRP_PMT_PLANS_ALL 12.2.2 satellite-leaning

owner CN·CN - Incentive Compensation·37 columns

CN_SRP_PMT_PLANS contains information of payment plans assigned to salespeople. You need one row for each payment plan assignment to a saleperson which is date effective.

CN.CN_SRP_PMT_PLANS_ALL·Explore CN module →

Table: CN_PMT_PLANS_ALL 12.1.1 satellite-leaning

owner CN·CN - Incentive Compensation·39 columns

This table stores information regarding the payment plans used to affect the compensation paid to sales people

CN.CN_PMT_PLANS_ALL·Explore CN module →

View: AST_LM_OPP_EXP_CR_TYPE_V 12.2.2

AST - TeleSales·58 columns

APPS.AST_LM_OPP_EXP_CR_TYPE_V·↳ AMS_SOURCE_CODES·↳ AS_LEADS_ALL·↳ AS_LEAD_CONTACTS_ALL·Explore AST module →

View: IGS_FI_CRD_INT 12.1.1

IGS - Student System·55 columns

No longer used.

APPS.IGS_FI_CRD_INT·↳ IGS_FI_CRD_INT_ALL·Explore IGS module →