Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - IGS External Dependencies

This report shows external dependencies for a product. It lists views in this application that reference tables or views in other applications along with tables and views in this application that are used in the views of another application. For example, if an AR view selects from tables in AR and AP, the AR version of this report will list the AP dependencies (but not the AR ones). Please note: the report does not include dependencies to file system objects or database objects (e.g. packages) that do not appear in the Applications FND model.

Product Dependency Product
IGSusesAMS - Marketing

usesAS - Sales Foundation

usesFND - Application Object Library

usesIBC - Content Manager

used by/usesIGF - Financial Aid

usesJTF - CRM Foundation

usesPER - Human Resources

AMS - Marketing

IGS Item Dependency AMS Item
View APPS.IGR_I_APPL_V uses View APPS.AMS_LOOKUPS

uses View APPS.AMS_P_SOURCE_CODES_V
View APPS.IGR_I_A_ITYPE_V uses View APPS.AMS_P_DELIVERABLES_V
View APPS.IGR_I_A_PKGITM_V uses View APPS.AMS_P_DELIVERABLES_V
View APPS.IGR_I_INFO_TYPES_V uses View APPS.AMS_P_DELIVERABLES_V
View APPS.IGR_I_ITYP_PKGS_V uses View APPS.AMS_P_DELIVERABLES_V

uses View APPS.AMS_P_DELIV_KIT_ITEMS_V
View APPS.IGR_I_PKGITM_ASSIGN_V uses View APPS.AMS_P_DELIVERABLES_V
View APPS.IGR_I_PKG_ITEMS_V uses View APPS.AMS_P_DELIVERABLES_V

9 dependencies

[top of page]

AS - Sales Foundation

IGS Item Dependency AS Item
View APPS.IGR_I_APPL uses View APPS.AS_SALES_LEADS_V
View APPS.IGR_I_APPL_V uses View APPS.AS_STATUSES_VL
View APPS.IGR_I_A_ITYPE_V uses View APPS.AS_SALES_LEADS_V
View APPS.IGR_I_A_PKGITM_V uses View APPS.AS_SALES_LEADS_V
View APPS.IGR_I_STATUS_V uses View APPS.AS_STATUSES_VL

5 dependencies

[top of page]

FND - Application Object Library

IGS Item Dependency FND Item
View APPS.IGR_I_INQUIRY_TYPES_V uses View APPS.FND_FORM_FUNCTIONS_VL
View APPS.IGSBV_CITIZENSHIP_COUNTRIES uses View APPS.FND_TERRITORIES_VL
View APPS.IGSFV_AD_ADM_APPL_TYP uses View APPS.FND_FORM_FUNCTIONS_VL
View APPS.IGSFV_CITIZENSHIP_COUNTRIES uses View APPS.FND_TERRITORIES_VL
View APPS.IGSFV_PERSON_HOLDS uses View APPS.FND_RESPONSIBILITY_VL
View APPS.IGSFV_RESIDENCY_COUNTRIES uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_AD_INQ_ENTRY_STAT_V uses View APPS.FND_FORM_FUNCTIONS_VL
View APPS.IGS_AD_LOCVENUE_ADDR_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_AD_RVGR_INC_EXC_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_AD_SS_APPL_TYP_V uses View APPS.FND_FORM_FUNCTIONS_VL
View APPS.IGS_AD_VISA_TYPE_V uses View APPS.FND_COMMON_LOOKUPS
View APPS.IGS_DA_CNFG_V uses View APPS.FND_RESPONSIBILITY_VL
View APPS.IGS_DA_FTR_VALUES uses View APPS.FND_LOOKUP_VALUES_VL
View APPS.IGS_FI_PARTIES_V uses View APPS.FND_LOOKUP_VALUES_VL
View APPS.IGS_GE_CFG_FORM_V uses View APPS.FND_FORM_VL
View APPS.IGS_PE_ADDR_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_CITIZENSHIP_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_EIT_COUNTRY_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_EIT_PERM_RES_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_HZ_PARTIES_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_INCOME_TAX_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_INTL_DEPD_V uses View APPS.FND_LOOKUP_VALUES_VL
View APPS.IGS_PE_LANGUAGES_V uses View APPS.FND_LANGUAGES_VL
View APPS.IGS_PE_PASSPORT_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_PERSON_ADDR_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_PERS_ENCUMB_V uses View APPS.FND_RESPONSIBILITY_VL
View APPS.IGS_PE_SS_ADDR_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_VISA_V uses View APPS.FND_TERRITORIES_VL
View APPS.IGS_PE_VOTE_INFO_V uses View APPS.FND_TERRITORIES_VL

29 dependencies

[top of page]

IBC - Content Manager

IGS Item Dependency IBC Item
View APPS.IGS_CO_INTERACTION_HISTORY_V uses View APPS.IBC_CITEMS_V
View APPS.IGS_CO_MAPPING_V uses View APPS.IBC_CITEMS_V

2 dependencies

[top of page]

IGF - Financial Aid

IGS Item Dependency IGF Item
View APPS.IGSFV_PERSON_FUND_EXCL uses View APPS.IGF_AW_FUND_CAT
View APPS.IGS_AD_ACAD_HISTORY_V used by View APPS.IGF_AW_AWD_LTR_V
View APPS.IGS_AD_LOCATION used by View APPS.IGF_AP_IA_LOOKUP_V
View APPS.IGS_CA_INST used by View APPS.IGF_AP_APPL_SETUP_V

used by View APPS.IGF_AP_APP_ST_APLINST_V

used by View APPS.IGF_AP_ATTEND_MAP_V

used by View APPS.IGF_AP_AWARD_YEAR_V

used by View APPS.IGF_AP_BATCH_AW_MAP_V

used by View APPS.IGF_AP_EFC_DET_V

used by View APPS.IGF_AP_EFC_MULT_FCT_V

used by View APPS.IGF_AP_EFC_V

used by View APPS.IGF_AP_FA_ANT_DATA_V

used by View APPS.IGF_AP_FA_BASE_H_V

used by View APPS.IGF_AP_FA_BASE_RESULTS_V

used by View APPS.IGF_AP_HOUSING_MAP_V

used by View APPS.IGF_AP_RW_UNMATCH_REC_V

used by View APPS.IGF_AP_TD_ITEM_MST_V

used by View APPS.IGF_AW_AWARD_V

used by View APPS.IGF_AW_AWDS_SUM_V

used by View APPS.IGF_AW_AWD_APT_V

used by View APPS.IGF_AW_AWD_AP_V

used by View APPS.IGF_AW_AWD_CERT_RESPS_V

used by View APPS.IGF_AW_AWD_DISB_V

used by View APPS.IGF_AW_AWD_FRML_DET_V

used by View APPS.IGF_AW_AWD_LD_CAL_V

used by View APPS.IGF_AW_CAL_REL_V

used by View APPS.IGF_AW_CIT_LD_OVERIDE_V

used by View APPS.IGF_AW_COA_GROUP_V

used by View APPS.IGF_AW_COA_GRP_ITEM_V

used by View APPS.IGF_AW_COA_HIST_V

used by View APPS.IGF_AW_COA_ITM_TERMS_V

used by View APPS.IGF_AW_COA_LD_V

used by View APPS.IGF_AW_COA_RATE_DET_V

used by View APPS.IGF_AW_COA_RATE_MST_V

used by View APPS.IGF_AW_COA_TERM_TOT_V

used by View APPS.IGF_AW_CORRESP_LD_V

used by View APPS.IGF_AW_DP_TEACH_PRDS_V

used by View APPS.IGF_AW_DP_TERMS_V

used by View APPS.IGF_AW_FISAP_REPSET_V

used by View APPS.IGF_AW_FISAP_REP_V

used by View APPS.IGF_AW_FN_RPKG_PRTY_V

used by View APPS.IGF_AW_FUND_DET_GRP_V

used by View APPS.IGF_AW_FUND_MAST_V

used by View APPS.IGF_AW_FUND_ROLLOVER_V

used by View APPS.IGF_AW_FUND_TP_V

used by View APPS.IGF_AW_LOAD_CAL_V

used by View APPS.IGF_AW_LOAN_LIMIT_V

used by View APPS.IGF_AW_STUD_AWDS_V

used by View APPS.IGF_AW_TARGET_GRP_V

used by View APPS.IGF_AW_TERM_MAP_V

used by View APPS.IGF_AW_TP_INSTMT_V

used by View APPS.IGF_GR_ALT_COA_V

used by View APPS.IGF_GR_ATTEND_PELL_V

used by View APPS.IGF_GR_PELL_COA_RNG_V

used by View APPS.IGF_GR_PELL_RNG_AMT_V

used by View APPS.IGF_GR_PELL_SETUP_V

used by View APPS.IGF_GR_REPORT_PELL_V

used by View APPS.IGF_GR_RFMS_V

used by View APPS.IGF_GR_TUITION_FEES_V

used by View APPS.IGF_SE_AUTH_V

used by View APPS.IGF_SE_AWD_DISB_V

used by View APPS.IGF_SE_EARNINGS_SUMMARY_V

used by View APPS.IGF_SL_CL_SETUP_ORG_V

used by View APPS.IGF_SL_CL_SETUP_OVRD_V

used by View APPS.IGF_SL_CL_SETUP_V

used by View APPS.IGF_SL_DL_SETUP_V

used by View APPS.IGF_SL_LOANS_V

used by View APPS.IGF_SL_LOR_V

used by View APPS.IGF_SL_PE_CITI_MAP_V

used by View APPS.IGF_SL_PLUS_LOAN_DETAILS_V

used by View APPS.IGF_SP_AWARD_V

used by View APPS.IGF_SP_FUND_MAST_V

used by View APPS.IGF_SP_STDNT_REL_V
View APPS.IGS_CA_TYPE_V used by View APPS.IGF_AW_LOAD_CAL_V
View APPS.IGS_EN_ATD_MODE used by View APPS.IGF_AP_IA_LOOKUP_V
View APPS.IGS_EN_ATD_TYPE used by View APPS.IGF_AP_AWYR_ATMAP_V

used by View APPS.IGF_AP_IA_LOOKUP_V

used by View APPS.IGF_AW_AWD_DISB_V

used by View APPS.IGF_AW_DP_TEACH_PRDS_V

used by View APPS.IGF_AW_FUND_MAST_V

used by View APPS.IGF_SP_FUND_MAST_V

used by View APPS.IGF_SP_STDNT_REL_V
View APPS.IGS_FI_BILL_PLN_CRD_V uses View APPS.IGF_AW_FUND_MAST
View APPS.IGS_FI_CREDITS_V uses View APPS.IGF_LOOKUPS_VIEW
View APPS.IGS_FI_CR_TYPES used by View APPS.IGF_AW_FUND_MAST_V

used by View APPS.IGF_SP_FUND_MAST_V
View APPS.IGS_FI_ENCMB_TYPE used by View APPS.IGF_AP_FA_BASE_H_V
View APPS.IGS_FI_PARTIES_V used by View APPS.IGF_SP_FUND_MAST_V
View APPS.IGS_FI_PLN_CREDITS_V uses View APPS.IGF_AP_BATCH_AW_MAP

uses View APPS.IGF_AP_FA_BASE_REC

uses View APPS.IGF_AW_AWARD

uses View APPS.IGF_AW_AWD_DISB

uses View APPS.IGF_AW_FUND_MAST
View APPS.IGS_LOOKUPS_VIEW used by View APPS.IGF_AP_HOUSING_MAP_V

used by View APPS.IGF_AP_IA_LOOKUP_V

used by View APPS.IGF_AW_FUND_FEECLAS_V

used by View APPS.IGF_SL_LOR_DTLS_V

used by View APPS.IGF_SL_PE_CITI_MAP_V

used by View APPS.IGF_SP_FC_V

used by View APPS.IGF_SP_STD_FC_V
View APPS.IGS_LOOKUP_VALUES used by View APPS.IGF_AP_PERS_NOTE_V

used by View APPS.IGF_SL_PLUS_LOAN_DETAILS_V
View APPS.IGS_OR_INST_ORG_BASE_V used by View APPS.IGF_SL_CL_SETUP_ORG_V

used by View APPS.IGF_SL_CL_SETUP_OVRD_V

used by View APPS.IGF_SL_GUARANTOR_V

used by View APPS.IGF_SL_LENDER_BRC_V

used by View APPS.IGF_SL_LENDER_V

used by View APPS.IGF_SL_SERVICER_BRC_V

used by View APPS.IGF_SL_SERVICER_V
View APPS.IGS_OR_UNIT used by View APPS.IGF_AP_IA_LOOKUP_V
View APPS.IGS_PE_FUND_EXCL_V uses View APPS.IGF_AW_FUND_CAT
View APPS.IGS_PE_PERSID_GROUP used by View APPS.IGF_AW_FUND_MAST_V

used by View APPS.IGF_SP_FUND_MAST_V
View APPS.IGS_PE_PERSON used by View APPS.IGF_AP_APP_ST_APLINST_V
View APPS.IGS_PE_PERSON_BASE_V used by View APPS.IGF_SL_LOANS_SUM_V

used by View APPS.IGF_SL_PLUS_LOAN_DETAILS_V

used by View APPS.IGF_SP_STDNT_REL_V
View APPS.IGS_PR_CLASS_STD_V used by View APPS.IGF_AP_IA_LOOKUP_V
View APPS.IGS_PS_TYPE used by View APPS.IGF_AP_PR_PRG_TYPE_V
View APPS.IGS_PS_TYPE_V used by View APPS.IGF_AP_IA_LOOKUP_V
View APPS.IGS_PS_UNIT_VER used by View APPS.IGF_AW_FUND_UNIT_V

used by View APPS.IGF_SP_STD_UNIT_V

used by View APPS.IGF_SP_UNIT_V
View APPS.IGS_PS_VER used by View APPS.IGF_AP_IA_LOOKUP_V

used by View APPS.IGF_AW_FUND_PRG_V

used by View APPS.IGF_GR_PELL_SETUP_V

used by View APPS.IGF_SP_PRG_V

used by View APPS.IGF_SP_STD_PRG_V

128 dependencies

[top of page]

JTF - CRM Foundation

IGS Item Dependency JTF Item
View APPS.IGS_CO_INTERACTION_HISTORY_V uses View APPS.JTF_FM_REQUEST_HISTORY

1 dependencies

[top of page]

PER - Human Resources

IGS Item Dependency PER Item
View APPS.IGS_FI_CONTROL_V uses View APPS.HR_OPERATING_UNITS
View APPS.IGS_PE_HR_EMP_CAT_V uses View APPS.HR_LOOKUPS
View APPS.IGS_PE_PER_TYPE_MAP_V uses View APPS.PER_PERSON_TYPES_V
View APPS.IGS_PS_EMP_CATS_WL_HR_V uses View APPS.HR_LOOKUPS

4 dependencies

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract