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 - SQLAP 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
SQLAPused byAHL - Complex Maintenance Repair and Overhaul

used byAMS - Marketing

used byAR - Receivables

used byBOM - Bills of Material

used by/usesCE - Cash Management

used byCHV - Supplier Scheduling

used byCLN - Supply Chain Trading Connector for RosettaNet

used byCSI - Install Base

used byCSP - Spares Management

used byEAM - Enterprise Asset Management

used byEC - e-Commerce Gateway

used byECX - XML Gateway

used byEGO - Advanced Product Catalog

used by/usesFND - Application Object Library

used byFV - Federal Financials

used byGMD - Process Manufacturing Product Development

used byGMF - Process Manufacturing Financials

used byGML - Process Manufacturing Logistics

used by/usesGMS - Grants Accounting

used by/usesIBY - Payments

used byICX - Oracle iProcurement

used byIGC - Contract Commitment

used byIGI - Public Sector Financials International

used byINL - Oracle Landed Cost Management

used by/usesINV - Inventory

used byITG - Internet Procurement Enterprise Connector

used byJA - Asia/Pacific Localizations

used byJG - Regional Localizations

used byJL - Latin America Localizations

used byJTF - CRM Foundation

used byMRP - Master Scheduling/MRP

used byOE - Order Entry

used byOFA - Assets

used byOKE - Project Contracts

used byOKL - Lease and Finance Management

used byOKS - Service Contracts

used byOKX - Contracts Integration

used byONT - Order Management

used byOTA - Learning Management

used byOZF - Trade Management

used by/usesPA - Projects

used by/usesPER - Human Resources

used byPJM - Project Manufacturing

used byPMI - Process Manufacturing Intelligence (Obsolete)

used byPN - Property Manager

used by/usesPO - Purchasing

used byPOS - iSupplier Portal

used byQA - Quality

used byWIP - Work in Process

used byWMS - Warehouse Management

used byWSH - Shipping Execution

used byXTR - Treasury

AHL - Complex Maintenance Repair and Overhaul

SQLAP Item Dependency AHL Item
View APPS.PO_VENDORS used by View APPS.AHL_HZ_PO_SUPPLIERS_V

used by View APPS.AHL_OSP_ORDERS_V

used by View APPS.AHL_OWNER_DETAILS_V

used by View APPS.AHL_OWNER_LOCATIONS_V

used by View APPS.AHL_UNIT_ALTERNATES_V
View APPS.PO_VENDOR_CONTACTS used by View APPS.AHL_OSP_ORDERS_V

6 dependencies

[top of page]

AMS - Marketing

SQLAP Item Dependency AMS Item
View APPS.PO_VENDORS used by View APPS.AMS_CHANNELS_V

1 dependencies

[top of page]

AR - Receivables

SQLAP Item Dependency AR Item
View APPS.PO_VENDORS used by View APPS.AR_CUSTOMER_VENDOR_NIF_V

used by View APPS.AR_CUSTOMER_VENDOR_V

used by View APPS.AR_CUSTOMER_VENDOR_VAT_V

3 dependencies

[top of page]

BOM - Bills of Material

SQLAP Item Dependency BOM Item
View APPS.PO_VENDORS used by View APPS.CST_MTL_RCV_TXN_V

used by View APPS.CST_PAC_AEL_GL_RCV_V

used by View APPS.CST_PAC_AEL_SL_RCV_V

used by View APPS.CST_PROJMFG_CMT_BASIC_V

used by View APPS.CST_RCV_RAE_V

used by View APPS.CST_XLA_RCV_V

used by View APPS.CST_XLA_WO_V
View APPS.PO_VENDOR_SITES_ALL used by View APPS.CST_PAC_AEL_GL_RCV_V

used by View APPS.CST_PAC_AEL_SL_RCV_V

9 dependencies

[top of page]

CE - Cash Management

SQLAP Item Dependency CE Item
View APPS.AP_CHECKS_V uses View APPS.CE_BANK_BRANCHES_V
View APPS.AP_TRANSMISSION_CODES_V uses View APPS.CE_BANK_BRANCHES_V
View APPS.PO_VENDORS used by View APPS.CE_200_REVERSAL_V

used by View APPS.CE_AP_FC_DISC_INVOICES_V

used by View APPS.CE_AP_FC_PAYMENTS_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

10 dependencies

[top of page]

CHV - Supplier Scheduling

SQLAP Item Dependency CHV Item
View APPS.PO_VENDORS used by View APPS.CHV_CUM_ITEMS_HISTORY_V

used by View APPS.CHV_CUM_ITEMS_V

used by View APPS.CHV_SCHEDULE_HEADERS_ALL_V

used by View APPS.CHV_SCHEDULE_HEADERS_V

used by View APPS.CHV_SCHEDULE_HEADERS_VAL_V

5 dependencies

[top of page]

CLN - Supply Chain Trading Connector for RosettaNet

SQLAP Item Dependency CLN Item
View APPS.PO_VENDORS used by View APPS.CLN_RN_UTIL_TO_ROLE_SUPPLIER_V

1 dependencies

[top of page]

CSI - Install Base

SQLAP Item Dependency CSI Item
View APPS.PO_VENDORS used by View APPS.CSI_INSTALLED_BASE_V

used by View APPS.CSI_INST_PARTY_DETAILS_V

used by View APPS.CSI_IPH_DETAILS_V
View APPS.PO_VENDOR_CONTACTS used by View APPS.CSI_PARTY_CONTACT_DETAILS_V

4 dependencies

[top of page]

CSP - Spares Management

SQLAP Item Dependency CSP Item
View APPS.PO_VENDORS used by View APPS.CSP_EOO_CANCEL_RECOMM_V

1 dependencies

[top of page]

EAM - Enterprise Asset Management

SQLAP Item Dependency EAM Item
View APPS.PO_VENDORS used by View APPS.EAM_WORK_ORDER_DIRECT_ITEMS_V

used by View APPS.EAM_WORK_ORDER_REQ_PO_V
View APPS.PO_VENDOR_CONTACTS used by View APPS.EAM_WORK_ORDER_DIRECT_ITEMS_V

used by View APPS.EAM_WORK_ORDER_REQ_PO_V
View APPS.PO_VENDOR_SITES_ALL used by View APPS.EAM_WORK_ORDER_DIRECT_ITEMS_V

used by View APPS.EAM_WORK_ORDER_REQ_PO_V

6 dependencies

[top of page]

EC - e-Commerce Gateway

SQLAP Item Dependency EC Item
View APPS.PO_VENDORS used by View APPS.ECE_MVSTO_LOCATIONS_V

used by View APPS.ECE_POCO_HEADERS_V

used by View APPS.ECE_POO_HEADERS_V

used by View APPS.ECE_SPSO_HEADERS_V

used by View APPS.ECE_SSSO_HEADERS_V
View APPS.PO_VENDOR_CONTACTS used by View APPS.ECE_POCO_HEADERS_V

used by View APPS.ECE_POO_HEADERS_V

7 dependencies

[top of page]

ECX - XML Gateway

SQLAP Item Dependency ECX Item
View APPS.PO_VENDORS used by View APPS.ECX_TP_HEADERS_V

1 dependencies

[top of page]

EGO - Advanced Product Catalog

SQLAP Item Dependency EGO Item
View APPS.PO_VENDORS used by View APPS.EGO_PEOPLE_V

used by View APPS.EGO_VENDOR_PEOPLE_V

2 dependencies

[top of page]

FND - Application Object Library

SQLAP Item Dependency FND Item
View APPS.AP_CHECKS_V uses View APPS.FND_LOOKUPS

uses View APPS.FND_TERRITORIES_VL
View APPS.AP_ENC_GL_PAY_V used by View APPS.XLA_AP_ENC_GL_PAY_V
View APPS.AP_FND_DOCUMENT_SEQUENCES_QF_V uses View APPS.FND_LOOKUP_VALUES_VL
View APPS.AP_INVOICES_V uses View APPS.FND_LOOKUPS

uses View APPS.ZX_FC_BUSINESS_CATEGORIES_V
View APPS.AP_JE_CATEGORIES_V uses View APPS.FND_LOOKUPS
View APPS.AP_LOOKUP_TYPES uses View APPS.FND_LOOKUP_TYPES_VL
View APPS.AP_PAYMENT_EXTRACT_DETAILS_V uses View APPS.ZX_AP_DEF_TAX_EXTRACT_V
View APPS.AP_PREPAY_DEF_TAX_EXTRACT_V uses View APPS.ZX_AP_DEF_TAX_EXTRACT_V
View APPS.AP_SRS_SOB_NAME_V uses View APPS.FND_LOOKUPS
View APPS.AP_VENDOR_DISP_V uses View APPS.FND_LANGUAGES_VL

uses View APPS.FND_TERRITORIES_VL
View APPS.AP_VENDOR_SITES_V uses View APPS.FND_LANGUAGES_VL

uses View APPS.FND_TERRITORIES_VL
View APPS.AP_ZX_DEF_TAX_EXTRACT_V uses View APPS.ZX_AP_DEF_TAX_EXTRACT_V
View APPS.PO_VENDOR_SITES_PAY_AP_V uses View APPS.FND_TERRITORIES_VL

17 dependencies

[top of page]

FV - Federal Financials

SQLAP Item Dependency FV Item
View APPS.PO_VENDORS used by View APPS.FV_FACTS_VENDORS_V

used by View APPS.FV_PAYABLE_REFUNDS_V

2 dependencies

[top of page]

GMD - Process Manufacturing Product Development

SQLAP Item Dependency GMD Item
View APPS.PO_VENDORS used by View APPS.GMD_CUST_VEND_MST_V2

used by View APPS.GMD_QC_E_SUPP_SAMPLE_DTLS_V

used by View APPS.GMD_QC_E_SUPP_SMPEVT_DTLS_V

3 dependencies

[top of page]

GMF - Process Manufacturing Financials

SQLAP Item Dependency GMF Item
View APPS.PO_VENDORS used by View APPS.GMF_XLA_RCV_TXNS_V

1 dependencies

[top of page]

GML - Process Manufacturing Logistics

SQLAP Item Dependency GML Item
View APPS.PO_VENDORS used by View APPS.GML_LN_RCV_ERV

1 dependencies

[top of page]

GMS - Grants Accounting

SQLAP Item Dependency GMS Item
View APPS.AP_WEB_PA_PROJECTS_TASKS_V uses View APPS.GMS_SSA_AWARDS_V
View APPS.PO_VENDORS used by View APPS.GMS_COMMITMENT_ENCUMBERED_V

used by View APPS.GMS_DRAFT_INV_LINE_DETAILS_V

used by View APPS.GMS_EXPEND_ITEMS_ADJUST_V

4 dependencies

[top of page]

IBY - Payments

SQLAP Item Dependency IBY Item
View APPS.AP_CHECKS_V uses View APPS.IBY_PAYMENT_METHODS_VL

uses View APPS.IBY_PAYMENT_PROFILES
View APPS.AP_EXPENSE_FEED_DISTS_OPEN_V uses View APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V
View APPS.AP_EXPENSE_FEED_DISTS_V uses View APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V
View APPS.AP_EXPENSE_FEED_LINES_V uses View APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V
View APPS.AP_INVOICES_V uses View APPS.IBY_DELIVERY_CHANNELS_VL

uses View APPS.IBY_PAYMENT_METHODS_VL

uses View APPS.IBY_PAYMENT_REASONS_VL
View APPS.AP_INVOICE_PAYMENTS_V uses View APPS.IBY_PAYMENT_METHODS_VL
View APPS.AP_INVOICE_PAYMENT_HISTORY_V uses View APPS.IBY_PAYMENT_METHODS_VL
View APPS.PO_VENDORS used by View APPS.IBY_EXT_FD_PAYEE_1_0_V

11 dependencies

[top of page]

ICX - Oracle iProcurement

SQLAP Item Dependency ICX Item
View APPS.PO_VENDORS used by View APPS.ICX_AP_EXPENSE_REPORTS_V

used by View APPS.ICX_AP_INVOICES_V

used by View APPS.ICX_CATALOG_SUMMARY_V

used by View APPS.ICX_EDM_BUYER_SUP_PROJ_V

used by View APPS.ICX_EDM_BUYER_SUP_TASK_V

used by View APPS.ICX_EDM_PO_BLANKET_REL_V

used by View APPS.ICX_EDM_PURCHASE_ORDER_V

used by View APPS.ICX_PLAN_SCHEDULE_HEADERS_V

used by View APPS.ICX_POR_EXT_ACTIVE_CONTRACTS

used by View APPS.ICX_POR_EXT_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_POS_QA_SHIPMENTS_V

used by View APPS.ICX_PO_HDR_ARCHIVE_OPEN_V

used by View APPS.ICX_PO_HEADERS_ARCHIVE_V

used by View APPS.ICX_PO_LATE_RECEIPTS_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_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_RFQ_HEADERS_V

used by View APPS.ICX_PO_SUPPLIER_AGREEMENTS_V

used by View APPS.ICX_PO_SUPPLIER_CATALOGS_V

used by View APPS.ICX_PO_SUPPLIER_INFO_V

used by View APPS.ICX_PO_SUPPLIER_ITEMS_V

used by View APPS.ICX_PO_SUPPLIER_ORDERS_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_PO_SUP_ORDER_INVOICES_V

used by View APPS.ICX_RCV_ACCEPTED_ITEMS_V

used by View APPS.ICX_RCV_EARLY_LATE_RECEIPTS_V

used by View APPS.ICX_RCV_REJECTED_ITEMS_V

used by View APPS.ICX_RCV_RETURNS_V

used by View APPS.ICX_RCV_TRANSACTIONS_V

used by View APPS.ICX_RECEIPT_HEADERS_V

used by View APPS.ICX_SHIP_SCHEDULE_HEADERS_V

used by View APPS.ICX_SUPPLIER_ACCOUNT_V

used by View APPS.ICX_SUPPLIER_CONTACT_LOV

used by View APPS.ICX_SUPPLIER_ORG_LOV_V

used by View APPS.POR_CAT_SUPPLIER_LOV_V

used by View APPS.POR_RCV_ALL_ITEMS_V1

used by View APPS.POR_RCV_CONF_ITEMS_V

used by View APPS.POR_RCV_EXPRESS_ITEMS_V

used by View APPS.POR_RCV_HOME_RECEIPTS_V

used by View APPS.POR_RCV_HOME_REQS_V

used by View APPS.POR_RCV_ORD_REQUESTER_V

used by View APPS.POR_RCV_PURCHASE_ITEMS_V

used by View APPS.POR_RCV_PURCHASE_RECEIPTS_V

used by View APPS.POR_RCV_REQS_NAME_V

used by View APPS.POR_RCV_REQS_ORDER_V

used by View APPS.POR_RCV_REQS_VENDOR_V

used by View APPS.POR_RCV_REQ_ITEMS_V

used by View APPS.POR_RCV_REQ_PURCH_RECEIPTS_V

used by View APPS.POR_RCV_RETURN_TO_VENDOR_V

used by View APPS.POR_RCV_SHIPMENTS_V

used by View APPS.POR_RECEIVE_ORDERS_V

used by View APPS.POR_SUPPLIER_LOV_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_GROUP_V

used by View APPS.POS_ACK_SELECT_V

used by View APPS.POS_ASN_HEADERS_V

used by View APPS.POS_ASN_PO_SHIPMENTS_V

used by View APPS.POS_ASN_REVIEW_HEADERS_V

used by View APPS.POS_ASN_SHIPMENT_DETAILS_V

used by View APPS.POS_ASN_SITE_LOV_V

used by View APPS.POS_UPD_DATE_PO_SHIP_V
View APPS.PO_VENDOR_CONTACTS used by View APPS.ICX_EDM_PO_BLANKET_REL_V

used by View APPS.ICX_EDM_PURCHASE_ORDER_V

used by View APPS.ICX_POR_SEARCH_CONTRACTS_V

used by View APPS.ICX_PO_HDR_ARCHIVE_OPEN_V

used by View APPS.ICX_PO_HEADERS_ARCHIVE_V

used by View APPS.ICX_PO_LATE_RECEIPTS_V

used by View APPS.ICX_PO_REQUISITION_TEMPLATES_V

used by View APPS.ICX_PO_REQ_TEMPLATE_ITEMS_V

used by View APPS.ICX_PO_RFQ_HEADERS_V

used by View APPS.ICX_PO_SUPPLIER_AGREEMENTS_V

used by View APPS.ICX_PO_SUPPLIER_CATALOGS_V

used by View APPS.ICX_PO_SUPPLIER_ORDERS_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_PO_VENDOR_CONTACTS_V

used by View APPS.ICX_SUPPLIER_ACCOUNT_V

used by View APPS.ICX_SUPPLIER_CONTACT_LOV

used by View APPS.ICX_SUPPLIER_SAV_DEFAULTS_V

used by View APPS.POR_SUPPLIER_LOV_V

98 dependencies

[top of page]

IGC - Contract Commitment

SQLAP Item Dependency IGC Item
View APPS.PO_VENDORS used by View APPS.IGCFV_CC_CONTRACT_COMMITMENTS

used by View APPS.IGCFV_CC_RELEASES

used by View APPS.IGC_CC_HEADERS_V
View APPS.PO_VENDOR_CONTACTS used by View APPS.IGCFV_CC_CONTRACT_COMMITMENTS

used by View APPS.IGCFV_CC_RELEASES

used by View APPS.IGC_CC_HEADERS_V

6 dependencies

[top of page]

IGI - Public Sector Financials International

SQLAP Item Dependency IGI Item
View APPS.AP_INVOICES_V used by View APPS.IGI_EXP_AVAILABLE_TRX_V

used by View APPS.IGI_EXP_DU_LINES_V

used by View APPS.IGI_MPP_AP_INVOICES_MERGE_V

used by View APPS.IGI_MPP_EXP_RECOGNITION

used by View APPS.IGI_MPP_NON_MPP_INVOICES_V

used by View APPS.IGI_MPP_SELECTED_INVOICES_V
View APPS.AP_INVOICE_DISTRIBUTIONS_V used by View APPS.IGI_MPP_EXP_RECOGNITION
View APPS.AP_LOOKUP_TYPES used by View APPS.IGI_AP_PO_LOOKUP_CODES_V
View APPS.PO_VENDORS used by View APPS.IGI_AP_INVOICE_PAY_V

used by View APPS.IGI_AP_INVOICE_V

used by View APPS.IGI_AP_INV_DISTRIBUTIONS_V

used by View APPS.IGI_CIS_CERT_INV_PMT_VCH_V

used by View APPS.IGI_EXP_AP_INV_V

used by View APPS.IGI_EXP_DUS_V

used by View APPS.IGI_EXP_TRAN_UNIT_V

used by View APPS.IGI_SAP_EXCEPTIONS_V

16 dependencies

[top of page]

INL - Oracle Landed Cost Management

SQLAP Item Dependency INL Item
View APPS.PO_VENDORS used by View APPS.INL_ENTER_RECEIPTS_PO_V

used by View APPS.INL_ENTER_RECEIPTS_V

used by View APPS.INL_PO_SOURCE_LINES_V

used by View APPS.INL_SHIP_PO_OVERALL_V

4 dependencies

[top of page]

INV - Inventory

SQLAP Item Dependency INV Item
View APPS.AP_RECEIPT_CORRECTIONS_V uses View APPS.ORG_ORGANIZATION_DEFINITIONS
View APPS.AP_SHIPPING_NETWORK_LOCATIONS uses View APPS.ORG_ORGANIZATION_DEFINITIONS
View APPS.PO_VENDORS used by View APPS.INVFV_KANBAN_CARDS

used by View APPS.INVFV_KANBAN_CARD_ACTIVITIES

used by View APPS.INVFV_KANBAN_LOCATION_ITEMS

used by View APPS.INVFV_SERIAL_NUMBERS

used by View APPS.MTL_CONSUMPTION_DEFINITION_V

used by View APPS.MTL_INTERCOMPANY_PARAMETERS_V

used by View APPS.MTL_KANBAN_CARDS_V

used by View APPS.MTL_KANBAN_PULL_SEQUENCES_V

used by View APPS.RCV_RECEIPT_CONFIRMATION_V

11 dependencies

[top of page]

ITG - Internet Procurement Enterprise Connector

SQLAP Item Dependency ITG Item
View APPS.PO_VENDORS used by View APPS.ITG_LPI_HEADERS_V

used by View APPS.ITG_PO_HEADER_ARCH_V

used by View APPS.ITG_REQ_VENDORS_V

used by View APPS.ITG_SP_PO_PART_SHIPTO_V

used by View APPS.ITG_SP_PO_PART_SUPPL_V

used by View APPS.ITG_SP_REL_PART_SHIPTO_V

used by View APPS.ITG_SP_REL_PART_SUPPL_V

used by View APPS.ITG_UPDEL_HEADERS_V
View APPS.PO_VENDOR_CONTACTS used by View APPS.ITG_PO_HEADER_ARCH_V

used by View APPS.ITG_REQ_VENDOR_CONTACTS_V

used by View APPS.ITG_SP_PO_PART_SUPPL_V

used by View APPS.ITG_SP_REL_PART_SUPPL_V

used by View APPS.ITG_UPDEL_HEADERS_V

13 dependencies

[top of page]

JA - Asia/Pacific Localizations

SQLAP Item Dependency JA Item
View APPS.PO_VENDORS used by View APPS.JAI_AP_BOE_AEL_V

used by View APPS.JAI_AP_MANUAL_AEL_V

used by View APPS.JAI_AP_SET_AEL_V

used by View APPS.JAI_AP_STREVIEW_AEL_V

used by View APPS.JAI_AP_TDS_DEFAULT_SECTION_V

used by View APPS.JAI_AP_TDS_NULLSITE_THHOLD_V

used by View APPS.JAI_AP_TDS_THHOLD_EXCEPTION_V

used by View APPS.JAI_AP_TDS_THHOLD_VENDOR_V

used by View APPS.JAI_AP_TDS_TH_PAN_TAN_V

used by View APPS.JAI_AP_TDS_TH_VSITE_V

used by View APPS.JAI_BOE_HEADERS_V

used by View APPS.JAI_CMN_CESS_TRXS_V

used by View APPS.JAI_CMN_VENDOR_NAME_V

used by View APPS.JAI_INV_RG1_AEL_V

used by View APPS.JAI_INV_RG23_AEL_V

used by View APPS.JAI_INV_RGCO_AEL_V

used by View APPS.JAI_PLA_ENTRY_AEL_V

used by View APPS.JAI_PO_OSPM_AEL_V

used by View APPS.JAI_PO_OSP_DISP_AEL_V

used by View APPS.JAI_PO_REC_AEL_V

used by View APPS.JAI_PO_REC_CENVAT_AEL_V

used by View APPS.JAI_PO_REC_MTL_AEL_V

used by View APPS.JAI_PO_REC_VAT_AEL_V

used by View APPS.JAI_PO_REC_VENDOR_AEL_V

used by View APPS.JAI_PO_SHIPMENT_DTLS_V

used by View APPS.JAI_PO_SUMMARY_V

used by View APPS.JAI_PO_VENDOR_NAMES_V

27 dependencies

[top of page]

JG - Regional Localizations

SQLAP Item Dependency JG Item
View APPS.PO_VENDORS used by View APPS.JG_ZZ_AP_IR_REP_ITF_V

used by View APPS.JG_ZZ_ENTITY_ASSOC_V

2 dependencies

[top of page]

JL - Latin America Localizations

SQLAP Item Dependency JL Item
View APPS.PO_VENDORS used by View APPS.JL_BR_AP_COLLECTION_DOCS_V

used by View APPS.JL_BR_AP_CONSOLID_INVOICES_V

2 dependencies

[top of page]

JTF - CRM Foundation

SQLAP Item Dependency JTF Item
View APPS.PO_VENDORS used by View APPS.JTF_RS_SUPPLIERS_VL
View APPS.PO_VENDOR_CONTACTS used by View APPS.JTF_RS_SUPPLIERS_VL

2 dependencies

[top of page]

MRP - Master Scheduling/MRP

SQLAP Item Dependency MRP Item
View APPS.PO_VENDORS used by View APPS.MRPBV_PLAN_ITEM_CAPACITIES

used by View APPS.MRPBV_PLAN_ITEM_FLEX_FENCES

used by View APPS.MRPBV_PLAN_ITEM_SOURCES

used by View APPS.MRPBV_PLAN_ITEM_SUPPLIERS

used by View APPS.MRPFV_PLAN_ITEM_CAPACITIES

used by View APPS.MRPFV_PLAN_ITEM_FLEX_FENCES

used by View APPS.MRPFV_PLAN_ITEM_SOURCES

used by View APPS.MRPFV_PLAN_ITEM_SUPPLIERS

used by View APPS.MRPFV_PLAN_ORG_ITEMS

used by View APPS.MRPFV_PLAN_SUPPLIES

used by View APPS.MRPFV_REPLENISHMENT_SOURCES

used by View APPS.MRP_CUST_SUP_ORG_V

used by View APPS.MRP_ITEM_SOURCING_V

used by View APPS.MRP_KANBAN_DETAILS_V

used by View APPS.MRP_ORDERS_SC_V

used by View APPS.MRP_SCATP_SUPPLY_SOURCES_V

used by View APPS.MRP_SC_BILL_SF_V

used by View APPS.MRP_SC_BILL_WU_V

used by View APPS.MRP_SR_SOURCE_ORG_V

used by View APPS.MRP_WEB_PLANNED_SUPPLY_V

20 dependencies

[top of page]

OE - Order Entry

SQLAP Item Dependency OE Item
View APPS.PO_VENDORS used by View APPS.SO_DROP_SHIP_LINKS_V

1 dependencies

[top of page]

OFA - Assets

SQLAP Item Dependency OFA Item
View APPS.PO_VENDORS used by View APPS.FAFV_ASSET_LEASES

used by View APPS.FAFV_SRC_LNS

used by View APPS.FA_ADDITIONS_ASSET_V

used by View APPS.FA_ADDITIONS_V

used by View APPS.FA_ADDITIONS_WEB_V

used by View APPS.FA_ADD_INVOICE_WEB_V

used by View APPS.FA_ASSET_INVOICES_V

used by View APPS.FA_FUTURE_MASS_ADDITIONS_V

used by View APPS.FA_INS_MST_POLS_V

used by View APPS.FA_INS_POLICIES_V

used by View APPS.FA_INVOICE_DETAILS_V

used by View APPS.FA_INVOICE_DETAILS_WEB_V

used by View APPS.FA_LEASES_V

used by View APPS.FA_LEASES_WEB_V

used by View APPS.FA_LEASE_PAYMENT_ITEMS_V

used by View APPS.FA_MASS_ADDITIONS_V

used by View APPS.FA_QUICK_ADDITIONS_V

used by View APPS.FA_SOURCE_LINES_V

18 dependencies

[top of page]

OKE - Project Contracts

SQLAP Item Dependency OKE Item
View APPS.PO_VENDORS used by View APPS.OKE_DTS_PURCHASING_V

1 dependencies

[top of page]

OKL - Lease and Finance Management

SQLAP Item Dependency OKL Item
View APPS.PO_VENDORS used by View APPS.OKL_AEL_GL_AST_V

used by View APPS.OKL_BPD_AP_DISBURS_SMRY_UV

used by View APPS.OKL_BPD_AP_DISB_DTLS_UV

used by View APPS.OKL_BPD_VENDOR_SITES_V

used by View APPS.OKL_CONTRACT_VENDORS_UV

used by View APPS.OKL_CS_DISBURSEMENTS_UV

used by View APPS.OKL_CS_PAY_INVOICES_UV

used by View APPS.OKL_CS_VENDORS_UV

used by View APPS.OKL_CS_VENDOR_CONTACTS_UV

used by View APPS.OKL_CURE_HEADER_UV

used by View APPS.OKL_CURE_REFUNDS_HDRS_UV

used by View APPS.OKL_CURE_REQUEST_LIST_UV

used by View APPS.OKL_CURE_RFND_DTLS_UV

used by View APPS.OKL_CURE_VENDOR_SUMRY_UV

used by View APPS.OKL_FUND_REQ_HEADERS_UV

used by View APPS.OKL_FUND_VENDORS_UV

used by View APPS.OKL_FUND_VENDOR_SITES_UV

used by View APPS.OKL_LA_ASSET_PARTIES_UV

used by View APPS.OKL_LA_FEE_LINES_UV

used by View APPS.OKL_LA_KLE_VENDORS_UV

used by View APPS.OKL_LA_PASSTHRU_VENDOR_UV

used by View APPS.OKL_LA_REAL_ESTATE_UV

used by View APPS.OKL_LA_SERV_INTGR_UV

used by View APPS.OKL_LA_VENDORS_UV

used by View APPS.OKL_LEASE_VENDORS_UV

used by View APPS.OKL_LESSEE_AS_VENDORS_UV

used by View APPS.OKL_NEW_ASSETS_UV

used by View APPS.OKL_NEW_LOAN_ASSETS_UV

used by View APPS.OKL_OLD_ASSETS_UV

used by View APPS.OKL_OLD_LOAN_ASSETS_UV

used by View APPS.OKL_OR_AS_ADDON_V

used by View APPS.OKL_OR_SUBSIDY_REFUNDS

used by View APPS.OKL_PARTY_PAYMENT_DTLS_UV

used by View APPS.OKL_SUBSIDIES_UV

used by View APPS.OKL_VP_AGREEMENT_UV
View APPS.PO_VENDOR_CONTACTS used by View APPS.OKL_CS_VENDOR_CONTACTS_UV

used by View APPS.OKL_CURE_HEADER_UV

used by View APPS.OKL_CURE_VENDOR_SUMRY_UV

38 dependencies

[top of page]

OKS - Service Contracts

SQLAP Item Dependency OKS Item
View APPS.PO_VENDORS used by View APPS.OKS_AUTH_SHOWALL_PROD_V

used by View APPS.OKS_PRODUCT_DETAILS_V

2 dependencies

[top of page]

OKX - Contracts Integration

SQLAP Item Dependency OKX Item
View APPS.PO_VENDORS used by View APPS.OKX_INS_PROVIDER_V

used by View APPS.OKX_VENDORS_V
View APPS.PO_VENDOR_CONTACTS used by View APPS.OKX_RESOURCES_V

used by View APPS.OKX_VENDOR_CONTACTS_V

4 dependencies

[top of page]

ONT - Order Management

SQLAP Item Dependency ONT Item
View APPS.PO_VENDORS used by View APPS.OE_DROP_SHIP_LINKS_V

used by View APPS.OE_RELATED_PO_NUMBERS_V

2 dependencies

[top of page]

OTA - Learning Management

SQLAP Item Dependency OTA Item
View APPS.PO_VENDORS used by View APPS.OTA_ACTIVITY_VERSIONS_V

used by View APPS.OTA_CTRNG_HISTORIES_V

used by View APPS.OTA_EVENTS_V

used by View APPS.OTA_EVENT_SEARCH_V

used by View APPS.OTA_EVENT_SEARCH_V2

used by View APPS.OTA_FINANCE_HEADERS_V

used by View APPS.OTA_PRICE_LIST_ENTRIES_V

used by View APPS.OTA_RESOURCE_BOOKINGS_V

used by View APPS.OTA_SUPPLIABLE_RESOURCES_V

used by View APPS.OTA_VENDORS_V

used by View APPS.OTA_VENDOR_CONTACTS_V

used by View APPS.OTFV_COMBINED_TRAINING_HISTORY

used by View APPS.OTFV_CUST_RESTRICTED_EVENTS

used by View APPS.OTFV_DELIVERED_COMPETENCES

used by View APPS.OTFV_FINANCE_HEADERS

used by View APPS.OTFV_FINANCE_LINES

used by View APPS.OTFV_HR_RESTRICTED_EVENTS

used by View APPS.OTFV_ONE_TIME_TRAINING_EVENTS

used by View APPS.OTFV_RESOURCES

used by View APPS.OTFV_RESOURCES_BOOKED

used by View APPS.OTFV_RESOURCE_CHECKLIST

used by View APPS.OTFV_SCHEDULED_TRAINING_EVENTS

used by View APPS.OTFV_TRAINING_ACTIVITIES

used by View APPS.OTFV_TRAINING_EVENTS

used by View APPS.OTV_ACTIVITIES

used by View APPS.OTV_ONE_TIME_EVENTS

used by View APPS.OTV_SCHEDULED_EVENTS

used by View APPS.OTV_TRAINING_COMPETENCE
View APPS.PO_VENDOR_CONTACTS used by View APPS.OTA_VENDOR_CONTACTS_V

29 dependencies

[top of page]

OZF - Trade Management

SQLAP Item Dependency OZF Item
View APPS.PO_VENDORS used by View APPS.OZF_CUST_TRD_PRFLS_V

1 dependencies

[top of page]

PA - Projects

SQLAP Item Dependency PA Item
View APPS.AP_INVOICE_DISTS_INQUIRY_V uses View APPS.PA_TASKS_EXPEND_V
View APPS.AP_MATCH_CORRECTION_DISTS_V uses View APPS.PA_TASKS_EXPEND_V
View APPS.AP_PO_DISTRIBUTIONS_AP2_V uses View APPS.PA_TASKS_EXPEND_V
View APPS.AP_WEB_PA_PROJECTS_TASKS_V uses View APPS.PA_PROJECTS_EXPEND_V

uses View APPS.PA_TASKS_EXPEND_V
View APPS.AP_WEB_PA_PROJECTS_V uses View APPS.PA_PROJECTS_EXPEND_V
View APPS.PA_PROJECT_TASKS_AP_V uses View APPS.PA_TASKS_EXPEND_V
View APPS.PA_TASKS_AP_V uses View APPS.PA_TASKS_EXPEND_V
View APPS.PO_VENDORS used by View APPS.PAFV_COST_DISTRIBUTIONS

used by View APPS.PA_AEL_GL_DR_V

used by View APPS.PA_AEL_GL_EI_V

used by View APPS.PA_AEL_SL_DR_MRC_V

used by View APPS.PA_AEL_SL_DR_V

used by View APPS.PA_AEL_SL_EI_MRC_V

used by View APPS.PA_AEL_SL_EI_V

used by View APPS.PA_AP_INV_EXCEPTIONS_DET_V

used by View APPS.PA_AP_INV_EXCEPTIONS_SUM_V

used by View APPS.PA_CAPITAL_EVENT_COSTS_V

used by View APPS.PA_CC_EXCEPTIONS_DET_V

used by View APPS.PA_CI_SUPPLIER_DETAILS_V

used by View APPS.PA_COST_EXCEPTIONS_DET_V

used by View APPS.PA_C_RES_DETAILS_V

used by View APPS.PA_DRAFT_INV_LINE_DETAILS_V

used by View APPS.PA_EXPEND_ITEMS_ADJUST_ALL_V

used by View APPS.PA_EXPEND_ITEMS_ADJUST_V

used by View APPS.PA_GL_CC_EXCEPT_DET_V

used by View APPS.PA_GL_COST_EXCEPT_DET_V

used by View APPS.PA_GL_UNCOST_EXCEPT_SUM_V

used by View APPS.PA_PROJ_AP_INV_DISTRIBUTIONS

used by View APPS.PA_PROJ_AP_INV_DIST_V

used by View APPS.PA_PROJ_COST_EXPEND_VIEW

used by View APPS.PA_PROJ_EXPEND_VIEW

used by View APPS.PA_PROJ_PO_DISTRIBUTIONS

used by View APPS.PA_PROJ_PO_DISTRIBUTIONS_V

used by View APPS.PA_PRVDR_CC_ORG_REL_V

used by View APPS.PA_QUERY_RES_LIST_MEMBERS_V

used by View APPS.PA_RCV_EXCEPTIONS_DET_V

used by View APPS.PA_RESOURCE_TXN_ATTRIBUTES_V

used by View APPS.PA_STATUS_EI_V

used by View APPS.PA_TXN_ACCUM_V

used by View APPS.PA_VENDORS_RES_V

41 dependencies

[top of page]

PER - Human Resources

SQLAP Item Dependency PER Item
View APPS.AP_CARDS_V uses View APPS.PER_PEOPLE_X
View APPS.AP_EXPENSE_REPORT_HEADERS_V uses View APPS.PER_CONT_WORKERS_CURRENT_X

uses View APPS.PER_EMPLOYEES_X
View APPS.AP_EXPENSE_REPORT_HISTORY_V uses View APPS.PER_PEOPLE_X
View APPS.AP_INVOICE_DISTS_INQUIRY_V uses View APPS.HR_ORGANIZATION_UNITS
View APPS.AP_MATCH_CORRECTION_DISTS_V uses View APPS.HR_ORG_UNITS_NO_JOIN

uses View APPS.PER_PEOPLE_F
View APPS.AP_PO_DISTRIBUTIONS_AP2_V uses View APPS.HR_ORG_UNITS_NO_JOIN

uses View APPS.PER_PEOPLE_F
View APPS.AP_RECEIPT_CORRECTIONS_V uses View APPS.PER_PEOPLE_F
View APPS.AP_WEB_PA_PROJECTS_TASKS_V uses View APPS.HR_ORGANIZATION_UNITS
View APPS.AP_WEB_PA_PROJECTS_V uses View APPS.HR_ORGANIZATION_UNITS
View APPS.AP_WEB_PEOPLE_LOV_V uses View APPS.HR_ORGANIZATION_UNITS

uses View APPS.PER_ASSIGNMENTS_F

uses View APPS.PER_PEOPLE_F
View APPS.AP_WEB_SIGNING_LIMITS_V uses View APPS.PER_CONT_WORKERS_CURRENT_X

uses View APPS.PER_EMPLOYEES_CURRENT_X
View APPS.OIE_MGR_RPT_V uses View APPS.PER_ASSIGNMENTS_F

uses View APPS.PER_PEOPLE_X
View APPS.OIE_SRS_CARD_NUMBER_V uses View APPS.PER_EMPLOYEES_X
View APPS.PO_VENDORS used by View APPS.PER_ASSIGNMENTS_V

used by View APPS.PER_ASSIGNMENTS_V13

used by View APPS.PER_ASSIGNMENTS_V2

used by View APPS.PER_ASSIGNMENTS_V3
View APPS.PO_VENDORS_AP_V uses View APPS.HR_OPERATING_UNITS

25 dependencies

[top of page]

PJM - Project Manufacturing

SQLAP Item Dependency PJM Item
View APPS.PO_VENDORS used by View APPS.PJM_PROJECT_EXPEND_V

used by View APPS.PJM_PROJECT_QUOT_V

used by View APPS.PJM_PROJECT_RFQ_V

3 dependencies

[top of page]

PMI - Process Manufacturing Intelligence (Obsolete)

SQLAP Item Dependency PMI Item
View APPS.PO_VENDORS used by View APPS.PMITS_QC_SAMPLES_V

1 dependencies

[top of page]

PN - Property Manager

SQLAP Item Dependency PN Item
View APPS.PO_VENDORS used by View APPS.PN_AEL_PAY_GL_V

used by View APPS.PN_EXP_PAYMENT_ITEMS_V

used by View APPS.PN_PAYMENT_ITEMS_V

used by View APPS.PN_PAYMENT_TERMS_HISTORY_V

used by View APPS.PN_PAYMENT_TERMS_V

used by View APPS.PN_TERM_TEMPLATES_V

used by View APPS.PN_TRX_LEASE_EXPENSE

used by View APPS.PN_VAR_TERMS_V

used by View APPS.PN_XLA_EXTRACT_HEADERS_V

9 dependencies

[top of page]

PO - Purchasing

SQLAP Item Dependency PO Item
View APPS.AP_EXPENSE_FEED_DISTS_OPEN_V uses View APPS.HR_EMPLOYEES_CURRENT_V
View APPS.AP_EXPENSE_FEED_DISTS_V uses View APPS.HR_EMPLOYEES_CURRENT_V
View APPS.AP_EXPENSE_FEED_LINES_V uses View APPS.HR_EMPLOYEES_CURRENT_V
View APPS.AP_RECEIPT_CORRECTIONS_V uses View APPS.PO_LOOKUP_CODES
View APPS.AP_VENDORS_V uses View APPS.PO_LOOKUP_CODES

uses View APPS.RCV_ROUTING_HEADERS
View APPS.AP_VENDOR_SITES_V uses View APPS.PO_LOOKUP_CODES
View APPS.PO_VENDORS used by View APPS.POBV_SUPPLIERS

used by View APPS.POBV_SUPPLIER_SITES

used by View APPS.POFV_APPROVED_SUPPLIER_LISTS

used by View APPS.POFV_BKT_PO_RELEASES

used by View APPS.POFV_BKT_PURCHASE_ORDERS

used by View APPS.POFV_INBOUND_SHIPMENTS

used by View APPS.POFV_INBOUND_SHIPMENT_LINES

used by View APPS.POFV_PLAN_PO_RELEASES

used by View APPS.POFV_PLAN_PURCHASE_ORDERS

used by View APPS.POFV_PURCHASE_CONTRACTS

used by View APPS.POFV_PURCHASE_ORDERS

used by View APPS.POFV_QUOTATIONS

used by View APPS.POFV_RECEIVING_TRANSACTIONS

used by View APPS.POFV_REQUESTS_FOR_QUOTATION

used by View APPS.POFV_RFQ_SUPPLIERS

used by View APPS.POFV_RFQ_SUPPLIER_LIST_ENTRIES

used by View APPS.POFV_STD_PURCHASE_ORDERS

used by View APPS.POFV_SUPPLIERS

used by View APPS.POFV_SUPPLIER_SITES

used by View APPS.POS_AP_EXPENSE_REPORTS_V

used by View APPS.POS_PO_SUP_ORDER_INVOICES_V

used by View APPS.PO_APPROVED_SUPPLIER_LIST_V

used by View APPS.PO_ASL_SUPPLIERS_V

used by View APPS.PO_AUTOSOURCE_DOCUMENTS_V

used by View APPS.PO_AUTOSOURCE_RULES_V

used by View APPS.PO_BY_BUYER_V

used by View APPS.PO_CONTRACTS_VAL_V

used by View APPS.PO_CXML_HEADER_ARCH_V

used by View APPS.PO_ECX_HEADER_ARCH_V

used by View APPS.PO_ECX_HEADER_V

used by View APPS.PO_HEADERS_ARCHIVE_XML

used by View APPS.PO_HEADERS_CHANGE_PRINT

used by View APPS.PO_HEADERS_INQ_PO_V

used by View APPS.PO_HEADERS_INQ_REL_V

used by View APPS.PO_HEADERS_INQ_V

used by View APPS.PO_HEADERS_PRINT

used by View APPS.PO_HEADERS_RFQQT_V

used by View APPS.PO_HEADERS_V

used by View APPS.PO_HEADER_RELEASE_V

used by View APPS.PO_ITEM_HISTORY_V

used by View APPS.PO_LINES_INQ_V

used by View APPS.PO_LINE_LOCATIONS_INQ_V

used by View APPS.PO_MASSCANCEL_INTERIM_V

used by View APPS.PO_NOTIFICATION_DETAILS_V

used by View APPS.PO_PURCHASE_HISTORY_V

used by View APPS.PO_PURCHASE_ORDER_V

used by View APPS.PO_QUOTATIONS_TO_APPROVE

used by View APPS.PO_RELEASES_V

used by View APPS.PO_RELEASE_ARCHIVE_XML

used by View APPS.PO_RELEASE_XML

used by View APPS.PO_REQEXPRESS_LINES_V

used by View APPS.PO_REQUISITION_TEMPLATES_V

used by View APPS.PO_RFQS_FOR_QUOTE_ALL_V

used by View APPS.PO_RFQ_HEADERS_PRINT

used by View APPS.PO_RFQ_VENDORS_V

used by View APPS.PO_SOURCE_VENDORS_V

used by View APPS.PO_SUPPLIERS_ALL_V

used by View APPS.PO_SUPPLIERS_VAL_V

used by View APPS.PO_SUPPLIER_OPEN_POS_V

used by View APPS.PO_SUPPLIER_USERS_V

used by View APPS.PO_TEMP_LABOR_HEADERS_V

used by View APPS.PO_VENDORS_VIEW

used by View APPS.PO_VENDOR_LIST_ENTRIES_V

used by View APPS.RCV_AEL_GL_V

used by View APPS.RCV_AEL_SL_MRC_V

used by View APPS.RCV_AEL_SL_V

used by View APPS.RCV_CONFIRM_RECEIPT_V

used by View APPS.RCV_CORRECTIONS_V

used by View APPS.RCV_ENTER_RECEIPTS_ASN_V

used by View APPS.RCV_ENTER_RECEIPTS_PO_V

used by View APPS.RCV_MSH_V

used by View APPS.RCV_MSL_V

used by View APPS.RCV_MUR_V

used by View APPS.RCV_RECEIPTS_ALL_V

used by View APPS.RCV_RECEIPTS_PRINT

used by View APPS.RCV_RECEIPTS_PRINT_PO

used by View APPS.RCV_RETURNS_V

used by View APPS.RCV_SUPPLIERS_VAL_V

used by View APPS.RCV_TRANSACTIONS_V

used by View APPS.RCV_VIEW_INTERFACE_V

used by View APPS.RCV_VRC_HDS_V

used by View APPS.RCV_VRC_TXS_INT_V

used by View APPS.RCV_VRC_TXS_V

used by View APPS.RCV_VRC_TXS_VENDINT_V
View APPS.PO_VENDOR_CONTACTS used by View APPS.POBV_SUPPLIER_CONTACTS

used by View APPS.POFV_BKT_PURCHASE_ORDERS

used by View APPS.POFV_PLAN_PURCHASE_ORDERS

used by View APPS.POFV_PURCHASE_CONTRACTS

used by View APPS.POFV_PURCHASE_ORDERS

used by View APPS.POFV_QUOTATIONS

used by View APPS.POFV_REQUESTS_FOR_QUOTATION

used by View APPS.POFV_RFQ_SUPPLIERS

used by View APPS.POFV_RFQ_SUPPLIER_LIST_ENTRIES

used by View APPS.POFV_STD_PURCHASE_ORDERS

used by View APPS.POFV_SUPPLIER_CONTACTS

used by View APPS.PO_CXML_HEADER_ARCH_V

used by View APPS.PO_ECX_HEADER_ARCH_V

used by View APPS.PO_HEADERS_ARCHIVE_XML

used by View APPS.PO_HEADERS_INQ_PO_V

used by View APPS.PO_HEADERS_INQ_V

used by View APPS.PO_HEADERS_PRINT

used by View APPS.PO_HEADERS_RFQQT_V

used by View APPS.PO_HEADERS_V

used by View APPS.PO_HEADERS_XML

used by View APPS.PO_LINES_INQ_V

used by View APPS.PO_LINE_LOCATIONS_INQ_V

used by View APPS.PO_PURCHASE_HISTORY_V

used by View APPS.PO_RELEASES_V

used by View APPS.PO_RELEASE_ARCHIVE_XML

used by View APPS.PO_RELEASE_XML

used by View APPS.PO_REQEXPRESS_LINES_V

used by View APPS.PO_REQUISITION_TEMPLATES_V

used by View APPS.PO_RFQ_HEADERS_PRINT

used by View APPS.PO_RFQ_VENDORS_V

used by View APPS.PO_SUPPLIER_CONTACTS_VAL_V

used by View APPS.PO_VENDOR_LIST_ENTRIES_V
View APPS.PO_VENDOR_SITES used by View APPS.PO_APPROVED_SUPPLIER_LIST_V

used by View APPS.PO_ASL_SUPPLIERS_V

used by View APPS.PO_HEADERS_CHANGE_PRINT

used by View APPS.PO_RFQ_VENDORS_V

used by View APPS.PO_SUPPLIER_PO_SITES_VAL_V

used by View APPS.PO_SUPPLIER_SITES_ALL_V

used by View APPS.PO_SUPPLIER_SITES_VAL_V

used by View APPS.PO_VENDOR_LIST_ENTRIES_V

used by View APPS.RCV_AEL_SL_MRC_V

used by View APPS.RCV_AEL_SL_V

used by View APPS.RCV_MSH_V

used by View APPS.RCV_MSL_V

used by View APPS.RCV_VRC_TXS_INT_V

used by View APPS.RCV_VRC_TXS_V

used by View APPS.RCV_VRC_TXS_VENDINT_V
View APPS.PO_VENDOR_SITES_ALL used by View APPS.RCV_AEL_GL_V

139 dependencies

[top of page]

POS - iSupplier Portal

SQLAP Item Dependency POS Item
View APPS.PO_VENDORS used by View APPS.POS_BILL_ONLY_ORDERS_V

used by View APPS.POS_BLANKET_AGREE_V

used by View APPS.POS_CONSIGNED_SHIPMENTS_V

used by View APPS.POS_ORDER_SUMMARY_V

used by View APPS.POS_PLAN_SCHEDULE_HEADERS_V

used by View APPS.POS_PO_ARCH_SUMMARY_V

used by View APPS.POS_SHIP_SCHEDULE_HEADERS_V

used by View APPS.POS_SUPPLIER_USERS_V

used by View APPS.POS_SUPP_AGREEMENTS_V

used by View APPS.POS_VIEW_PO_SUMMARY_V

10 dependencies

[top of page]

QA - Quality

SQLAP Item Dependency QA Item
View APPS.PO_VENDORS used by View APPS.QAFV_QUALITY_SPECIFICATIONS

used by View APPS.QA_ERES_RCV_TRANS_INTERFACE_V

used by View APPS.QA_ERES_SPECS_V

3 dependencies

[top of page]

WIP - Work in Process

SQLAP Item Dependency WIP Item
View APPS.PO_VENDORS used by View APPS.WIP_EAM_DIRECT_ITEMS_V

used by View APPS.WIP_EAM_OSP_V

used by View APPS.WIP_ICX_OSP_WORKBENCH_V

3 dependencies

[top of page]

WMS - Warehouse Management

SQLAP Item Dependency WMS Item
View APPS.PO_VENDORS used by View APPS.WMS_LABEL_REQUESTS_HIST_V
View APPS.PO_VENDOR_SITES_ALL used by View APPS.WMS_LABEL_REQUESTS_HIST_V

2 dependencies

[top of page]

WSH - Shipping Execution

SQLAP Item Dependency WSH Item
View APPS.PO_VENDORS used by View APPS.WSH_BOLS_DB_V

used by View APPS.WSH_BOLS_RD_V

used by View APPS.WSH_CAL_ASG_DETAIL_V

used by View APPS.WSH_CAL_ASG_MASTER_V

used by View APPS.WSH_CONSIGNEES_V

used by View APPS.WSH_PURGE_SET_V
View APPS.PO_VENDOR_SITES_ALL used by View APPS.WSH_CAL_ASG_DETAIL_V

used by View APPS.WSH_ITM_SHIPMENT_V

8 dependencies

[top of page]

XTR - Treasury

SQLAP Item Dependency XTR Item
View APPS.AP_LOOKUP_CODES 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
View APPS.PO_VENDORS 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
View APPS.PO_VENDOR_SITES_ALL 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

9 dependencies

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