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 - SQLGL 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
SQLGLused byAMW - Internal Controls Manager

used byAR - Receivables

used byBIS - Applications BIS

used byBOM - Bills of Material

used byCE - Cash Management

used byEC - e-Commerce Gateway

used byFII - Financial Intelligence

used by/usesFND - Application Object Library

used byGMS - Grants Accounting

used byHRI - Human Resources Intelligence

used byIBE - iStore

used byICX - Oracle iProcurement

used byIGC - Contract Commitment

used byIGI - Public Sector Financials International

used byIGS - Student System

used byINV - Inventory

used byISC - Supply Chain Intelligence

used byITG - Internet Procurement Enterprise Connector

used byJA - Asia/Pacific Localizations

used byJE - European Localizations

used byJG - Regional Localizations

used byJL - Latin America Localizations

used byMSD - Demand Planning

used byOE - Order Entry

used byOFA - Assets

used byOKE - Project Contracts

used byOKL - Leasing and Finance Management

used byOKX - Contracts Integration

used byONT - Order Management

used byOPI - Operations Intelligence

used byOTA - Learning Management

used by/usesPA - Projects

used byPAY - Payroll

used by/usesPER - Human Resources

used byPJI - Project Intelligence

used byPJM - Project Manufacturing

used byPMI - Process Manufacturing Intelligence

used byPN - Property Manager

used byPO - Purchasing

used byPQH - Public Sector HR

used byPSA - Public Sector Financials

used byPSB - Public Sector Budgeting

used byRG - Application Report Generator

used byXLA - Subledger Accounting

used byXTR - Treasury

AMW - Internal Controls Manager

SQLGL Item Dependency AMW Item
View APPS.GL_PERIODS_V used by View APPS.AMW_GL_PERIODS_V

1 dependencies

[top of page]

AR - Receivables

SQLGL Item Dependency AR Item
View APPS.GL_LEDGERS_PUBLIC_V used by View APPS.ARFV_ADJ_DISTS_ALC_V

used by View APPS.ARFV_APP_DISTS_ALC_V

used by View APPS.ARFV_CASH_DISTS_ALC_V

used by View APPS.ARFV_FREIGHT_DISTS_ALC_V

used by View APPS.ARFV_REVENUE_DISTS_ALC_V

used by View APPS.ARFV_TAX_DISTS_ALC_V

used by View APPS.ARFV_UNREC_DISTS_ALC_V

used by View APPS.ARFV_UNREV_DISTS_ALC_V
View APPS.GL_LOOKUPS used by View APPS.AR_POSTED_TRANSACTIONS_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.ARFV_APP_DISTS_ALT_CRNCY

used by View APPS.ARFV_CASH_DISTS_ALT_CRNCY

used by View APPS.ARFV_FREIGHT_DISTS_ALT_CRNCY

used by View APPS.ARFV_REVENUE_DISTS_ALT_CRNCY

used by View APPS.ARFV_TAX_DISTS_ALT_CRNCY

used by View APPS.ARFV_UNREC_DISTS_ALT_CRNCY

used by View APPS.ARFV_UNREV_DISTS_ALT_CRNCY

used by View APPS.AR_ALL_ENABLED_CURRENCIES_V

used by View APPS.AR_CM_NET_REVENUE_ASSIGNMENTS

used by View APPS.AR_CM_NET_REV_ASSIGNMENTS_FRM

used by View APPS.AR_LINE_CONTINGENCIES_V

used by View APPS.AR_LINE_EXCEPTIONS_V

used by View APPS.AR_LINE_REVENUE_DETAILS_V

used by View APPS.AR_REVENUE_ASSIGNMENTS

used by View APPS.AR_RX_OTHER_APPLICATIONS_V

24 dependencies

[top of page]

BIS - Applications BIS

SQLGL Item Dependency BIS Item
View APPS.GL_LEDGER_LE_V used by View APPS.BIS_MONTHS_V

used by View APPS.BIS_QUARTERS_V

used by View APPS.BIS_YEARS_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.BIS_GL_COMPANIES_V

used by View APPS.BIS_GL_SECONDARY_MEASURES_V

used by View APPS.BIS_MONTHS_V

used by View APPS.BIS_QUARTERS_V

used by View APPS.BIS_SETS_OF_BOOKS_V

used by View APPS.BIS_YEARS_V

9 dependencies

[top of page]

BOM - Bills of Material

SQLGL Item Dependency BOM Item
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.CST_MTL_RCV_TXN_V
View APPS.GL_LEDGER_LE_V used by View APPS.CST_MTL_RCV_TXN_V

used by View APPS.CST_PAC_LEGAL_ENTITIES_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.CSTFV_LE_COST_TYPES

used by View APPS.CST_AEL_GL_INV_V

used by View APPS.CST_AEL_GL_WIP_V

used by View APPS.CST_AEL_SL_INV_V

used by View APPS.CST_AEL_SL_WIP_V

used by View APPS.CST_GL_TRANSLATION_VIEW

used by View APPS.CST_LE_COST_TYPES_V

used by View APPS.CST_PAC_AEL_GL_INV_V

used by View APPS.CST_PROJMFG_CMT_BASIC_V
View APPS.GL_TRANSLATION_RATES used by View APPS.CST_GL_TRANSLATION_VIEW

13 dependencies

[top of page]

CE - Cash Management

SQLGL Item Dependency CE Item
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.CE_FC_AMTS_GLCP_V

used by View APPS.CE_FC_AMTS_SRC_GLCP_V
View APPS.GL_LOOKUPS used by View APPS.CE_101_RECONCILED_V

used by View APPS.CE_101_TRANSACTIONS_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.CEBV_CASH_FORECAST_CELLS

used by View APPS.CEFV_CASH_FORECAST_CELLS

used by View APPS.CE_101_RECONCILED_V

used by View APPS.CE_101_TRANSACTIONS_V

used by View APPS.CE_185_TRANSACTIONS_V

used by View APPS.CE_200_BATCHES_V

used by View APPS.CE_200_REVERSAL_V

used by View APPS.CE_200_TRANSACTIONS_V

used by View APPS.CE_222_BATCHES_V

used by View APPS.CE_222_TRANSACTIONS_V

used by View APPS.CE_222_TXN_FOR_BATCH_V

used by View APPS.CE_260_CF_REVERSAL_V

used by View APPS.CE_260_CF_TRANSACTIONS_V

used by View APPS.CE_260_RECONCILED_V

used by View APPS.CE_260_TRANSACTIONS_V

used by View APPS.CE_801_EFT_RECONCILED_V

used by View APPS.CE_801_EFT_TRANSACTIONS_V

used by View APPS.CE_801_RECONCILED_V

used by View APPS.CE_801_TRANSACTIONS_V

used by View APPS.CE_999_RECONCILED_V

used by View APPS.CE_999_REVERSAL_V

used by View APPS.CE_999_TRANSACTIONS_V

used by View APPS.CE_FORECAST_AP_ORGS_V

used by View APPS.CE_FORECAST_AR_ORGS_V

used by View APPS.CE_FORECAST_AS_ORGS_V

used by View APPS.CE_FORECAST_OE_ORGS_V

used by View APPS.CE_FORECAST_PAY_ORGS_V

used by View APPS.CE_FORECAST_PA_ORGS_V

used by View APPS.CE_FORECAST_PO_ORGS_V

used by View APPS.CE_FORECAST_ROWS_V

used by View APPS.CE_LE_BG_OU_VS_V

used by View APPS.CE_MISC_TRANSACTIONS_V

used by View APPS.CE_PO_FC_NO_TERMS_TEMP_V

used by View APPS.CE_PO_FC_ORDERS_NO_TERMS_V

used by View APPS.CE_PO_FC_ORDERS_TEMP_V

used by View APPS.CE_PO_FC_ORDERS_TERMS_TEMP_V

used by View APPS.CE_PO_FC_ORDERS_TERMS_V

used by View APPS.CE_PO_FC_REQUISITIONS_TEMP_V

used by View APPS.CE_PO_FC_REQUISITIONS_V

used by View APPS.CE_REVERSAL_AR_TRX_V

used by View APPS.CE_SECURITY_PROFILES_V

used by View APPS.CE_SYSTEM_PARAMETERS_V

46 dependencies

[top of page]

EC - e-Commerce Gateway

SQLGL Item Dependency EC Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.ECE_CDMO_HEADER_1_V

used by View APPS.ECE_CDMO_HEADER_V

used by View APPS.ECE_INO_HEADER_1_V

3 dependencies

[top of page]

FII - Financial Intelligence

SQLGL Item Dependency FII Item
View APPS.GL_LEDGERS_PUBLIC_V used by View APPS.FII_ALL_LEDGER_V

used by View APPS.FII_GL_BOOK_V

used by View APPS.FII_LEDGER_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.EDW_GL_BOOK_MPV

used by View APPS.FIIBV_AP_HOLD_DATA_FCV

used by View APPS.FIIBV_AP_INV_LINES_FCV

used by View APPS.FIIBV_AP_INV_ON_HOLD_FCV

used by View APPS.FIIBV_AP_INV_PAYMTS_FCV

used by View APPS.FIIBV_AP_SCH_PAYMTS_FCV

used by View APPS.FIIBV_GL_BOOK_BOOK_LCV

used by View APPS.FIIBV_GL_BOOK_FA_BOOK_LCV

used by View APPS.FIIBV_PA_BUDGET_F_FCV

used by View APPS.FIIBV_PA_COST_F_FCV

used by View APPS.FIIBV_PA_REVENUE_F_FCV

used by View APPS.FII_AR_CASH_FCV

used by View APPS.FII_AR_OLTP_CASH_V

used by View APPS.FII_AR_OLTP_INV_V

used by View APPS.FII_AR_OLTP_OPEN_INV_V

used by View APPS.FII_AR_REC_FCV

used by View APPS.FII_LEDGERS_V

used by View APPS.FII_OU_LEDGER_V

21 dependencies

[top of page]

FND - Application Object Library

SQLGL Item Dependency FND Item
View APPS.GL_COA_MAPPINGS_V uses View APPS.FND_ID_FLEX_STRUCTURES_V
View APPS.GL_DEFAS_ASSIGNMENTS_V uses View APPS.FND_OBJECTS_VL
View APPS.GL_LEDGERS_PUBLIC_ALL_V used by View APPS.FND_MO_REPORTING_ENTITIES_V
View APPS.GL_SRS_RECON_CURRENCIES_V uses View APPS.FND_CURRENCIES_VL
View APPS.GL_TAX_CODES_V uses View APPS.ZX_RATES_VL

5 dependencies

[top of page]

GMS - Grants Accounting

SQLGL Item Dependency GMS Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.GMS_DRAFT_INVOICES_V

1 dependencies

[top of page]

HRI - Human Resources Intelligence

SQLGL Item Dependency HRI Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.EDWBV_ORGA_LEG_ENTITY_LCV

1 dependencies

[top of page]

IBE - iStore

SQLGL Item Dependency IBE Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.IBE_BI_CURRENCY_V

1 dependencies

[top of page]

ICX - Oracle iProcurement

SQLGL Item Dependency ICX Item
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.ICX_PO_REQ_LINES_DIST_V

used by View APPS.ICX_REQ_DIST_UPDATE_V

used by View APPS.POR_VIEW_DIST_LINES_V

used by View APPS.POR_VIEW_LINE_DETAILS_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.ICX_CART_LINE_ACCOUNT_HEADER_V

used by View APPS.ICX_EDM_COST_GROUP_INV_V

used by View APPS.ICX_EDM_PURCHASE_REQ_V

used by View APPS.ICX_POR_EXT_ACTIVE_CONTRACTS

used by View APPS.ICX_POR_EXT_INACTIVE_CONTRACTS

used by View APPS.ICX_POR_REQ_ACTIVE_CONTRACTS

used by View APPS.ICX_POR_REQ_ASLS

used by View APPS.ICX_POR_REQ_CONTRACTS

used by View APPS.ICX_POR_REQ_INACTIVE_CONTRACTS

used by View APPS.ICX_POR_REQ_TEMPLATES

used by View APPS.ICX_POR_SEARCH_ASLS_V

used by View APPS.ICX_POR_SEARCH_CONTRACTS_V

used by View APPS.ICX_POR_SEARCH_ITEM_MASTER_V

used by View APPS.ICX_PO_OPEN_REQS_BY_USERS_V

used by View APPS.ICX_PO_REQS_BY_USERS_V

used by View APPS.ICX_PO_REQUISITION_HEADERS_V

used by View APPS.ICX_PO_REQUISITION_LINES_INQ_V

used by View APPS.ICX_PO_REQUISITION_OPEN_V

used by View APPS.ICX_PO_REQUISITION_TEMPLATES_V

used by View APPS.ICX_PO_REQ_HEADERS_V

used by View APPS.ICX_PO_REQ_LINES_DIST_V

used by View APPS.ICX_PO_REQ_LINES_V

used by View APPS.ICX_PO_REQ_TEMPLATE_ITEMS_V

used by View APPS.ICX_PO_SUPPLIER_CATALOGS_V

used by View APPS.ICX_PO_SUPPL_CATALOG_ITEMS_V

used by View APPS.ICX_PO_SUPPL_CAT_ITEMS_V

used by View APPS.ICX_PO_SUPPL_SEARCH_ITEMS_V

used by View APPS.ICX_REQS_LOCATION_V

used by View APPS.ICX_REQ_DIST_HEADER_V

used by View APPS.ICX_SHOPPING_CART_LINES_V

used by View APPS.POR_INVOICES_SUMMARY_V

used by View APPS.POR_USSGL_TC_LOV_V

used by View APPS.POR_VIEW_DIST_HEADER_V

used by View APPS.POR_VIEW_DIST_LINES_V

used by View APPS.POR_VIEW_HEADER_ALL_V

used by View APPS.POR_VIEW_HEADER_V

used by View APPS.POR_VIEW_LINES_ALL_V

used by View APPS.POR_VIEW_LINES_V

used by View APPS.POR_VIEW_LINE_DETAILS_V

used by View APPS.POR_VIEW_REQS_BY_APPROVER_V

used by View APPS.POR_VIEW_REQS_BY_APPR_V

used by View APPS.POR_VIEW_REQS_BY_GROUP_V

used by View APPS.POR_VIEW_REQS_TO_APPR_V

used by View APPS.POR_VIEW_REQS_V

48 dependencies

[top of page]

IGC - Contract Commitment

SQLGL Item Dependency IGC Item
View APPS.GL_LOOKUPS used by View APPS.IGC_CBC_ALL_BAL_V

used by View APPS.IGC_CBC_DETAIL_BAL_V

used by View APPS.IGC_CBC_DR_V

used by View APPS.IGC_CBC_JE_BATCHES_V

used by View APPS.IGC_CBC_JE_LINES_V

used by View APPS.IGC_CBC_SUMMARY_BAL_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.IGCBV_CBC_BALANCES

used by View APPS.IGCBV_CBC_BUDGET_BALANCES

used by View APPS.IGCBV_CBC_ENCUMBRANCE_BALANCES

used by View APPS.IGCBV_CBC_MC_JOURNAL_BATCHES

used by View APPS.IGCBV_CBC_MC_JOURNAL_LINES

used by View APPS.IGCFV_CBC_BALANCES

used by View APPS.IGCFV_CBC_BUDGET_BALANCES

used by View APPS.IGCFV_CBC_ENCUMBRANCE_BALANCES

used by View APPS.IGCFV_CBC_JOURNAL_BATCHES

used by View APPS.IGCFV_CBC_JOURNAL_LINES

used by View APPS.IGCFV_CBC_MC_JOURNAL_BATCHES

used by View APPS.IGCFV_CBC_MC_JOURNAL_LINES

used by View APPS.IGC_CBC_ALL_BAL_V

used by View APPS.IGC_CBC_DETAIL_BAL_V

used by View APPS.IGC_CBC_SUMMARY_BAL_V

used by View APPS.IGC_CC_BC_ENABLE_V

used by View APPS.IGC_CC_GROUPS_V

used by View APPS.IGC_CC_HEADERS_V

24 dependencies

[top of page]

IGI - Public Sector Financials International

SQLGL Item Dependency IGI Item
View APPS.GL_BUDGET_ASSIGNMENT_RANGES_V used by View APPS.IGI_DOS_BUD_ASS_CAND_V
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.IGI_DOS_BUD_ASS_CAND_V

used by View APPS.IGI_DOS_DEST_ACCOUNTS

used by View APPS.IGI_DOS_SOURCE_ACCOUNTS
View APPS.GL_LOOKUPS used by View APPS.IGI_BUD_CODE_COMBINATIONS_V
View APPS.GL_LOOKUPS_PERIOD_STATUSES_V used by View APPS.IGI_GL_PERIOD_STATUSES_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.IGI_BUD_HISTORY_ENTRIES_V

used by View APPS.IGI_BUD_PROFILE_PERIODS_V

used by View APPS.IGI_EER_SETUP_V

used by View APPS.IGI_INT_BK_ID_MAP_SOB_V

used by View APPS.IGI_MPP_EXP_RECOGNITION

11 dependencies

[top of page]

IGS - Student System

SQLGL Item Dependency IGS Item
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.IGSFV_AD_ADM_APPL_TYP

used by View APPS.IGSFV_AD_APPL_FEE
View APPS.GL_SETS_OF_BOOKS used by View APPS.IGS_FI_CONTROL_V

3 dependencies

[top of page]

INV - Inventory

SQLGL Item Dependency INV Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.MTL_FISCAL_CAT_ACCOUNTS_V

used by View APPS.MTL_ORGANIZATIONS

used by View APPS.ORG_ACCESS_VIEW

3 dependencies

[top of page]

ISC - Supply Chain Intelligence

SQLGL Item Dependency ISC Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.ISCBV_EDW_BOOK_SUM1_BASE_FCV

1 dependencies

[top of page]

ITG - Internet Procurement Enterprise Connector

SQLGL Item Dependency ITG Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.ITG_LPI_HEADERS_V

used by View APPS.ITG_LPI_LINES_V

used by View APPS.ITG_PO_HEADER_ARCH_V

used by View APPS.ITG_REQ_HEADERS_V

used by View APPS.ITG_REQ_LINES_V

used by View APPS.ITG_SP_PO_PART_SOLDTO_V

used by View APPS.ITG_SP_REL_PART_SOLDTO_V

7 dependencies

[top of page]

JA - Asia/Pacific Localizations

SQLGL Item Dependency JA Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.JAI_CMN_RG_BALANCES_V

used by View APPS.JAI_PO_CURRENCY_CODE_V

2 dependencies

[top of page]

JE - European Localizations

SQLGL Item Dependency JE Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.JE_NO_GEI_SREPORT_V

1 dependencies

[top of page]

JG - Regional Localizations

SQLGL Item Dependency JG Item
View APPS.GL_LOOKUPS used by View APPS.JG_ZZ_ENTERED_CURRENCIES_V

used by View APPS.JG_ZZ_SRS_LEDGER_BUD_ENCUM_V

used by View APPS.JG_ZZ_TA_RULE_SETS_V

3 dependencies

[top of page]

JL - Latin America Localizations

SQLGL Item Dependency JL Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.JL_CO_FA_AEL_GL_V

used by View APPS.JL_CO_FA_AEL_SL_V

used by View APPS.JL_CO_GL_ACCOUNTS_V

3 dependencies

[top of page]

MSD - Demand Planning

SQLGL Item Dependency MSD Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.MSD_ORGANIZATION_DEFINITIONS

1 dependencies

[top of page]

OE - Order Entry

SQLGL Item Dependency OE Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.OE_BIS_BACKLOG_V

used by View APPS.OE_BIS_BILLINGS_V

used by View APPS.OE_BIS_BOOKINGS_V

used by View APPS.SO_DROP_SHIP_LINKS_V

4 dependencies

[top of page]

OFA - Assets

SQLGL Item Dependency OFA Item
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.FA_DEPRN_WEB_V

used by View APPS.FA_DISTRIBUTION_HIST_WEB_V

used by View APPS.FA_EMP_ASSET_WEB_V

used by View APPS.FA_FIN_INQRY_DEPRN_WEB_V

used by View APPS.FA_FIN_INQRY_UPL_WEB_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.FAFV_BOOKS

used by View APPS.FA_AEL_GL_V

used by View APPS.FA_AEL_SL_MRC_V

used by View APPS.FA_AEL_SL_V

used by View APPS.FA_BOOKS_BK_CNTRL_WEB_V

used by View APPS.FA_DEPRN_WEB_V

used by View APPS.FA_FINANCIAL_INQUIRY_DEPRN_V

used by View APPS.FA_FIN_INQRY_COST_WEB_V

used by View APPS.FA_FIN_INQRY_DEPRN_WEB_V

used by View APPS.FA_FIN_INQRY_UPL_WEB_V

used by View APPS.FA_INS_ADDITIONS_V

used by View APPS.FA_RETIRED_ASSET_WEB_V

used by View APPS.FA_RETIREMENTS_WEB_V

used by View APPS.FA_TRANS_HIST_BOOKS_WEB_V

19 dependencies

[top of page]

OKE - Project Contracts

SQLGL Item Dependency OKE Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.OKE_AGREEMENTS_V

1 dependencies

[top of page]

OKL - Leasing and Finance Management

SQLGL Item Dependency OKL Item
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.OKL_AE_LINES_UPDT_UV

used by View APPS.OKL_TRNS_ACC_DSTRS_UV
View APPS.GL_DAILY_CONVERSION_TYPES_V used by View APPS.OKL_CREDITLINES_UV
View APPS.GL_JE_CATEGORIES_VL used by View APPS.OKL_AEL_GL_AST_V

used by View APPS.OKL_AEL_GL_CTR_V

used by View APPS.OKL_AEL_GL_QTE_V

used by View APPS.OKL_AEL_GL_TRX_V

used by View APPS.OKL_AEL_SL_V
View APPS.GL_LEDGERS_PUBLIC_V used by View APPS.OKL_ACC_GEN_RULES_V

used by View APPS.OKL_CS_LC_ACCOUNT_TAB_UV

used by View APPS.OKL_K_HDRS_FULL_UV

11 dependencies

[top of page]

OKX - Contracts Integration

SQLGL Item Dependency OKX Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.OKX_GL_PERIODS_ORG_V

used by View APPS.OKX_SET_OF_BOOKS_V

2 dependencies

[top of page]

ONT - Order Management

SQLGL Item Dependency ONT Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.OE_DROP_SHIP_LINKS_V

used by View APPS.OE_GL_SETS_OF_BOOKS_V

2 dependencies

[top of page]

OPI - Operations Intelligence

SQLGL Item Dependency OPI Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.OPI_EDW_OPI_JOB_DETAIL_FCV

used by View APPS.OPI_EDW_OPI_JOB_RSRC_FCV

used by View APPS.OPI_EDW_OPM_JOB_DETAIL_FCV

used by View APPS.OPI_EDW_OPM_JOB_RSRC_FCV

used by View APPS.OPI_OPM_GL_CALENDAR_V

5 dependencies

[top of page]

OTA - Learning Management

SQLGL Item Dependency OTA Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.OTA_CROSS_CHARGES_V

used by View APPS.OTFV_FINANCE_HEADERS

2 dependencies

[top of page]

PA - Projects

SQLGL Item Dependency PA Item
View APPS.GL_ALC_LEDGER_RSHIPS_V used by View APPS.PA_GL_SET_OF_BOOKS_V

used by View APPS.PA_RSOB_V
View APPS.GL_AUTO_ALLOC_BATCH_HISTORY_V uses View APPS.PA_AUTOALLOC_RULES_V
View APPS.GL_LOOKUPS used by View APPS.PA_FCST_PERIODS_TMP_V

used by View APPS.PA_GL_SET_OF_BOOKS_V

used by View APPS.PA_ORGFCST_PERIODS_TMP_V

used by View APPS.PA_REP_PERIODS_V

used by View APPS.PA_REP_PERIOD_DATES_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.PA_ADW_BGT_LINES_B_V

used by View APPS.PA_ADW_OPER_UNITS_B_V

used by View APPS.PA_ADW_PERIODS_B_V

used by View APPS.PA_ADW_R_BGT_LINES_B_V

used by View APPS.PA_AEL_SL_DR_MRC_V

used by View APPS.PA_ALLOC_PERIODS_V

used by View APPS.PA_BASE_BUDGET_BY_PA_PERIOD_V

used by View APPS.PA_BASE_FINPLAN_BY_PA_PERIOD_V

used by View APPS.PA_CC_TP_BILL_SCH_ORG_V

used by View APPS.PA_CE_INTEGRATION_BUDGETS_V

used by View APPS.PA_DRAFT_INVOICES_ALL_V

used by View APPS.PA_FCST_PERIODS_TMP_V

used by View APPS.PA_FCST_PROJECT_LIST_V

used by View APPS.PA_FP_PERIODS_V

used by View APPS.PA_GL_SET_OF_BOOKS_V

used by View APPS.PA_ORGFCST_PERIODS_TMP_V

used by View APPS.PA_ORIG_BUDGET_BY_PA_PERIOD_V

used by View APPS.PA_ORIG_FINPLAN_BY_PA_PERIOD_V

used by View APPS.PA_PERIODS_COPY_V

used by View APPS.PA_REP_PERIODS_V

used by View APPS.PA_REP_PERIOD_DATES_V

used by View APPS.PA_REP_PROJ_REQHRS_GLD_V

used by View APPS.PA_REP_PROJ_REQHRS_GL_V

used by View APPS.PA_REP_PROJ_SP_GL_V

used by View APPS.PA_REP_QUARTER_GL_V

used by View APPS.PA_REP_RES_CAP_GL_V

used by View APPS.PA_REP_YEAR_GL_V

used by View APPS.PA_RES_MAP_BTC_V

used by View APPS.PA_RP_CALENDAR_PERIOD_NAMES_V

used by View APPS.PA_RSOB_V

38 dependencies

[top of page]

PAY - Payroll

SQLGL Item Dependency PAY Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.PAY_KR_SEPL_LIAB_SUMMARY_V

used by View APPS.PAY_KR_SEP_LIAB_DETAIL_V

2 dependencies

[top of page]

PER - Human Resources

SQLGL Item Dependency PER Item
View APPS.GL_HR_EMPLOYEES_CURRENT_V uses View APPS.PER_ASSIGNMENTS_X

uses View APPS.PER_PEOPLE_X
View APPS.GL_SETS_OF_BOOKS used by View APPS.PER_ASSIGNMENTS_V

used by View APPS.PER_ASSIGNMENTS_V13

used by View APPS.PER_ASSIGNMENTS_V7

5 dependencies

[top of page]

PJI - Project Intelligence

SQLGL Item Dependency PJI Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.PJI_CURRENCY_TYPES_V

1 dependencies

[top of page]

PJM - Project Manufacturing

SQLGL Item Dependency PJM Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.PJM_PO_COMMITMENTS_BASIC_V

used by View APPS.PJM_PO_COMMITMENTS_CMPRJ_V

used by View APPS.PJM_PROJECT_COST_HISTORY_V

used by View APPS.PJM_PROJECT_ONHAND_VALUE_V

used by View APPS.PJM_PROJECT_REQ_V

used by View APPS.PJM_REQ_COMMITMENTS_BASIC_V

used by View APPS.PJM_REQ_COMMITMENTS_CMPRJ_V

7 dependencies

[top of page]

PMI - Process Manufacturing Intelligence

SQLGL Item Dependency PMI Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.PMIFV_SALES_DETAILS_V

used by View APPS.PMI_GL_CALENDAR_V

used by View APPS.PMI_GL_TIME_V

used by View APPS.PMI_REP_SALES_DETAILS_V

4 dependencies

[top of page]

PN - Property Manager

SQLGL Item Dependency PN Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.PN_GL_PERIOD_V

1 dependencies

[top of page]

PO - Purchasing

SQLGL Item Dependency PO Item
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.PO_DISTRIBUTION_ARCHIVE_XML

used by View APPS.PO_DISTRIBUTION_XML
View APPS.GL_SETS_OF_BOOKS used by View APPS.POABV_EDW_AGREEMENT_LINES_FCV

used by View APPS.POABV_EDW_CONTRACT_AGRMNTS_FCV

used by View APPS.POABV_EDW_PO_DISTRIBUTIONS_FCV

used by View APPS.POABV_EDW_RECEIVING_TXN_FCV

used by View APPS.POABV_EDW_SUPPLIER_PERFORM_FCV

used by View APPS.POA_EDW_CUSTOM_MEASURE_FCV

used by View APPS.POBV_MC_PO_DISTRIBUTIONS

used by View APPS.POFV_BKT_PO_DISTRIBUTIONS

used by View APPS.POFV_MC_PO_DISTRIBUTIONS

used by View APPS.POFV_MC_RECEIVING_SUBLEDGERS

used by View APPS.POFV_PLAN_PO_DISTRIBUTIONS

used by View APPS.POFV_PO_DISTRIBUTIONS

used by View APPS.POFV_RECEIVING_SUBLEDGERS

used by View APPS.POFV_REQUISITION_DISTRIBUTIONS

used by View APPS.POFV_SCHEDULED_DISTRIBUTIONS

used by View APPS.POFV_STD_PO_DISTRIBUTIONS

used by View APPS.PO_AUTOSOURCE_DOCUMENTS_V

used by View APPS.PO_CXML_HEADER_ARCH_V

used by View APPS.PO_ECX_HEADER_ARCH_V

used by View APPS.PO_NEGOTIATED_SOURCES_V

used by View APPS.PO_PURCHASE_HISTORY_V

used by View APPS.PO_REQUISITION_HEADERS_V

used by View APPS.PO_REQUISITION_LINES_INQ_V

used by View APPS.PO_REQUISITION_TEMPLATES_V

used by View APPS.PO_RULE_EXPENSE_ACCOUNTS_V

27 dependencies

[top of page]

PQH - Public Sector HR

SQLGL Item Dependency PQH Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.PQH_BUDGETS_V

1 dependencies

[top of page]

PSA - Public Sector Financials

SQLGL Item Dependency PSA Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.PSA_EFC_OPTIONS_V

1 dependencies

[top of page]

PSB - Public Sector Budgeting

SQLGL Item Dependency PSB Item
View APPS.GL_BUDGETS_V used by View APPS.PSB_GL_BUDGETS_V
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.PSBFV_BUDGET_REVISION_ACCOUNTS

used by View APPS.PSBFV_DEFAULT_DISTRIBUTIONS

used by View APPS.PSBFV_GL_ACCOUNT_HIERARCHIES

used by View APPS.PSBFV_PAY_ELEMENT_DISTRIBUTION

used by View APPS.PSBFV_WS_ACCOUNT_LINES
View APPS.GL_SETS_OF_BOOKS used by View APPS.PSBFV_ACCOUNT_SETS

used by View APPS.PSBFV_ACCOUNT_SET_LISTS

used by View APPS.PSBFV_BUDGET_GROUPS

used by View APPS.PSBFV_CONSTRAINTS

used by View APPS.PSBFV_CONSTRAINT_SETS

used by View APPS.PSBFV_DATA_EXTRACTS

used by View APPS.PSBFV_PARAMETERS

used by View APPS.PSBFV_WS_ACCOUNT_LINES

used by View APPS.PSB_ACCOUNT_POSITION_SETS_V

used by View APPS.PSB_BUDGET_GROUPS_V

used by View APPS.PSB_BUDGET_REVISION_SUMMARY_V

used by View APPS.PSB_BUDGET_WORKFLOW_RULES_V

used by View APPS.PSB_GL_BUDGET_SETS_V

used by View APPS.PSB_POSITIONS_V

used by View APPS.PSB_STD_BUDGET_ITEM_LINES_V

21 dependencies

[top of page]

RG - Application Report Generator

SQLGL Item Dependency RG Item
View APPS.GL_LOOKUPS used by View APPS.RG_DSS_REQUESTS_V

used by View APPS.RG_DSS_VARIABLES_V

used by View APPS.RG_DSS_VAR_DIMENSIONS_V

used by View APPS.RG_SRS_DSS_BUD_ENC_V

used by View APPS.RG_SRS_DSS_DOP_V

used by View APPS.RG_SRS_DSS_HIERARCHIES_V

used by View APPS.RG_SRS_DSS_TEMPLATE_V

7 dependencies

[top of page]

XLA - Subledger Accounting

SQLGL Item Dependency XLA Item
View APPS.GL_SETS_OF_BOOKS used by View APPS.XLA_MO_REPORTING_ENTITIES_V

used by View APPS.XLA_MO_REPORTING_ENT_MRC_V

2 dependencies

[top of page]

XTR - Treasury

SQLGL Item Dependency XTR Item
View APPS.GL_CODE_COMBINATIONS_KFV used by View APPS.XTR_DISC_JOURNALS_V
View APPS.GL_LEDGER_LE_V used by View APPS.XTR_AP_OPEN_APLD_TRX_V

used by View APPS.XTR_AP_OPEN_TRX_V

used by View APPS.XTR_AP_ORIG_TRX_V

used by View APPS.XTR_AR_OPEN_APLD_TRX_V

used by View APPS.XTR_AR_OPEN_TRX_V

used by View APPS.XTR_AR_ORIG_TRX_V

used by View APPS.XTR_BIS_CASHFLOWS_V

used by View APPS.XTR_ONC_ELIGIBLE_DEALS_V
View APPS.GL_SETS_OF_BOOKS used by View APPS.XTR_CA_ELIGIBLE_DEALS_V

used by View APPS.XTR_DISC_JOURNALS_V

used by View APPS.XTR_ELIGIBLE_HEDGES_V

used by View APPS.XTR_IG_ELIGIBLE_DEALS_V

used by View APPS.XTR_ONC_ELIGIBLE_DEALS_V

used by View APPS.XTR_PARTIES_V

15 dependencies

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract