eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
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®,
OracleDevConnect SM, Oracle® Discoverer,
Oracle® Expert, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile, Oracle Names®,
Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services, Oracle® SQL*TutorSM,
OracleSTERLING SM, 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 - OE Tables and Views
TABLE - OE.OE_BIS_BBB_INFO
TABLE - OE.OE_BIS_CUST_SAT_T
TABLE - OE.OE_BIS_CUST_SAT_T2
TABLE - OE.OE_BIS_TOP_CUSTOMERS
TABLE - OE.SO_ACTIONS
TABLE - OE.SO_ACTION_CLAUSES
TABLE - OE.SO_ACTION_PRE_REQS
TABLE - OE.SO_ACTION_RESULTS
TABLE - OE.SO_AGREEMENTS_B
TABLE - OE.SO_AGREEMENTS_TL
TABLE - OE.SO_ATTRIBUTES
TABLE - OE.SO_ATTRIBUTE_STD_VALUE_SOURCES
TABLE - OE.SO_ATTRIBUTE_USES
TABLE - OE.SO_CREDIT_CHECK_RULES_115
TABLE - OE.SO_CYCLES
TABLE - OE.SO_CYCLE_ACTIONS
TABLE - OE.SO_DISCOUNTS
TABLE - OE.SO_DISCOUNT_CUSTOMERS
TABLE - OE.SO_DISCOUNT_LINES_115
TABLE - OE.SO_DROP_SHIP_SOURCES
TABLE - OE.SO_ENTITIES
TABLE - OE.SO_ENTITY_USES
TABLE - OE.SO_EXCEPTIONS
TABLE - OE.SO_FREIGHT_CHARGES
TABLE - OE.SO_FREIGHT_CHARGE_TYPES
TABLE - OE.SO_GENERAL_STD_VALUE_SOURCES
TABLE - OE.SO_HEADERS_ALL
TABLE - OE.SO_HEADERS_INTERFACE_ALL
TABLE - OE.SO_HEADER_ATTRIBUTES
TABLE - OE.SO_HEADER_ATTRIBUTES_INTERFACE
TABLE - OE.SO_HOLDS
TABLE - OE.SO_HOLD_AUTHORIZATIONS
TABLE - OE.SO_HOLD_RELEASES
TABLE - OE.SO_HOLD_SOURCES_ALL
TABLE - OE.SO_ITEM_GROUPS
TABLE - OE.SO_ITEM_GROUP_LINES
TABLE - OE.SO_LINES_ALL
TABLE - OE.SO_LINES_INTERFACE_ALL
TABLE - OE.SO_LINE_APPROVALS
TABLE - OE.SO_LINE_ATTRIBUTES
TABLE - OE.SO_LINE_ATTRIBUTES_INTERFACE
TABLE - OE.SO_LINE_DETAILS
TABLE - OE.SO_LINE_DETAILS_INTERFACE
TABLE - OE.SO_LINE_DETAIL_ATTRIBUTES
TABLE - OE.SO_LINE_DETAIL_ATTRIBUTES_INT
TABLE - OE.SO_LINE_SERVICE_DETAILS
TABLE - OE.SO_NOTES
TABLE - OE.SO_NOTE_ADDITION_RULES
TABLE - OE.SO_NOTE_REFERENCES
TABLE - OE.SO_NOTE_REPLICATION
TABLE - OE.SO_NOTE_USAGES
TABLE - OE.SO_NOTE_USAGE_ATTRIBUTES
TABLE - OE.SO_OBJECTS
TABLE - OE.SO_ORDER_APPROVALS
TABLE - OE.SO_ORDER_CANCELLATIONS
TABLE - OE.SO_ORDER_HOLDS_ALL
TABLE - OE.SO_ORDER_NUMBER_SOURCES
TABLE - OE.SO_ORDER_SOURCES_115
TABLE - OE.SO_ORDER_TYPES_115_ALL
TABLE - OE.SO_PICKING_BATCHES_ALL
TABLE - OE.SO_PICKING_CANCELLATIONS
TABLE - OE.SO_PICKING_HEADERS_ALL
TABLE - OE.SO_PICKING_LINES_ALL
TABLE - OE.SO_PICKING_LINE_DETAILS
TABLE - OE.SO_PICKING_RULES
TABLE - OE.SO_PRICE_ADJUSTMENTS
TABLE - OE.SO_PRICE_ADJUSTMENTS_INTERFACE
TABLE - OE.SO_PRICE_BREAK_LINES
TABLE - OE.SO_PRICE_COPY_PARAMETERS
TABLE - OE.SO_PRICE_LISTS_B
TABLE - OE.SO_PRICE_LISTS_TL
TABLE - OE.SO_PRICE_LIST_LINES_115
TABLE - OE.SO_PRICING_RULES_B
TABLE - OE.SO_PRICING_RULES_TL
TABLE - OE.SO_PRICING_RULE_LINES
TABLE - OE.SO_PRICING_RULE_LINE_VALUES
TABLE - OE.SO_PURGE_ORDERS
TABLE - OE.SO_REPORTS
TABLE - OE.SO_REPORT_PARAMETERS
TABLE - OE.SO_REPORT_PRINTERS
TABLE - OE.SO_REPORT_SETS
TABLE - OE.SO_REPORT_SET_LINES
TABLE - OE.SO_REPORT_SOURCE_PARAMETERS
TABLE - OE.SO_REPORT_USAGES
TABLE - OE.SO_RESULTS_B
TABLE - OE.SO_RESULTS_TL
TABLE - OE.SO_RULE_FORMULA_COMPONENTS
TABLE - OE.SO_SALES_CREDITS
TABLE - OE.SO_SALES_CREDITS_INTERFACE
TABLE - OE.SO_SALES_CREDIT_TYPES_115
TABLE - OE.SO_SECURITY_RULES
TABLE - OE.SO_SERVICE_DETAILS_INTERFACE
TABLE - OE.SO_STANDARD_VALUE_RULES
TABLE - OE.SO_STANDARD_VALUE_RULE_SETS
TABLE - OE.WSH_CONTAINER_LOAD
TABLE - OE.WSH_DELIVERIES
TABLE - OE.WSH_DELIVERIES_INTERFACE
TABLE - OE.WSH_DELIVERY_TEMPLATES
TABLE - OE.WSH_DEPARTURES
TABLE - OE.WSH_DEPARTURE_TEMPLATES
TABLE - OE.WSH_FREIGHT_CHARGES_INTERFACE
TABLE - OE.WSH_INVOICE_NUMBERS
TABLE - OE.WSH_PACKED_CONTAINERS
TABLE - OE.WSH_PACKED_CONTAINER_INTERFACE
TABLE - OE.WSH_PARAMETERS
TABLE - OE.WSH_PICK_SLIP_RULES
TABLE - OE.WSH_RELEASE_SEQ_RULES
TABLE - OE.WSH_REPORT_TEMP
VIEW - APPS.OEBV_CUSTOMER_AGREEMENTS
VIEW - APPS.OEBV_ORDER_CANCELLATIONS
VIEW - APPS.OEBV_ORDER_HOLDS
VIEW - APPS.OEBV_PRICE_ADJUSTMENTS
VIEW - APPS.OEBV_SALES_CREDIT_TYPES
VIEW - APPS.OEBV_SALES_ORDER_TYPES
VIEW - APPS.OEFV_CUSTOMER_AGREEMENTS
VIEW - APPS.OEFV_ORDER_CANCELLATIONS
VIEW - APPS.OEFV_ORDER_HOLDS
VIEW - APPS.OEFV_PRICE_ADJUSTMENTS
VIEW - APPS.OEFV_SALES_CREDIT_TYPES
VIEW - APPS.OEFV_SALES_ORDER_TYPES
VIEW - APPS.OE_BIS_BACKLOG_V
VIEW - APPS.OE_BIS_BILLINGS_V
VIEW - APPS.OE_BIS_BOOKINGS_V
VIEW - APPS.OE_BIS_CANCELLED_BOOKINGS_V
VIEW - APPS.OE_BIS_CUSTOMER_RETURNS_V
VIEW - APPS.OE_BIS_CUST_SAT_V
VIEW - APPS.SO_AGREEMENTS_VL
VIEW - APPS.SO_CONFIG_COMPONENTS_V
VIEW - APPS.SO_CREDIT_CARDS_V
VIEW - APPS.SO_CURRENCIES_VAL_V
VIEW - APPS.SO_CYCLE_ACTION_NAMES_V
VIEW - APPS.SO_DELIVERIES_V
VIEW - APPS.SO_DEMAND_CLASSES_ACTIVE_V
VIEW - APPS.SO_DROP_SHIP_LINKS_V
VIEW - APPS.SO_ENTITIES_PARAMETERS_V
VIEW - APPS.SO_ENTRY_STATUSES_ACTIVE_V
VIEW - APPS.SO_FC_ORDERS_V
VIEW - APPS.SO_FC_RETURNS_V
VIEW - APPS.SO_FOBS_ACTIVE_V
VIEW - APPS.SO_FREIGHT_CARRIERS_ACTIVE_V
VIEW - APPS.SO_FREIGHT_CHARGES_V
VIEW - APPS.SO_FREIGHT_CHARGE_TYPES_V
VIEW - APPS.SO_FREIGHT_TERMS_ACTIVE_V
VIEW - APPS.SO_HEADERS
VIEW - APPS.SO_HEADERS_INTERFACE
VIEW - APPS.SO_HEADERS_IOP_115_V
VIEW - APPS.SO_HOLD_SOURCES
VIEW - APPS.SO_INCLUDED_ITEMS_OEXORRSO_V
VIEW - APPS.SO_INVOICING_RULES_V
VIEW - APPS.SO_ITEM_GROUP_LINES_ALL_V
VIEW - APPS.SO_ITEM_WAREHOUSES_V
VIEW - APPS.SO_LINES
VIEW - APPS.SO_LINES_CANCEL_V
VIEW - APPS.SO_LINES_CURRENT_DEMAND_V
VIEW - APPS.SO_LINES_INTERFACE
VIEW - APPS.SO_LINES_RETURN_LINES_V
VIEW - APPS.SO_LINES_RMA_V
VIEW - APPS.SO_LINES_SUMMARY_V
VIEW - APPS.SO_LINES_VIEW_RETURNS_V
VIEW - APPS.SO_LINE_DETAILS_V
VIEW - APPS.SO_LINE_DETAILS_VIEW_WIP_V
VIEW - APPS.SO_LINE_SALES_CREDITS
VIEW - APPS.SO_LOOKUPS_115
VIEW - APPS.SO_MANUAL_DISCOUNTS_V
VIEW - APPS.SO_MFG_STATUS_VIEW
VIEW - APPS.SO_MODEL_LINE_COGS_ACCOUNT
VIEW - APPS.SO_MTL_DEMAND_INT_DELIVERY
VIEW - APPS.SO_MTL_DEMAND_INT_LINE_ID
VIEW - APPS.SO_NOTE_USAGE_ATTR_V
VIEW - APPS.SO_OPEN_ORDER_INVOICE_REFS_V
VIEW - APPS.SO_ORDER_CANCELLATIONS_V
VIEW - APPS.SO_ORDER_HEADER_STATUS
VIEW - APPS.SO_ORDER_HOLDS_115
VIEW - APPS.SO_ORDER_HOLDS_VIEW_HOLD_V
VIEW - APPS.SO_ORDER_LINE_STATUS
VIEW - APPS.SO_ORDER_STATUS_V
VIEW - APPS.SO_ORDER_TYPES_115
VIEW - APPS.SO_ORDER_TYPES_REGULAR_V
VIEW - APPS.SO_PAYMENT_TERMS_V
VIEW - APPS.SO_PAYMENT_TYPES_V
VIEW - APPS.SO_PICKING_BATCHES
VIEW - APPS.SO_PICKING_HEADERS
VIEW - APPS.SO_PICKING_LINES
VIEW - APPS.SO_PICKING_LINES_V
VIEW - APPS.SO_PICKING_LINE_DETAILS_V
VIEW - APPS.SO_PICKING_LINE_DETAIL_VO_V
VIEW - APPS.SO_PICKING_LINE_DET_OEXORRSO_V
VIEW - APPS.SO_PO_REQUISITION_LINES_V
VIEW - APPS.SO_PRICE_ADJUSTMENTS_V
VIEW - APPS.SO_PRICE_LISTS_ACTIVE_V
VIEW - APPS.SO_PRICE_LISTS_VL
VIEW - APPS.SO_PRICE_LIST_LINES_ALL_V
VIEW - APPS.SO_PRICING_RULES_VL
VIEW - APPS.SO_RA_CUSTOMER_TRX_V
VIEW - APPS.SO_REPORT_NAMES_V
VIEW - APPS.SO_REPORT_PRINTERS_QF_V
VIEW - APPS.SO_REPORT_SET_LINES_V
VIEW - APPS.SO_RESULTS_VL
VIEW - APPS.SO_RMA_MTL_INT_DETAIL_V
VIEW - APPS.SO_RMA_MTL_INT_V
VIEW - APPS.SO_SALESPERSONS_ACTIVE_V
VIEW - APPS.SO_SALES_CHANNELS_V
VIEW - APPS.SO_SALES_CREDITS_V
VIEW - APPS.SO_SCHEDULE_DETAILS
VIEW - APPS.SO_SERVICE_DETAILS
VIEW - APPS.SO_SHIP_PRIORITIES_ACTIVE_V
VIEW - APPS.SO_STANDARD_VALUE_SOURCES
VIEW - APPS.SO_TAX_CODES_V
VIEW - APPS.SO_TAX_REASONS_V
VIEW - APPS.SO_TAX_STATUSES_V
VIEW - APPS.SO_USERS_VAL_V
VIEW - APPS.SO_VALID_RESULTS_V
VIEW - APPS.WSHBV_CONTAINER_CONTENT
VIEW - APPS.WSHBV_CONTAINER_LOAD
VIEW - APPS.WSHBV_DELIVERY
VIEW - APPS.WSHBV_DEPARTURE
VIEW - APPS.WSHBV_FREIGHT_CHARGE
VIEW - APPS.WSHBV_FREIGHT_CHARGE_TYPE
VIEW - APPS.WSHBV_LINE_PICK_SEQUENCE_RULE
VIEW - APPS.WSHBV_PACKED_CONTAINER
VIEW - APPS.WSHBV_PICKING_BATCH
VIEW - APPS.WSHBV_PICK_HEADER
VIEW - APPS.WSHBV_PICK_LINE
VIEW - APPS.WSHBV_PICK_LINE_DETAIL
VIEW - APPS.WSHBV_PICK_LINE_GROUPING_RULE
VIEW - APPS.WSHBV_PICK_RELEASE_RULE
VIEW - APPS.WSHFV_CONTAINER_CONTENT
VIEW - APPS.WSHFV_CONTAINER_LOAD
VIEW - APPS.WSHFV_DEPARTURE
VIEW - APPS.WSHFV_FREIGHT_CHARGE
VIEW - APPS.WSHFV_FREIGHT_CHARGE_TYPE
VIEW - APPS.WSHFV_LINE_PICK_SEQUENCE_RULE
VIEW - APPS.WSHFV_PACKED_CONTAINER
VIEW - APPS.WSHFV_PICK_LINE_GROUPING_RULE
VIEW - APPS.WSH_BIS_BACKORDERED_SUM_V
VIEW - APPS.WSH_BIS_FILL_BY_DAY_V
VIEW - APPS.WSH_BIS_FILL_RATE_V
VIEW - APPS.WSH_BIS_SHIPPED_BY_DAY_V
VIEW - APPS.WSH_BIS_WAREHOUSE_DOCS_V
VIEW - APPS.WSH_CHARGES_V
VIEW - APPS.WSH_CONTAINER_CONTENTS_V
VIEW - APPS.WSH_DELIVERIES_DPW_LOV_V
VIEW - APPS.WSH_DEPARTURES_V
VIEW - APPS.WSH_DEPARTURE_TEMPLATES_V
VIEW - APPS.WSH_PACKED_CONTAINERS_DPW_V
VIEW - APPS.WSH_PACKED_CONTAINERS_V
VIEW - APPS.WSH_PICKING_DETAILS_INTERFACE
VIEW - APPS.WSH_SHIPPING_DETAILS_V
Table: OE_BIS_BBB_INFO
[top of page]
OE.OE_BIS_BBB_INFO does not reference any database object
OE.OE_BIS_BBB_INFO is referenced by following:
APPS
SYNONYM - OE_BIS_BBB_INFO
[top of page]
Table: OE_BIS_CUST_SAT_T
[top of page]
OE.OE_BIS_CUST_SAT_T does not reference any database object
OE.OE_BIS_CUST_SAT_T is referenced by following:
APPS
SYNONYM - OE_BIS_CUST_SAT_T
[top of page]
Table: OE_BIS_CUST_SAT_T2
[top of page]
OE.OE_BIS_CUST_SAT_T2 does not reference any database object
OE.OE_BIS_CUST_SAT_T2 is referenced by following:
APPS
SYNONYM - OE_BIS_CUST_SAT_T2
[top of page]
Table: OE_BIS_TOP_CUSTOMERS
Primary Key: CUSTOMER_ID_PK
CUSTOMER_ID
[top of page]
OE.OE_BIS_TOP_CUSTOMERS does not reference any database object
OE.OE_BIS_TOP_CUSTOMERS is referenced by following:
APPS
SYNONYM - OE_BIS_TOP_CUSTOMERS
[top of page]
Table: SO_ACTIONS
Description: Cycle actions for order cycles
Primary Key: SO_ACTIONS_PK
ACTION_ID
Primary Key: SO_ACTIONS_UK1
RESULT_COLUMN
RESULT_TABLE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ACTIONS.PASSING_RESULT_ID
SO_RESULTS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_ACTION_CLAUSES.ACTION_ID
SO_ACTIONS
SO_ACTION_PRE_REQS.ACTION_ID
SO_ACTIONS
SO_ACTION_RESULTS.ACTION_ID
SO_ACTIONS
SO_CYCLE_ACTIONS.ACTION_ID
SO_ACTIONS
SO_HOLDS.ACTION_ID
SO_ACTIONS
SO_LINE_APPROVALS.ACTION_ID
SO_ACTIONS
SO_ORDER_APPROVALS.ACTION_ID
SO_ACTIONS
SO_SECURITY_RULES.ACTION_ID
SO_ACTIONS
[top of page]
OE.SO_ACTIONS does not reference any database object
OE.SO_ACTIONS is referenced by following:
APPS
SYNONYM - SO_ACTIONS
[top of page]
Table: SO_ACTION_CLAUSES
Description: Cycle action where clauses
Primary Key: SO_ACTION_CLAUSES_PK
ACTION_ID
TYPE
SEQUENCE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ACTION_CLAUSES.ACTION_ID
SO_ACTIONS
[top of page]
OE.SO_ACTION_CLAUSES does not reference any database object
OE.SO_ACTION_CLAUSES is referenced by following:
APPS
SYNONYM - SO_ACTION_CLAUSES
[top of page]
Table: SO_ACTION_PRE_REQS
Description: Cycle action prerequisites
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ACTION_PRE_REQS.CYCLE_ACTION_ID
SO_CYCLE_ACTIONS
SO_ACTION_PRE_REQS.RESULT_ID
SO_RESULTS_B
SO_ACTION_PRE_REQS.ACTION_ID
SO_ACTIONS
[top of page]
OE.SO_ACTION_PRE_REQS does not reference any database object
OE.SO_ACTION_PRE_REQS is referenced by following:
APPS
SYNONYM - SO_ACTION_PRE_REQS
[top of page]
Table: SO_ACTION_RESULTS
Description: Cycle action results for order cycles
Primary Key: SO_ACTION_RESULTS_PK
ACTION_ID
RESULT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ACTION_RESULTS.ACTION_ID
SO_ACTIONS
SO_ACTION_RESULTS.RESULT_ID
SO_RESULTS_B
[top of page]
OE.SO_ACTION_RESULTS does not reference any database object
OE.SO_ACTION_RESULTS is referenced by following:
APPS
SYNONYM - SO_ACTION_RESULTS
[top of page]
Table: SO_AGREEMENTS_B
Description: Customer agreements
Primary Key: SO_AGREEMENTS_B_PK
AGREEMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_AGREEMENTS_B.TERM_ID
RA_TERMS_B
SO_AGREEMENTS_B.INVOICING_RULE_ID
RA_RULES
SO_AGREEMENTS_B.ACCOUNTING_RULE_ID
RA_RULES
SO_AGREEMENTS_B.CUSTOMER_ID
RA_CUSTOMERS
SO_AGREEMENTS_B.INVOICE_CONTACT_ID
%
SO_AGREEMENTS_B.AGREEMENT_CONTACT_ID
%
SO_AGREEMENTS_B.INVOICE_TO_SITE_USE_ID
RA_SITE_USES_ALL
SO_AGREEMENTS_B.SALESREP_ID
RA_SALESREPS_ALL
SO_AGREEMENTS_B.PRICE_LIST_ID
SO_PRICE_LISTS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
RA_CUSTOMER_TRX_ALL.AGREEMENT_ID
SO_AGREEMENTS_B
SO_HEADERS_ALL.AGREEMENT_ID
SO_AGREEMENTS_B
SO_HEADERS_INTERFACE_ALL.AGREEMENT_ID
SO_AGREEMENTS_B
SO_LINES_ALL.AGREEMENT_ID
SO_AGREEMENTS_B
SO_LINES_INTERFACE_ALL.AGREEMENT_ID
SO_AGREEMENTS_B
[top of page]
OE.SO_AGREEMENTS_B does not reference any database object
OE.SO_AGREEMENTS_B is referenced by following:
APPS
SYNONYM - SO_AGREEMENTS_B
[top of page]
Table: SO_AGREEMENTS_TL
Description: Translation table for SO_AGREEMENTS_B
Primary Key: SO_AGREEMENTS_TL_PK
AGREEMENT_ID
LANGUAGE
Primary Key: SO_AGREEMENTS_TL_UK1
NAME
LANGUAGE
[top of page]
OE.SO_AGREEMENTS_TL does not reference any database object
OE.SO_AGREEMENTS_TL is referenced by following:
APPS
SYNONYM - SO_AGREEMENTS_TL
[top of page]
Table: SO_ATTRIBUTES
Description: Attributes used in security rules and standard value rules sets
Primary Key: SO_ATTRIBUTES_PK
ATTRIBUTE_ID
Primary Key: SO_ATTRIBUTES_UK1
ATTRIBUTE_CODE
OBJECT_ID
Primary Key: SO_ATTRIBUTES_UK2
OBJECT_ID
NAME
Primary Key: SO_ATTRIBUTES_UK3
OBJECT_ID
SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ATTRIBUTES.OBJECT_ID
SO_OBJECTS
SO_ATTRIBUTES.REPRESENTED_OBJECT_ID
SO_OBJECTS
SO_ATTRIBUTES.DESCR_FLEX_APPLICATION_ID
SO_ATTRIBUTES.DESCRIPTIVE_FLEXFIELD_NAME
FND_DESCRIPTIVE_FLEXS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_ATTRIBUTE_USES.ATTRIBUTE_ID
SO_ATTRIBUTES
SO_ATTRIBUTE_STD_VALUE_SOURCES.ATTRIBUTE_ID
SO_ATTRIBUTES
SO_SECURITY_RULES.ATTRIBUTE_ID
SO_ATTRIBUTES
SO_STANDARD_VALUE_RULES.ATTRIBUTE_ID
SO_ATTRIBUTES
[top of page]
OE.SO_ATTRIBUTES does not reference any database object
OE.SO_ATTRIBUTES is referenced by following:
APPS
SYNONYM - SO_ATTRIBUTES
[top of page]
Table: SO_ATTRIBUTE_STD_VALUE_SOURCES
Description: Sources for standard value rules
Primary Key: SO_ATTR_STD_VALUE_SOURCES_PK
ATTRIBUTE_STD_VALUE_SOURCE_ID
Primary Key: SO_ATTR_STD_VALUE_SOURCES_UK1
ATTRIBUTE_ID
STANDARD_VALUE_SOURCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ATTRIBUTE_STD_VALUE_SOURCES.ATTRIBUTE_ID
SO_ATTRIBUTES
[top of page]
OE.SO_ATTRIBUTE_STD_VALUE_SOURCES does not reference any database object
OE.SO_ATTRIBUTE_STD_VALUE_SOURCES is referenced by following:
APPS
SYNONYM - SO_ATTRIBUTE_STD_VALUE_SOURCES
[top of page]
Table: SO_ATTRIBUTE_USES
Description: Attribute uses asociated with security rules and standard value rule sets
Primary Key: SO_ATTRIBUTE_USES_PK
ATTRIBUTE_USE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ATTRIBUTE_USES.ATTRIBUTE_ID
SO_ATTRIBUTES
[top of page]
OE.SO_ATTRIBUTE_USES does not reference any database object
OE.SO_ATTRIBUTE_USES is referenced by following:
APPS
SYNONYM - SO_ATTRIBUTE_USES
[top of page]
Table: SO_CREDIT_CHECK_RULES_115
Description: Table to store Credit Check Rules.
Primary Key: SO_CREDIT_CHECK_RULES_115_PK
CREDIT_CHECK_RULE_ID
Primary Key: SO_CREDIT_CHECK_RULES_115_UK
NAME
[top of page]
OE.SO_CREDIT_CHECK_RULES_115 does not reference any database object
OE.SO_CREDIT_CHECK_RULES_115 is referenced by following:
APPS
SYNONYM - SO_CREDIT_CHECK_RULES_115
[top of page]
Table: SO_CYCLES
Description: Order cycles for processing orders and returns
Primary Key: SO_CYCLES_PK
CYCLE_ID
Primary Key: SO_CYCLES_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_CYCLE_ACTIONS.CYCLE_ID
SO_CYCLES
SO_HEADERS_ALL.CYCLE_ID
SO_CYCLES
SO_HEADERS_INTERFACE_ALL.CYCLE_ID
SO_CYCLES
SO_LINES_ALL.CYCLE_ID
SO_CYCLES
SO_CYCLES
[top of page]
OE.SO_CYCLES does not reference any database object
OE.SO_CYCLES is referenced by following:
APPS
SYNONYM - SO_CYCLES
[top of page]
Table: SO_CYCLE_ACTIONS
Description: Order cycle actions
Primary Key: SO_CYCLE_ACTIONS_PK
CYCLE_ACTION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_CYCLE_ACTIONS.CYCLE_ID
SO_CYCLES
SO_CYCLE_ACTIONS.ACTION_ID
SO_ACTIONS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_ACTION_PRE_REQS.CYCLE_ACTION_ID
SO_CYCLE_ACTIONS
[top of page]
OE.SO_CYCLE_ACTIONS does not reference any database object
OE.SO_CYCLE_ACTIONS is referenced by following:
APPS
SYNONYM - SO_CYCLE_ACTIONS
[top of page]
Table: SO_DISCOUNTS
Description: Discounts for use in price adjustments
Primary Key: SO_DISCOUNTS_PK
DISCOUNT_ID
Primary Key: SO_DISCOUNTS_UK1
PRICE_LIST_ID
NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_DISCOUNTS.PRICE_LIST_ID
SO_PRICE_LISTS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_DISCOUNT_CUSTOMERS.DISCOUNT_ID
SO_DISCOUNTS
SO_DISCOUNT_LINES_115.DISCOUNT_ID
SO_DISCOUNTS
SO_PRICE_ADJUSTMENTS.DISCOUNT_ID
SO_DISCOUNTS
SO_PRICE_ADJUSTMENTS_INTERFACE.DISCOUNT_ID
SO_DISCOUNTS
[top of page]
OE.SO_DISCOUNTS does not reference any database object
OE.SO_DISCOUNTS is referenced by following:
APPS
SYNONYM - SO_DISCOUNTS
[top of page]
Table: SO_DISCOUNT_CUSTOMERS
Description: Discounts for specific customers
Primary Key: SO_DISCOUNT_CUSTOMERS_PK
DISCOUNT_CUSTOMER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_DISCOUNT_CUSTOMERS.DISCOUNT_ID
SO_DISCOUNTS
SO_DISCOUNT_CUSTOMERS.CUSTOMER_ID
RA_CUSTOMERS
SO_DISCOUNT_CUSTOMERS.SITE_USE_ID
RA_SITE_USES_ALL
[top of page]
OE.SO_DISCOUNT_CUSTOMERS does not reference any database object
OE.SO_DISCOUNT_CUSTOMERS is referenced by following:
APPS
SYNONYM - SO_DISCOUNT_CUSTOMERS
[top of page]
Table: SO_DISCOUNT_LINES_115
Description: Discounts for order lines
Primary Key: SO_DISCOUNT_LINES_115_PK
DISCOUNT_LINE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_DISCOUNT_LINES_115.DISCOUNT_ID
SO_DISCOUNTS
SO_DISCOUNT_LINES_115.ENTITY_ID
SO_ENTITIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_PRICE_ADJUSTMENTS.DISCOUNT_LINE_ID
SO_DISCOUNT_LINES_115
SO_PRICE_BREAK_LINES.DISCOUNT_LINE_ID
SO_DISCOUNT_LINES_115
[top of page]
OE.SO_DISCOUNT_LINES_115 does not reference any database object
OE.SO_DISCOUNT_LINES_115 is referenced by following:
APPS
SYNONYM - SO_DISCOUNT_LINES_115
[top of page]
Table: SO_DROP_SHIP_SOURCES
Description: Cross-reference table to hold relationships between sales order lines and purchase orders
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_DROP_SHIP_SOURCES.LINE_ID
SO_LINES_ALL
SO_DROP_SHIP_SOURCES.REQUISITION_HEADER_ID
PO_REQUISITION_HEADERS_ALL
SO_DROP_SHIP_SOURCES.REQUISITION_LINE_ID
PO_REQUISITION_LINES_ALL
SO_DROP_SHIP_SOURCES.LINE_LOCATION_ID
PO_LINE_LOCATIONS_ALL
SO_DROP_SHIP_SOURCES.PO_LINE_ID
PO_LINES_ALL
SO_DROP_SHIP_SOURCES.PO_HEADER_ID
PO_HEADERS_ALL
[top of page]
OE.SO_DROP_SHIP_SOURCES does not reference any database object
OE.SO_DROP_SHIP_SOURCES is referenced by following:
APPS
SYNONYM - SO_DROP_SHIP_SOURCES
[top of page]
Table: SO_ENTITIES
Description: Entities for pricing, holds, and notes
Primary Key: SO_ENTITIES_PK
ENTITY_ID
Primary Key: SO_ENTITIES_UK1
ENTITY_CODE
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_DISCOUNT_LINES_115.ENTITY_ID
SO_ENTITIES
SO_ENTITY_USES.ENTITY_ID
SO_ENTITIES
SO_NOTE_ADDITION_RULES.ENTITY_ID
SO_ENTITIES
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_2
SO_ENTITIES
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_1
SO_ENTITIES
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_3
SO_ENTITIES
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_4
SO_ENTITIES
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_5
SO_ENTITIES
[top of page]
OE.SO_ENTITIES does not reference any database object
OE.SO_ENTITIES is referenced by following:
APPS
SYNONYM - SO_ENTITIES
[top of page]
Table: SO_ENTITY_USES
Primary Key: SO_ENTITY_USES_PK
ENTITY_ID
ENTITY_USE_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ENTITY_USES.ENTITY_ID
SO_ENTITIES
[top of page]
OE.SO_ENTITY_USES does not reference any database object
OE.SO_ENTITY_USES is referenced by following:
APPS
SYNONYM - SO_ENTITY_USES
[top of page]
Table: SO_EXCEPTIONS
Description: Oracle Order Entry/Shipping concurrent request messages and errors
[top of page]
OE.SO_EXCEPTIONS does not reference any database object
OE.SO_EXCEPTIONS is referenced by following:
APPS
SYNONYM - SO_EXCEPTIONS
[top of page]
Table: SO_FREIGHT_CHARGES
Description: Freight charges
Primary Key: SO_FREIGHT_CHARGES_PK
FREIGHT_CHARGE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_FREIGHT_CHARGES.FREIGHT_CHARGE_TYPE_ID
SO_FREIGHT_CHARGE_TYPES
SO_FREIGHT_CHARGES.PICKING_HEADER_ID
SO_PICKING_HEADERS_ALL
SO_FREIGHT_CHARGES.DELIVERY_ID
WSH_DELIVERIES
SO_FREIGHT_CHARGES.CONTAINER_ID
WSH_PACKED_CONTAINERS
SO_FREIGHT_CHARGES.PICKING_LINE_DETAIL_ID
SO_PICKING_LINE_DETAILS
[top of page]
OE.SO_FREIGHT_CHARGES does not reference any database object
OE.SO_FREIGHT_CHARGES is referenced by following:
APPS
SYNONYM - SO_FREIGHT_CHARGES
[top of page]
Table: SO_FREIGHT_CHARGE_TYPES
Description: Types of freight charges
Primary Key: SO_FREIGHT_CHARGE_TYPES_PK
FREIGHT_CHARGE_TYPE_ID
Primary Key: SO_FREIGHT_CHARGE_TYPES_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_FREIGHT_CHARGES.FREIGHT_CHARGE_TYPE_ID
SO_FREIGHT_CHARGE_TYPES
[top of page]
OE.SO_FREIGHT_CHARGE_TYPES does not reference any database object
OE.SO_FREIGHT_CHARGE_TYPES is referenced by following:
APPS
SYNONYM - SO_FREIGHT_CHARGE_TYPES
[top of page]
Table: SO_GENERAL_STD_VALUE_SOURCES
Description: Predefined standard value rule sources
Primary Key: SO_GENERAL_STD_VALUE_SOURCE_PK
GENERAL_STD_VALUE_SOURCE_ID
Primary Key: SO_GEN_STD_VALUE_SOURCE_UK1
NAME
[top of page]
OE.SO_GENERAL_STD_VALUE_SOURCES does not reference any database object
OE.SO_GENERAL_STD_VALUE_SOURCES is referenced by following:
APPS
SYNONYM - SO_GENERAL_STD_VALUE_SOURCES
[top of page]
Table: SO_HEADERS_ALL
Description: Order header information
Primary Key: SO_HEADERS_PK
HEADER_ID
Primary Key: SO_HEADERS_UK1
ORDER_NUMBER
ORDER_TYPE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_HEADERS_ALL.CUSTOMER_ID
RA_CUSTOMERS
SO_HEADERS_ALL.AGREEMENT_ID
SO_AGREEMENTS_B
SO_HEADERS_ALL.ORDERED_BY_CONTACT_ID
%
SO_HEADERS_ALL.INVOICE_TO_CONTACT_ID
%
SO_HEADERS_ALL.SHIP_TO_CONTACT_ID
%
SO_HEADERS_ALL.SOURCE_HEADER_ID
SO_HEADERS_ALL
SO_HEADERS_ALL.CURRENCY_CODE
FND_CURRENCIES
SO_HEADERS_ALL.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_HEADERS_ALL.CYCLE_ID
SO_CYCLES
SO_HEADERS_ALL.SALESREP_ID
RA_SALESREPS_ALL
SO_HEADERS_ALL.INVOICE_TO_SITE_USE_ID
RA_SITE_USES_ALL
SO_HEADERS_ALL.SHIP_TO_SITE_USE_ID
RA_SITE_USES_ALL
SO_HEADERS_ALL.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_HEADERS_ALL.TERMS_ID
RA_TERMS_B
SO_HEADERS_ALL.ACCOUNTING_RULE_ID
RA_RULES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_COLLATERAL_REQ_ALL.ORDER_NUMBER
SO_HEADERS_ALL
CST_MARGIN_BUILD.HEADER_ID
SO_HEADERS_ALL
CST_MARGIN_TEMP.HEADER_ID
SO_HEADERS_ALL
ICX_PANEL_SUMMARY.LAST_ORDER_HEADER_ID
SO_HEADERS_ALL
SO_HEADERS_ALL.SOURCE_HEADER_ID
SO_HEADERS_ALL
SO_HOLD_RELEASES.HOLD_ENTITY_ID
SO_HEADERS_ALL
SO_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
SO_HEADERS_ALL
SO_LINES_ALL.HEADER_ID
SO_HEADERS_ALL
SO_LINE_APPROVALS.HEADER_ID
SO_HEADERS_ALL
SO_NOTE_REFERENCES.HEADER_ID
SO_HEADERS_ALL
SO_ORDER_APPROVALS.HEADER_ID
SO_HEADERS_ALL
SO_ORDER_CANCELLATIONS.HEADER_ID
SO_HEADERS_ALL
SO_ORDER_HOLDS_ALL.HEADER_ID
SO_HEADERS_ALL
SO_PICKING_BATCHES_ALL.HEADER_ID
SO_HEADERS_ALL
SO_PICKING_HEADERS_ALL.ORDER_HEADER_ID
SO_HEADERS_ALL
SO_PICKING_RULES.HEADER_ID
SO_HEADERS_ALL
SO_PRICE_ADJUSTMENTS.HEADER_ID
SO_HEADERS_ALL
SO_SALES_CREDITS.HEADER_ID
SO_HEADERS_ALL
[top of page]
OE.SO_HEADERS_ALL does not reference any database object
OE.SO_HEADERS_ALL is referenced by following:
APPS
SYNONYM - SO_HEADERS_ALL
[top of page]
Table: SO_HEADERS_INTERFACE_ALL
Description: Imported order header information
Primary Key: SO_HEADERS_INTERFACE_PK
ORIGINAL_SYSTEM_REFERENCE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_HEADERS_INTERFACE_ALL.ORDER_NUMBER_SOURCE_ID
SO_ORDER_NUMBER_SOURCES
SO_HEADERS_INTERFACE_ALL.SHIP_TO_CUSTOMER_ID
RA_CUSTOMERS
SO_HEADERS_INTERFACE_ALL.SHIP_ADDRESS_ID
RA_ADDRESSES_ALL
SO_HEADERS_INTERFACE_ALL.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_HEADERS_INTERFACE_ALL.TERMS_ID
RA_TERMS_B
SO_HEADERS_INTERFACE_ALL.CYCLE_ID
SO_CYCLES
SO_HEADERS_INTERFACE_ALL.AGREEMENT_ID
SO_AGREEMENTS_B
SO_HEADERS_INTERFACE_ALL.ORDERED_BY_CONTACT_ID
%
SO_HEADERS_INTERFACE_ALL.INVOICE_TO_CONTACT_ID
%
SO_HEADERS_INTERFACE_ALL.SHIP_TO_CONTACT_ID
%
SO_HEADERS_INTERFACE_ALL.ACCOUNTING_RULE_ID
RA_RULES
SO_HEADERS_INTERFACE_ALL.CUSTOMER_ID
RA_CUSTOMERS
SO_HEADERS_INTERFACE_ALL.INVOICING_RULE_ID
RA_RULES
SO_HEADERS_INTERFACE_ALL.ORDER_TYPE
SO_ORDER_TYPES_115_ALL
SO_HEADERS_INTERFACE_ALL.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_HEADERS_INTERFACE_ALL.CURRENCY_CODE
FND_CURRENCIES
SO_HEADERS_INTERFACE_ALL.CUSTOMER_NUMBER
RA_CUSTOMERS
SO_HEADERS_INTERFACE_ALL.ENTERED_STATE_ID
SO_RESULTS_B
SO_HEADERS_INTERFACE_ALL.ORDER_SOURCE_ID
SO_ORDER_SOURCES_115
SO_HEADERS_INTERFACE_ALL.SALESREP_ID
RA_SALESREPS_ALL
SO_HEADERS_INTERFACE_ALL.INVOICE_CUSTOMER_ID
RA_CUSTOMERS
SO_HEADERS_INTERFACE_ALL.INVOICE_TO_SITE_USE_ID
RA_SITE_USES_ALL
SO_HEADERS_INTERFACE_ALL.INVOICE_ADDRESS_ID
RA_ADDRESSES_ALL
SO_HEADERS_INTERFACE_ALL.SHIP_TO_SITE_USE_ID
RA_SITE_USES_ALL
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_LINES_INTERFACE_ALL.ORIGINAL_SYSTEM_REFERENCE
SO_HEADERS_INTERFACE_ALL
SO_PRICE_ADJUSTMENTS_INTERFACE.ORIGINAL_SYSTEM_REFERENCE
SO_HEADERS_INTERFACE_ALL
SO_SALES_CREDITS_INTERFACE.ORIGINAL_SYSTEM_REFERENCE
SO_HEADERS_INTERFACE_ALL
[top of page]
OE.SO_HEADERS_INTERFACE_ALL does not reference any database object
OE.SO_HEADERS_INTERFACE_ALL is referenced by following:
APPS
SYNONYM - SO_HEADERS_INTERFACE_ALL
[top of page]
Table: SO_HEADER_ATTRIBUTES
Description: Additional attributes of order headers
Primary Key: SO_HEADER_ATTRIBUTES_PK
HEADER_ID
[top of page]
OE.SO_HEADER_ATTRIBUTES does not reference any database object
OE.SO_HEADER_ATTRIBUTES is referenced by following:
APPS
SYNONYM - SO_HEADER_ATTRIBUTES
[top of page]
Table: SO_HEADER_ATTRIBUTES_INTERFACE
Description: Additional attributes of imported order headers
Primary Key: SO_HEADER_ATTRIBUTE_INT_PK
ORIGINAL_SYSTEM_REFERENCE
[top of page]
OE.SO_HEADER_ATTRIBUTES_INTERFACE does not reference any database object
OE.SO_HEADER_ATTRIBUTES_INTERFACE is referenced by following:
APPS
SYNONYM - SO_HEADER_ATTRIBUTES_INTERFACE
[top of page]
Table: SO_HOLDS
Primary Key: SO_HOLDS_PK
HOLD_ID
Primary Key: SO_HOLDS_UK1
NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_HOLDS.ACTION_ID
SO_ACTIONS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_HOLD_AUTHORIZATIONS.HOLD_ID
SO_HOLDS
SO_HOLD_SOURCES_ALL.HOLD_ID
SO_HOLDS
[top of page]
OE.SO_HOLDS does not reference any database object
OE.SO_HOLDS is referenced by following:
APPS
SYNONYM - SO_HOLDS
[top of page]
Table: SO_HOLD_AUTHORIZATIONS
Description: Hold responsibility information
Primary Key: SO_HOLD_AUTHORIZATIONS_PK
HOLD_ID
RESPONSIBILITY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_HOLD_AUTHORIZATIONS.HOLD_ID
SO_HOLDS
SO_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID
SO_HOLD_AUTHORIZATIONS.APPLICATION_ID
FND_RESPONSIBILITY
[top of page]
OE.SO_HOLD_AUTHORIZATIONS does not reference any database object
OE.SO_HOLD_AUTHORIZATIONS is referenced by following:
APPS
SYNONYM - SO_HOLD_AUTHORIZATIONS
[top of page]
Table: SO_HOLD_RELEASES
Description: Hold release reasons
Primary Key: SO_HOLD_RELEASES_PK
HOLD_RELEASE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_HOLD_RELEASES.HOLD_SOURCE_ID
SO_HOLD_SOURCES_ALL
SO_HOLD_RELEASES.HOLD_ENTITY_ID
SO_HEADERS_ALL
SO_HOLD_RELEASES.HOLD_ENTITY_ID
RA_CUSTOMERS
SO_HOLD_RELEASES.HOLD_ENTITY_ID
RA_SITE_USES_ALL
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_ORDER_HOLDS_ALL.HOLD_RELEASE_ID
SO_HOLD_RELEASES
[top of page]
OE.SO_HOLD_RELEASES does not reference any database object
OE.SO_HOLD_RELEASES is referenced by following:
APPS
SYNONYM - SO_HOLD_RELEASES
[top of page]
Table: SO_HOLD_SOURCES_ALL
Description: Applied holds
Primary Key: SO_HOLD_SOURCS_PK
HOLD_SOURCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_HOLD_SOURCES_ALL.HOLD_ID
SO_HOLDS
SO_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
SO_HEADERS_ALL
SO_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
RA_CUSTOMERS
SO_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
RA_SITE_USES_ALL
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_HOLD_RELEASES.HOLD_SOURCE_ID
SO_HOLD_SOURCES_ALL
SO_ORDER_HOLDS_ALL.HOLD_SOURCE_ID
SO_HOLD_SOURCES_ALL
[top of page]
OE.SO_HOLD_SOURCES_ALL does not reference any database object
OE.SO_HOLD_SOURCES_ALL is referenced by following:
APPS
SYNONYM - SO_HOLD_SOURCES_ALL
[top of page]
Table: SO_ITEM_GROUPS
Description: Price list item groups
Primary Key: SO_ITEM_GROUPS_PK
GROUP_ID
Primary Key: SO_ITEM_GROUPS_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_ITEM_GROUP_LINES.GROUP_ID
SO_ITEM_GROUPS
SO_PICKING_BATCHES_ALL.GROUP_ID
SO_ITEM_GROUPS
SO_PICKING_RULES.GROUP_ID
SO_ITEM_GROUPS
SO_PRICE_COPY_PARAMETERS.GROUP_ID
SO_ITEM_GROUPS
[top of page]
OE.SO_ITEM_GROUPS does not reference any database object
OE.SO_ITEM_GROUPS is referenced by following:
APPS
SYNONYM - SO_ITEM_GROUPS
[top of page]
Table: SO_ITEM_GROUP_LINES
Description: Price list item group lines
Primary Key: SO_ITEM_GROUP_LINES_PK
GROUP_LINE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ITEM_GROUP_LINES.GROUP_ID
SO_ITEM_GROUPS
SO_ITEM_GROUP_LINES.PRICING_RULE_ID
SO_PRICING_RULES_B
[top of page]
OE.SO_ITEM_GROUP_LINES does not reference any database object
OE.SO_ITEM_GROUP_LINES is referenced by following:
APPS
SYNONYM - SO_ITEM_GROUP_LINES
[top of page]
Table: SO_LINES_ALL
Primary Key: SO_LINES_PK
LINE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_LINES_ALL.HEADER_ID
SO_HEADERS_ALL
SO_LINES_ALL.SHIP_TO_CONTACT_ID
%
SO_LINES_ALL.COMMITMENT_ID
RA_CUSTOMER_TRX_ALL
SO_LINES_ALL.CREDIT_INVOICE_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL
SO_LINES_ALL.PARENT_LINE_ID
SO_LINES_ALL
SO_LINES_ALL.COMPONENT_SEQUENCE_ID
BOM_INVENTORY_COMPONENTS
SO_LINES_ALL.ATO_LINE_ID
SO_LINES_ALL
SO_LINES_ALL.SHIPMENT_SCHEDULE_LINE_ID
SO_LINES_ALL
SO_LINES_ALL.CYCLE_ID
SO_CYCLES
SO_LINES_ALL.AGREEMENT_ID
SO_AGREEMENTS_B
SO_LINES_ALL.SERVICE_PARENT_LINE_ID
SO_LINES_ALL
SO_LINES_ALL.COMPONENT_SEQUENCE_ID
BOM_BILL_OF_MATERIALS
SO_LINES_ALL.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_LINES_ALL.TERMS_ID
RA_TERMS_B
SO_LINES_ALL.SHIP_TO_SITE_USE_ID
RA_SITE_USES_ALL
SO_LINES_ALL.LINK_TO_LINE_ID
SO_LINES_ALL
Foreign Keys to this table:
Foreign Key Column
Foreign Table
CST_MARGIN_TEMP.LINE_ID
SO_LINES_ALL
CST_MARGIN_TEMP.PARENT_LINE_ID
SO_LINES_ALL
CZ_ERRORS.LINE_ID
SO_LINES_ALL
SO_DROP_SHIP_SOURCES.LINE_ID
SO_LINES_ALL
SO_LINES_ALL.PARENT_LINE_ID
SO_LINES_ALL
SO_LINES_ALL.ATO_LINE_ID
SO_LINES_ALL
SO_LINES_ALL.SHIPMENT_SCHEDULE_LINE_ID
SO_LINES_ALL
SO_LINES_ALL.SERVICE_PARENT_LINE_ID
SO_LINES_ALL
SO_LINES_ALL.LINK_TO_LINE_ID
SO_LINES_ALL
SO_LINE_APPROVALS.LINE_ID
SO_LINES_ALL
SO_LINE_DETAILS.LINE_ID
SO_LINES_ALL
SO_NOTE_REFERENCES.LINE_ID
SO_LINES_ALL
SO_ORDER_CANCELLATIONS.LINE_ID
SO_LINES_ALL
SO_ORDER_HOLDS_ALL.LINE_ID
SO_LINES_ALL
SO_PICKING_CANCELLATIONS.LINE_ID
SO_LINES_ALL
SO_PICKING_LINES_ALL.ORDER_LINE_ID
SO_LINES_ALL
SO_PRICE_ADJUSTMENTS.LINE_ID
SO_LINES_ALL
SO_SALES_CREDITS.LINE_ID
SO_LINES_ALL
[top of page]
OE.SO_LINES_ALL does not reference any database object
OE.SO_LINES_ALL is referenced by following:
APPS
SYNONYM - SO_LINES_ALL
[top of page]
Table: SO_LINES_INTERFACE_ALL
Description: Imported order line information
Primary Key: SO_LINES_INTERFACE_PK
ORIGINAL_SYSTEM_REFERENCE
ORIGINAL_SYSTEM_LINE_REFERENCE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_LINES_INTERFACE_ALL.AGREEMENT_ID
SO_AGREEMENTS_B
SO_LINES_INTERFACE_ALL.ACCOUNTING_RULE_ID
RA_RULES
SO_LINES_INTERFACE_ALL.INVOICING_RULE_ID
RA_RULES
SO_LINES_INTERFACE_ALL.ORIGINAL_SYSTEM_REFERENCE
SO_HEADERS_INTERFACE_ALL
SO_LINES_INTERFACE_ALL.SHIP_TO_CONTACT_ID
%
SO_LINES_INTERFACE_ALL.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_LINES_INTERFACE_ALL.SHIP_TO_SITE_USE_ID
RA_SITE_USES_ALL
SO_LINES_INTERFACE_ALL.TERMS_ID
RA_TERMS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_LINE_DETAILS_INTERFACE.ORIGINAL_SYSTEM_REFERENCE
SO_LINE_DETAILS_INTERFACE.ORIGINAL_SYSTEM_LINE_REFERENCE
SO_LINES_INTERFACE_ALL
[top of page]
OE.SO_LINES_INTERFACE_ALL does not reference any database object
OE.SO_LINES_INTERFACE_ALL is referenced by following:
APPS
SYNONYM - SO_LINES_INTERFACE_ALL
[top of page]
Table: SO_LINE_APPROVALS
Description: Order line-level approvals
Primary Key: SO_LINE_APPROVALS_PK
LINE_APPROVAL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_LINE_APPROVALS.HEADER_ID
SO_HEADERS_ALL
SO_LINE_APPROVALS.LINE_ID
SO_LINES_ALL
SO_LINE_APPROVALS.APPROVER_ID
FND_USER
SO_LINE_APPROVALS.ACTION_ID
SO_ACTIONS
SO_LINE_APPROVALS.RESULT_ID
SO_RESULTS_B
[top of page]
OE.SO_LINE_APPROVALS does not reference any database object
OE.SO_LINE_APPROVALS is referenced by following:
APPS
SYNONYM - SO_LINE_APPROVALS
[top of page]
Table: SO_LINE_ATTRIBUTES
Description: Additional attributes of order lines
Primary Key: SO_LINE_ATTRIBUTES_PK
LINE_ID
[top of page]
OE.SO_LINE_ATTRIBUTES does not reference any database object
OE.SO_LINE_ATTRIBUTES is referenced by following:
APPS
SYNONYM - SO_LINE_ATTRIBUTES
[top of page]
Table: SO_LINE_ATTRIBUTES_INTERFACE
Description: Additional attributes of imported order line information
Primary Key: SO_LINE_ATTRIBUTES_INT_PK
ORIGINAL_SYSTEM_REFERENCE
ORDER_SOURCE_ID
ORIGINAL_SYSTEM_LINE_REFERENCE
[top of page]
OE.SO_LINE_ATTRIBUTES_INTERFACE does not reference any database object
OE.SO_LINE_ATTRIBUTES_INTERFACE is referenced by following:
APPS
SYNONYM - SO_LINE_ATTRIBUTES_INTERFACE
[top of page]
Table: SO_LINE_DETAILS
Description: Order line schedule details
Primary Key: SO_LINE_DETAILS_PK
LINE_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_LINE_DETAILS.LINE_ID
SO_LINES_ALL
SO_LINE_DETAILS.COMPONENT_SEQUENCE_ID
BOM_INVENTORY_COMPONENTS
SO_LINE_DETAILS.DELIVERY_ID
WSH_DELIVERIES
SO_LINE_DETAILS.COMPONENT_SEQUENCE_ID
BOM_BILL_OF_MATERIALS
SO_LINE_DETAILS.SO_LINE_DETAILS_DEPARTURE_ID
WSH_DEPARTURES
[top of page]
OE.SO_LINE_DETAILS does not reference any database object
OE.SO_LINE_DETAILS is referenced by following:
APPS
SYNONYM - SO_LINE_DETAILS
[top of page]
Table: SO_LINE_DETAILS_INTERFACE
Description: Imported order line schedule details
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_LINE_DETAILS_INTERFACE.ORIGINAL_SYSTEM_REFERENCE
SO_LINE_DETAILS_INTERFACE.ORIGINAL_SYSTEM_LINE_REFERENCE
SO_LINES_INTERFACE_ALL
[top of page]
OE.SO_LINE_DETAILS_INTERFACE does not reference any database object
OE.SO_LINE_DETAILS_INTERFACE is referenced by following:
APPS
SYNONYM - SO_LINE_DETAILS_INTERFACE
[top of page]
Table: SO_LINE_DETAIL_ATTRIBUTES
Description: Additional attributes of order line schedule details
Primary Key: SO_LINE_DETAIL_ATTRIBUTES_PK
LINE_DETAIL_ID
[top of page]
OE.SO_LINE_DETAIL_ATTRIBUTES does not reference any database object
OE.SO_LINE_DETAIL_ATTRIBUTES is referenced by following:
APPS
SYNONYM - SO_LINE_DETAIL_ATTRIBUTES
[top of page]
Table: SO_LINE_DETAIL_ATTRIBUTES_INT
Description: Additional attributes of imported order line schedule details
[top of page]
OE.SO_LINE_DETAIL_ATTRIBUTES_INT does not reference any database object
OE.SO_LINE_DETAIL_ATTRIBUTES_INT is referenced by following:
APPS
SYNONYM - SO_LINE_DETAIL_ATTRIBUTES_INT
[top of page]
Table: SO_LINE_SERVICE_DETAILS
Description: Installation details
Primary Key: SO_LINE_SERVICE_DETAILS_PK
LINE_SERVICE_DETAIL_ID
[top of page]
OE.SO_LINE_SERVICE_DETAILS does not reference any database object
OE.SO_LINE_SERVICE_DETAILS is referenced by following:
APPS
SYNONYM - SO_LINE_SERVICE_DETAILS
[top of page]
Table: SO_NOTES
Description: Order and line standard notes
Primary Key: SO_NOTES_PK
NOTE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_NOTES.USAGE_ID
SO_NOTE_USAGES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_NOTE_ADDITION_RULES.NOTE_ID
SO_NOTES
SO_NOTE_REFERENCES.NOTE_ID
SO_NOTES
[top of page]
OE.SO_NOTES does not reference any database object
OE.SO_NOTES is referenced by following:
APPS
SYNONYM - SO_NOTES
[top of page]
Table: SO_NOTE_ADDITION_RULES
Description: Note addition prerequisites
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_NOTE_ADDITION_RULES.ENTITY_ID
SO_ENTITIES
SO_NOTE_ADDITION_RULES.NOTE_ID
SO_NOTES
[top of page]
OE.SO_NOTE_ADDITION_RULES does not reference any database object
OE.SO_NOTE_ADDITION_RULES is referenced by following:
APPS
SYNONYM - SO_NOTE_ADDITION_RULES
[top of page]
Table: SO_NOTE_REFERENCES
Description: Notes attached to orders and order lines
Primary Key: SO_NOTE_REFERENCES_PK
NOTE_REFERENCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_NOTE_REFERENCES.NOTE_ID
SO_NOTES
SO_NOTE_REFERENCES.USAGE_ID
SO_NOTE_USAGES
SO_NOTE_REFERENCES.HEADER_ID
SO_HEADERS_ALL
SO_NOTE_REFERENCES.LINE_ID
SO_LINES_ALL
[top of page]
OE.SO_NOTE_REFERENCES does not reference any database object
OE.SO_NOTE_REFERENCES is referenced by following:
APPS
SYNONYM - SO_NOTE_REFERENCES
[top of page]
Table: SO_NOTE_REPLICATION
Description: Documents and attachments to replicate into Oracle Order Entry/Shipping
[top of page]
OE.SO_NOTE_REPLICATION does not reference any database object
OE.SO_NOTE_REPLICATION is referenced by following:
APPS
SYNONYM - SO_NOTE_REPLICATION
[top of page]
Table: SO_NOTE_USAGES
Primary Key: SO_NOTE_USAGES_PK
USAGE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_NOTES.USAGE_ID
SO_NOTE_USAGES
SO_NOTE_REFERENCES.USAGE_ID
SO_NOTE_USAGES
SO_NOTE_USAGE_ATTRIBUTES.USAGE_ID
SO_NOTE_USAGES
[top of page]
OE.SO_NOTE_USAGES does not reference any database object
OE.SO_NOTE_USAGES is referenced by following:
APPS
SYNONYM - SO_NOTE_USAGES
[top of page]
Table: SO_NOTE_USAGE_ATTRIBUTES
Description: Note printing parameters
Primary Key: SO_NOTE_USAGE_ATTRIBUTES_PK
USAGE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_NOTE_USAGE_ATTRIBUTES.USAGE_ID
SO_NOTE_USAGES
SO_NOTE_USAGE_ATTRIBUTES.REPORT_ID
SO_REPORTS
[top of page]
OE.SO_NOTE_USAGE_ATTRIBUTES does not reference any database object
OE.SO_NOTE_USAGE_ATTRIBUTES is referenced by following:
APPS
SYNONYM - SO_NOTE_USAGE_ATTRIBUTES
[top of page]
Table: SO_OBJECTS
Description: Objects used in security rules and standard value rule sets
Primary Key: SO_OBJECTS_PK
OBJECT_ID
Primary Key: SO_OBJECTS_UK1
OBJECT_CODE
Primary Key: SO_OBJECTS_UK2
NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_OBJECTS.TABLE_APPLICATION_ID
SO_OBJECTS.TABLE_NAME
FND_TABLES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_ATTRIBUTES.OBJECT_ID
SO_OBJECTS
SO_ATTRIBUTES.REPRESENTED_OBJECT_ID
SO_OBJECTS
SO_SECURITY_RULES.OBJECT_ID
SO_OBJECTS
[top of page]
OE.SO_OBJECTS does not reference any database object
OE.SO_OBJECTS is referenced by following:
APPS
SYNONYM - SO_OBJECTS
[top of page]
Table: SO_ORDER_APPROVALS
Description: Order-level approvals
Primary Key: SO_ORDER_APPROVALS_UK1
HEADER_ID
ORDER_APPROVAL_ID
Primary Key: SO_ORDER_APROVALS_PK
ORDER_APPROVAL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ORDER_APPROVALS.CUSTOMER_ID
RA_CUSTOMERS
SO_ORDER_APPROVALS.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_ORDER_APPROVALS.ACTION_ID
SO_ACTIONS
SO_ORDER_APPROVALS.RESULT_ID
SO_RESULTS_B
SO_ORDER_APPROVALS.HEADER_ID
SO_HEADERS_ALL
SO_ORDER_APPROVALS.APPROVER_ID
FND_USER
[top of page]
OE.SO_ORDER_APPROVALS does not reference any database object
OE.SO_ORDER_APPROVALS is referenced by following:
APPS
SYNONYM - SO_ORDER_APPROVALS
[top of page]
Table: SO_ORDER_CANCELLATIONS
Description: Order and order line cancellations
Primary Key: SO_ORDER_CANCELLATIONS_PK
HEADER_ID
LINE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ORDER_CANCELLATIONS.HEADER_ID
SO_HEADERS_ALL
SO_ORDER_CANCELLATIONS.LINE_ID
SO_LINES_ALL
SO_ORDER_CANCELLATIONS.CANCELLED_BY
FND_USER
[top of page]
OE.SO_ORDER_CANCELLATIONS does not reference any database object
OE.SO_ORDER_CANCELLATIONS is referenced by following:
APPS
SYNONYM - SO_ORDER_CANCELLATIONS
[top of page]
Table: SO_ORDER_HOLDS_ALL
Description: Order and order lines on hold
Primary Key: SO_ORDERS_HOLDS_PK
ORDER_HOLD_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_ORDER_HOLDS_ALL.HEADER_ID
SO_HEADERS_ALL
SO_ORDER_HOLDS_ALL.LINE_ID
SO_LINES_ALL
SO_ORDER_HOLDS_ALL.HOLD_SOURCE_ID
SO_HOLD_SOURCES_ALL
SO_ORDER_HOLDS_ALL.HOLD_RELEASE_ID
SO_HOLD_RELEASES
[top of page]
OE.SO_ORDER_HOLDS_ALL does not reference any database object
OE.SO_ORDER_HOLDS_ALL is referenced by following:
APPS
SYNONYM - SO_ORDER_HOLDS_ALL
[top of page]
Table: SO_ORDER_NUMBER_SOURCES
Description: Order numbering sources
Primary Key: SO_ORDER_NUMBER_SOURCES_PK
ORDER_NUMBER_SOURCE_ID
Primary Key: SO_ORDER_NUMBER_SOURCES_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_HEADERS_INTERFACE_ALL.ORDER_NUMBER_SOURCE_ID
SO_ORDER_NUMBER_SOURCES
SO_ORDER_NUMBER_SOURCES
[top of page]
OE.SO_ORDER_NUMBER_SOURCES does not reference any database object
OE.SO_ORDER_NUMBER_SOURCES is referenced by following:
APPS
SYNONYM - SO_ORDER_NUMBER_SOURCES
[top of page]
Table: SO_ORDER_SOURCES_115
Description: Feeder system names for use with OrderImport
Primary Key: SO_ORDER_SOURCES_115_PK
ORDER_SOURCE_ID
Primary Key: SO_ORDER_SOURCES_115_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
ICX_WEB_STORE_OPTIONS.ORDER_SOURCE_ID
SO_ORDER_SOURCES_115
SO_HEADERS_INTERFACE_ALL.ORDER_SOURCE_ID
SO_ORDER_SOURCES_115
[top of page]
OE.SO_ORDER_SOURCES_115 does not reference any database object
OE.SO_ORDER_SOURCES_115 is referenced by following:
APPS
SYNONYM - SO_ORDER_SOURCES_115
[top of page]
Table: SO_ORDER_TYPES_115_ALL
Primary Key: SO_ORDER_TYPES_ALL_115_PK
ORDER_TYPE_ID
Primary Key: SO_ORDER_TYPES_ALL_115_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
ICX_WEB_STORE_OPTIONS.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
RA_CUSTOMERS.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
RA_SITE_USES_ALL.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_HEADERS_ALL.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_HEADERS_INTERFACE_ALL.ORDER_TYPE
SO_ORDER_TYPES_115_ALL
SO_HEADERS_INTERFACE_ALL.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_ORDER_APPROVALS.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_PICKING_BATCHES_ALL.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_PICKING_RULES.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
[top of page]
OE.SO_ORDER_TYPES_115_ALL does not reference any database object
OE.SO_ORDER_TYPES_115_ALL is referenced by following:
APPS
SYNONYM - SO_ORDER_TYPES_115_ALL
[top of page]
Table: SO_PICKING_BATCHES_ALL
Description: Released order batches
Primary Key: SO_PICKING_BATCHES_PK
BATCH_ID
Primary Key: SO_PICKING_BATCHES_UK1
NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PICKING_BATCHES_ALL.DEPARTURE_ID
WSH_DEPARTURES
SO_PICKING_BATCHES_ALL.DELIVERY_ID
WSH_DELIVERIES
SO_PICKING_BATCHES_ALL.PICK_SLIP_RULE_ID
WSH_PICK_SLIP_RULES
SO_PICKING_BATCHES_ALL.RELEASE_SEQ_RULE_ID
WSH_RELEASE_SEQ_RULES
SO_PICKING_BATCHES_ALL.CUSTOMER_ID
RA_CUSTOMERS
SO_PICKING_BATCHES_ALL.HEADER_ID
SO_HEADERS_ALL
SO_PICKING_BATCHES_ALL.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_PICKING_BATCHES_ALL.SITE_USE_ID
RA_SITE_USES_ALL
SO_PICKING_BATCHES_ALL.GROUP_ID
SO_ITEM_GROUPS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_PICKING_HEADERS_ALL.BATCH_ID
SO_PICKING_BATCHES_ALL
[top of page]
OE.SO_PICKING_BATCHES_ALL does not reference any database object
OE.SO_PICKING_BATCHES_ALL is referenced by following:
APPS
SYNONYM - SO_PICKING_BATCHES_ALL
[top of page]
Table: SO_PICKING_CANCELLATIONS
Description: Cancelled picking lines
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PICKING_CANCELLATIONS.PICKING_LINE_ID
SO_PICKING_LINES_ALL
SO_PICKING_CANCELLATIONS.LINE_ID
SO_LINES_ALL
[top of page]
OE.SO_PICKING_CANCELLATIONS does not reference any database object
OE.SO_PICKING_CANCELLATIONS is referenced by following:
APPS
SYNONYM - SO_PICKING_CANCELLATIONS
[top of page]
Table: SO_PICKING_HEADERS_ALL
Description: Batch picking headers
Primary Key: SO_PICKING_HEADERS_PK
PICKING_HEADER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PICKING_HEADERS_ALL.BATCH_ID
SO_PICKING_BATCHES_ALL
SO_PICKING_HEADERS_ALL.ORDER_HEADER_ID
SO_HEADERS_ALL
SO_PICKING_HEADERS_ALL.SHIP_TO_SITE_USE_ID
RA_SITE_USES_ALL
SO_PICKING_HEADERS_ALL.PICKED_BY_ID
FND_USER
SO_PICKING_HEADERS_ALL.PACKED_BY_ID
FND_USER
SO_PICKING_HEADERS_ALL.DELIVERY_ID
WSH_DELIVERIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
JAI_OM_OE_BOND_TRXS.PICKING_HEADER_ID
SO_PICKING_HEADERS_ALL
JAI_OM_OE_GEN_TAXINV_T.PICKING_HEADER_ID
SO_PICKING_HEADERS_ALL
JAI_OM_WSH_LINES_ALL.PICKING_HEADER_ID
SO_PICKING_HEADERS_ALL
SO_FREIGHT_CHARGES.PICKING_HEADER_ID
SO_PICKING_HEADERS_ALL
SO_PICKING_LINES_ALL.PICKING_HEADER_ID
SO_PICKING_HEADERS_ALL
[top of page]
OE.SO_PICKING_HEADERS_ALL does not reference any database object
OE.SO_PICKING_HEADERS_ALL is referenced by following:
APPS
SYNONYM - SO_PICKING_HEADERS_ALL
[top of page]
Table: SO_PICKING_LINES_ALL
Description: Picking lines
Primary Key: SO_PICKING_LINES_PK
PICKING_LINE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PICKING_LINES_ALL.PICKING_HEADER_ID
SO_PICKING_HEADERS_ALL
SO_PICKING_LINES_ALL.ORDER_LINE_ID
SO_LINES_ALL
SO_PICKING_LINES_ALL.SHIP_TO_SITE_USE_ID
RA_SITE_USES_ALL
SO_PICKING_LINES_ALL.SHIP_TO_CONTACT_ID
%
Foreign Keys to this table:
Foreign Key Column
Foreign Table
JAI_OM_OE_BOND_TRXS.PICKING_LINE_ID
SO_PICKING_LINES_ALL
JAI_OM_OE_RMA_LINES.PICKING_LINE_ID
SO_PICKING_LINES_ALL
JAI_OM_REP_JAINEXFR_T.PICKING_LINE_ID
SO_PICKING_LINES_ALL
JAI_OM_WSH_LINES_ALL.PICKING_LINE_ID
SO_PICKING_LINES_ALL
JAI_OM_WSH_LINE_TAXES.PICKING_LINE_ID
SO_PICKING_LINES_ALL
SO_PICKING_CANCELLATIONS.PICKING_LINE_ID
SO_PICKING_LINES_ALL
SO_PICKING_LINE_DETAILS.PICKING_LINE_ID
SO_PICKING_LINES_ALL
[top of page]
OE.SO_PICKING_LINES_ALL does not reference any database object
OE.SO_PICKING_LINES_ALL is referenced by following:
APPS
SYNONYM - SO_PICKING_LINES_ALL
[top of page]
Table: SO_PICKING_LINE_DETAILS
Description: Picking line details
Primary Key: SO_PICKING_LINE_DETAILS_PK
PICKING_LINE_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PICKING_LINE_DETAILS.PICKING_LINE_ID
SO_PICKING_LINES_ALL
SO_PICKING_LINE_DETAILS.CONTAINER_ID
WSH_PACKED_CONTAINERS
SO_PICKING_LINE_DETAILS.DELIVERY_ID
WSH_DELIVERIES
SO_PICKING_LINE_DETAILS.DEPARTURE_ID
WSH_DEPARTURES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_FREIGHT_CHARGES.PICKING_LINE_DETAIL_ID
SO_PICKING_LINE_DETAILS
[top of page]
OE.SO_PICKING_LINE_DETAILS does not reference any database object
OE.SO_PICKING_LINE_DETAILS is referenced by following:
APPS
SYNONYM - SO_PICKING_LINE_DETAILS
[top of page]
Table: SO_PICKING_RULES
Description: Frequently used picking parameters (pick release rules)
Primary Key: SO_PICKING_RULES_PK
PICKING_RULE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PICKING_RULES.HEADER_ID
SO_HEADERS_ALL
SO_PICKING_RULES.RELEASE_SEQ_RULE_SET_ID
WSH_RELEASE_SEQ_RULES
SO_PICKING_RULES.ORDER_TYPE_ID
SO_ORDER_TYPES_115_ALL
SO_PICKING_RULES.CUSTOMER_ID
RA_CUSTOMERS
SO_PICKING_RULES.SITE_USE_ID
RA_SITE_USES_ALL
SO_PICKING_RULES.GROUP_ID
SO_ITEM_GROUPS
SO_PICKING_RULES.PICK_SLIP_RULE_ID
WSH_PICK_SLIP_RULES
[top of page]
OE.SO_PICKING_RULES does not reference any database object
OE.SO_PICKING_RULES is referenced by following:
APPS
SYNONYM - SO_PICKING_RULES
[top of page]
Table: SO_PRICE_ADJUSTMENTS
Description: Order and order line price adjustments
Primary Key: SO_PRICE_ADJUSTMENTS_PK
PRICE_ADJUSTMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PRICE_ADJUSTMENTS.HEADER_ID
SO_HEADERS_ALL
SO_PRICE_ADJUSTMENTS.DISCOUNT_ID
SO_DISCOUNTS
SO_PRICE_ADJUSTMENTS.LINE_ID
SO_LINES_ALL
SO_PRICE_ADJUSTMENTS.DISCOUNT_LINE_ID
SO_DISCOUNT_LINES_115
[top of page]
OE.SO_PRICE_ADJUSTMENTS does not reference any database object
OE.SO_PRICE_ADJUSTMENTS is referenced by following:
APPS
SYNONYM - SO_PRICE_ADJUSTMENTS
[top of page]
Table: SO_PRICE_ADJUSTMENTS_INTERFACE
Description: Imported price adjustments
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PRICE_ADJUSTMENTS_INTERFACE.DISCOUNT_ID
SO_DISCOUNTS
SO_PRICE_ADJUSTMENTS_INTERFACE.ORIGINAL_SYSTEM_REFERENCE
SO_HEADERS_INTERFACE_ALL
[top of page]
OE.SO_PRICE_ADJUSTMENTS_INTERFACE does not reference any database object
OE.SO_PRICE_ADJUSTMENTS_INTERFACE is referenced by following:
APPS
SYNONYM - SO_PRICE_ADJUSTMENTS_INTERFACE
[top of page]
Table: SO_PRICE_BREAK_LINES
Description: Discount line price breaks
Primary Key: SO_PRICE_BREAK_LINES_PK
PRICE_BREAK_LINES_LOW_RANGE
PRICE_BREAK_LINES_HIGH_RANGE
DISCOUNT_LINE_ID
METHOD_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PRICE_BREAK_LINES.DISCOUNT_LINE_ID
SO_DISCOUNT_LINES_115
[top of page]
OE.SO_PRICE_BREAK_LINES does not reference any database object
OE.SO_PRICE_BREAK_LINES is referenced by following:
APPS
SYNONYM - SO_PRICE_BREAK_LINES
[top of page]
Table: SO_PRICE_COPY_PARAMETERS
Description: Copy item groups parameters
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PRICE_COPY_PARAMETERS.GROUP_ID
SO_ITEM_GROUPS
[top of page]
OE.SO_PRICE_COPY_PARAMETERS does not reference any database object
OE.SO_PRICE_COPY_PARAMETERS is referenced by following:
APPS
SYNONYM - SO_PRICE_COPY_PARAMETERS
[top of page]
Table: SO_PRICE_LISTS_B
Primary Key: SO_PRICE_LISTS_B_PK
PRICE_LIST_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PRICE_LISTS_B.TERMS_ID
RA_TERMS_B
SO_PRICE_LISTS_B.SECONDARY_PRICE_LIST_ID
SO_PRICE_LISTS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_PRICE_LISTS_B
ICX_WEB_STORE_OPTIONS.PRICE_LIST_ID
SO_PRICE_LISTS_B
ICX_WEB_STORE_OPTIONS.GUEST_PRICE_LIST_ID
SO_PRICE_LISTS_B
RA_CUSTOMERS.PRICE_LIST_ID
SO_PRICE_LISTS_B
RA_SITE_USES_ALL.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_AGREEMENTS_B.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_DISCOUNTS.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_HEADERS_ALL.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_HEADERS_INTERFACE_ALL.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_LINES_ALL.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_LINES_INTERFACE_ALL.PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_PRICE_LISTS_B
SO_PRICE_LISTS_B.SECONDARY_PRICE_LIST_ID
SO_PRICE_LISTS_B
SO_PRICE_LIST_LINES_115.PRICE_LIST_ID
SO_PRICE_LISTS_B
[top of page]
OE.SO_PRICE_LISTS_B does not reference any database object
OE.SO_PRICE_LISTS_B is referenced by following:
APPS
SYNONYM - SO_PRICE_LISTS_B
[top of page]
Table: SO_PRICE_LISTS_TL
Description: Translation table for SO_PRICE_LISTS_B
Primary Key: SO_PRICE_LISTS_TL_PK
PRICE_LIST_ID
LANGUAGE
[top of page]
OE.SO_PRICE_LISTS_TL does not reference any database object
OE.SO_PRICE_LISTS_TL is referenced by following:
APPS
SYNONYM - SO_PRICE_LISTS_TL
[top of page]
Table: SO_PRICE_LIST_LINES_115
Description: Table to store Price List Lines.
Primary Key: SO_PRICE_LIST_LINES_115_PK
PRICE_LIST_LINE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PRICE_LIST_LINES_115.PRICING_RULE_ID
SO_PRICING_RULES_B
SO_PRICE_LIST_LINES_115.PRICE_LIST_ID
SO_PRICE_LISTS_B
[top of page]
OE.SO_PRICE_LIST_LINES_115 does not reference any database object
OE.SO_PRICE_LIST_LINES_115 is referenced by following:
APPS
SYNONYM - SO_PRICE_LIST_LINES_115
[top of page]
Table: SO_PRICING_RULES_B
Description: Price list and item group pricing rules
Primary Key: SO_PRICING_RULES_B_PK
PRICING_RULE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_ITEM_GROUP_LINES.PRICING_RULE_ID
SO_PRICING_RULES_B
SO_PRICE_LIST_LINES_115.PRICING_RULE_ID
SO_PRICING_RULES_B
SO_PRICING_RULE_LINES.PRICING_RULE_ID
SO_PRICING_RULES_B
[top of page]
OE.SO_PRICING_RULES_B does not reference any database object
OE.SO_PRICING_RULES_B is referenced by following:
APPS
SYNONYM - SO_PRICING_RULES_B
[top of page]
Table: SO_PRICING_RULES_TL
Description: Translation table for SO_PRICING_RULES_B
Primary Key: SO_PRICING_RULES_TL_PK
PRICING_RULE_ID
LANGUAGE
Primary Key: SO_PRICING_RULES_TL_UK1
NAME
LANGUAGE
[top of page]
OE.SO_PRICING_RULES_TL does not reference any database object
OE.SO_PRICING_RULES_TL is referenced by following:
APPS
SYNONYM - SO_PRICING_RULES_TL
[top of page]
Table: SO_PRICING_RULE_LINES
Description: Pricing rule details
Primary Key: SO_PRICING_RULE_LINES_PK
PRICING_RULE_ID
STEP_NUMBER
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PRICING_RULE_LINES.PRICING_RULE_ID
SO_PRICING_RULES_B
SO_PRICING_RULE_LINES.FORMULA_COMPONENT_ID
SO_RULE_FORMULA_COMPONENTS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_PRICING_RULE_LINE_VALUES.PRICING_RULE_ID
SO_PRICING_RULE_LINE_VALUES.STEP_NUMBER
SO_PRICING_RULE_LINES
[top of page]
OE.SO_PRICING_RULE_LINES does not reference any database object
OE.SO_PRICING_RULE_LINES is referenced by following:
APPS
SYNONYM - SO_PRICING_RULE_LINES
[top of page]
Table: SO_PRICING_RULE_LINE_VALUES
Description: Pricing rule column values
Primary Key: SO_PRICING_RULE_LINE_VALUES_PK
PRICING_RULE_ID
STEP_NUMBER
VALUE1
VALUE2
VALUE3
VALUE4
VALUE5
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_PRICING_RULE_LINE_VALUES.PRICING_RULE_ID
SO_PRICING_RULE_LINE_VALUES.STEP_NUMBER
SO_PRICING_RULE_LINES
[top of page]
OE.SO_PRICING_RULE_LINE_VALUES does not reference any database object
OE.SO_PRICING_RULE_LINE_VALUES is referenced by following:
APPS
SYNONYM - SO_PRICING_RULE_LINE_VALUES
[top of page]
Table: SO_PURGE_ORDERS
Description: Orders identified for purging
[top of page]
OE.SO_PURGE_ORDERS does not reference any database object
OE.SO_PURGE_ORDERS is referenced by following:
APPS
SYNONYM - SO_PURGE_ORDERS
[top of page]
Table: SO_REPORTS
Description: Oracle Order Entry/Shipping reports
Primary Key: SO_REPORTS_PK
REPORT_ID
Primary Key: SO_REPORTS_UK1
REPORT_APPLICATION_ID
NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_REPORTS.REPORT_APPLICATION_ID
SO_REPORTS.NAME
FND_CONCURRENT_PROGRAMS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_NOTE_USAGE_ATTRIBUTES.REPORT_ID
SO_REPORTS
SO_REPORT_PARAMETERS.REPORT_ID
SO_REPORTS
SO_REPORT_PRINTERS.REPORT_ID
SO_REPORTS
SO_REPORT_SET_LINES.REPORT_ID
SO_REPORTS
SO_REPORT_USAGES.REPORT_ID
SO_REPORTS
[top of page]
OE.SO_REPORTS does not reference any database object
OE.SO_REPORTS is referenced by following:
APPS
SYNONYM - SO_REPORTS
[top of page]
Table: SO_REPORT_PARAMETERS
Description: Report parameters
Primary Key: SO_REPORT_PARAMETERS_PK
REPORT_ID
PARAMETER_NUM
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_REPORT_PARAMETERS.REPORT_ID
SO_REPORTS
[top of page]
OE.SO_REPORT_PARAMETERS does not reference any database object
OE.SO_REPORT_PARAMETERS is referenced by following:
APPS
SYNONYM - SO_REPORT_PARAMETERS
[top of page]
Table: SO_REPORT_PRINTERS
Description: Report printer assignments
Primary Key: SO_REPORT_PRINTERS_PK
REPORT_ID
LEVEL_TYPE_ID
LEVEL_VALUE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_REPORT_PRINTERS.REPORT_ID
SO_REPORTS
SO_REPORT_PRINTERS.PRINTER_NAME
FND_PRINTER
[top of page]
OE.SO_REPORT_PRINTERS does not reference any database object
OE.SO_REPORT_PRINTERS is referenced by following:
APPS
SYNONYM - SO_REPORT_PRINTERS
[top of page]
Table: SO_REPORT_SETS
Description: Document sets to be printed from Ship Confirm Delivery and Ship Confirm Departure windows
Primary Key: SO_REPORT_SETS_PK
REPORT_SET_ID
Primary Key: SO_REPORT_SETS_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_REPORT_SET_LINES.REPORT_SET_ID
SO_REPORT_SETS
WSH_DELIVERIES.REPORT_SET_ID
SO_REPORT_SETS
WSH_DEPARTURES.REPORT_SET_ID
SO_REPORT_SETS
[top of page]
OE.SO_REPORT_SETS does not reference any database object
OE.SO_REPORT_SETS is referenced by following:
APPS
SYNONYM - SO_REPORT_SETS
[top of page]
Table: SO_REPORT_SET_LINES
Description: Document set lines
Primary Key: SO_REPORT_SET_LINES_PK
REPORT_SET_LINE_ID
Primary Key: SO_REPORT_SET_LINES_UK1
REPORT_SET_ID
REPORT_SEQUENCE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_REPORT_SET_LINES.REPORT_SET_ID
SO_REPORT_SETS
SO_REPORT_SET_LINES.REPORT_ID
SO_REPORTS
[top of page]
OE.SO_REPORT_SET_LINES does not reference any database object
OE.SO_REPORT_SET_LINES is referenced by following:
APPS
SYNONYM - SO_REPORT_SET_LINES
[top of page]
Table: SO_REPORT_SOURCE_PARAMETERS
Description: Document set source parameters
Primary Key: SO_REPORT_SOURCE_PARAMETERS_PK
SEQUENCE_NUM
USAGE_CODE
[top of page]
OE.SO_REPORT_SOURCE_PARAMETERS does not reference any database object
OE.SO_REPORT_SOURCE_PARAMETERS is referenced by following:
APPS
SYNONYM - SO_REPORT_SOURCE_PARAMETERS
[top of page]
Table: SO_REPORT_USAGES
Description: Document set usages
Primary Key: SO_REPORT_USAGES_PK
REPORT_USAGE_ID
Primary Key: SO_REPORT_USAGES_UK1
REPORT_ID
USAGE_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_REPORT_USAGES.REPORT_ID
SO_REPORTS
[top of page]
OE.SO_REPORT_USAGES does not reference any database object
OE.SO_REPORT_USAGES is referenced by following:
APPS
SYNONYM - SO_REPORT_USAGES
[top of page]
Table: SO_RESULTS_B
Description: Cycle action results for order cycles
Primary Key: SO_RESULTS_B_PK
RESULT_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_ACTIONS.PASSING_RESULT_ID
SO_RESULTS_B
SO_ACTION_PRE_REQS.RESULT_ID
SO_RESULTS_B
SO_ACTION_RESULTS.RESULT_ID
SO_RESULTS_B
SO_HEADERS_INTERFACE_ALL.ENTERED_STATE_ID
SO_RESULTS_B
SO_LINE_APPROVALS.RESULT_ID
SO_RESULTS_B
SO_ORDER_APPROVALS.RESULT_ID
SO_RESULTS_B
SO_SECURITY_RULES.RESULT_ID
SO_RESULTS_B
[top of page]
OE.SO_RESULTS_B does not reference any database object
OE.SO_RESULTS_B is referenced by following:
APPS
SYNONYM - SO_RESULTS_B
[top of page]
Table: SO_RESULTS_TL
Description: Translation table for SO_RESULTS_B
Primary Key: SO_RESULTS_TL_PK
RESULT_ID
LANGUAGE
[top of page]
OE.SO_RESULTS_TL does not reference any database object
OE.SO_RESULTS_TL is referenced by following:
APPS
SYNONYM - SO_RESULTS_TL
[top of page]
Table: SO_RULE_FORMULA_COMPONENTS
Description: Pricing components and associated pricing columns
Primary Key: SO_RULE_FORMULA_COMPONENTS_PK
FORMULA_COMPONENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_2
SO_ENTITIES
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_1
SO_ENTITIES
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_3
SO_ENTITIES
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_4
SO_ENTITIES
SO_RULE_FORMULA_COMPONENTS.ENTITY_ID_5
SO_ENTITIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_PRICING_RULE_LINES.FORMULA_COMPONENT_ID
SO_RULE_FORMULA_COMPONENTS
[top of page]
OE.SO_RULE_FORMULA_COMPONENTS does not reference any database object
OE.SO_RULE_FORMULA_COMPONENTS is referenced by following:
APPS
SYNONYM - SO_RULE_FORMULA_COMPONENTS
[top of page]
Table: SO_SALES_CREDITS
Description: Order and order line sales credits
Primary Key: SO_SALES_CREDITS_PK
SALES_CREDIT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_SALES_CREDITS.HEADER_ID
SO_HEADERS_ALL
SO_SALES_CREDITS.SALES_CREDIT_TYPE_ID
SO_SALES_CREDIT_TYPES_115
SO_SALES_CREDITS.SALESREP_ID
RA_SALESREPS_ALL
SO_SALES_CREDITS.LINE_ID
SO_LINES_ALL
[top of page]
OE.SO_SALES_CREDITS does not reference any database object
OE.SO_SALES_CREDITS is referenced by following:
APPS
SYNONYM - SO_SALES_CREDITS
[top of page]
Table: SO_SALES_CREDITS_INTERFACE
Description: Imported sales credit information
Primary Key: SO_SALES_CREDITS_INTERFACE_PK
ORDER_SOURCE_ID
ORIGINAL_SYSTEM_LINE_REFERENCE
ORIGINAL_SYSTEM_REFERENCE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_SALES_CREDITS_INTERFACE.SALESREP_ID
RA_SALESREPS_ALL
SO_SALES_CREDITS_INTERFACE.SALES_CREDIT_TYPE_ID
SO_SALES_CREDIT_TYPES_115
SO_SALES_CREDITS_INTERFACE.SALES_CREDIT_TYPE
SO_SALES_CREDIT_TYPES_115
SO_SALES_CREDITS_INTERFACE.ORIGINAL_SYSTEM_REFERENCE
SO_HEADERS_INTERFACE_ALL
[top of page]
OE.SO_SALES_CREDITS_INTERFACE does not reference any database object
OE.SO_SALES_CREDITS_INTERFACE is referenced by following:
APPS
SYNONYM - SO_SALES_CREDITS_INTERFACE
[top of page]
Table: SO_SALES_CREDIT_TYPES_115
Description: Sales credit types
Primary Key: SO_SALES_CREDIT_TYPES_115_PK
SALES_CREDIT_TYPE_ID
Primary Key: SO_SALES_CREDIT_TYPES_115_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
PA_IMPLEMENTATIONS_ALL.SALES_CREDIT_TYPE_CODE
SO_SALES_CREDIT_TYPES_115
RA_SALESREPS_ALL.SALES_CREDIT_TYPE_ID
SO_SALES_CREDIT_TYPES_115
SO_SALES_CREDITS.SALES_CREDIT_TYPE_ID
SO_SALES_CREDIT_TYPES_115
SO_SALES_CREDITS_INTERFACE.SALES_CREDIT_TYPE_ID
SO_SALES_CREDIT_TYPES_115
SO_SALES_CREDITS_INTERFACE.SALES_CREDIT_TYPE
SO_SALES_CREDIT_TYPES_115
[top of page]
OE.SO_SALES_CREDIT_TYPES_115 does not reference any database object
OE.SO_SALES_CREDIT_TYPES_115 is referenced by following:
APPS
SYNONYM - SO_SALES_CREDIT_TYPES_115
[top of page]
Table: SO_SECURITY_RULES
Description: Order security rules
Primary Key: SO_SECURITY_RULES_PK
SECURITY_RULE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_SECURITY_RULES.OBJECT_ID
SO_OBJECTS
SO_SECURITY_RULES.ATTRIBUTE_ID
SO_ATTRIBUTES
SO_SECURITY_RULES.ACTION_ID
SO_ACTIONS
SO_SECURITY_RULES.RESULT_ID
SO_RESULTS_B
[top of page]
OE.SO_SECURITY_RULES does not reference any database object
OE.SO_SECURITY_RULES is referenced by following:
APPS
SYNONYM - SO_SECURITY_RULES
[top of page]
Table: SO_SERVICE_DETAILS_INTERFACE
Description: Imported installation details for order lines
[top of page]
OE.SO_SERVICE_DETAILS_INTERFACE does not reference any database object
OE.SO_SERVICE_DETAILS_INTERFACE is referenced by following:
APPS
SYNONYM - SO_SERVICE_DETAILS_INTERFACE
[top of page]
Table: SO_STANDARD_VALUE_RULES
Description: Standard value rules
Primary Key: SO_STANDARD_VALUE_RULES_PK
STANDARD_VALUE_RULE_ID
Primary Key: SO_STANDARD_VALUE_RULES_UK1
ATTRIBUTE_ID
SEQUENCE_NUMBER
STANDARD_VALUE_RULE_SET_ID
Primary Key: SO_STANDARD_VALUE_RULES_UK2
ATTRIBUTE_ID
STANDARD_VALUE_RULE_SET_ID
STANDARD_VALUE_SOURCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
SO_STANDARD_VALUE_RULES.STANDARD_VALUE_RULE_SET_ID
SO_STANDARD_VALUE_RULE_SETS
SO_STANDARD_VALUE_RULES.ATTRIBUTE_ID
SO_ATTRIBUTES
[top of page]
OE.SO_STANDARD_VALUE_RULES does not reference any database object
OE.SO_STANDARD_VALUE_RULES is referenced by following:
APPS
SYNONYM - SO_STANDARD_VALUE_RULES
[top of page]
Table: SO_STANDARD_VALUE_RULE_SETS
Description: Standard value rule sets
Primary Key: SO_STANDARD_VALUE_RULE_SETS_PK
STANDARD_VALUE_RULE_SET_ID
Primary Key: SO_STD_VALUE_RULE_SETS_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_STANDARD_VALUE_RULE_SETS
SO_STANDARD_VALUE_RULES.STANDARD_VALUE_RULE_SET_ID
SO_STANDARD_VALUE_RULE_SETS
[top of page]
OE.SO_STANDARD_VALUE_RULE_SETS does not reference any database object
OE.SO_STANDARD_VALUE_RULE_SETS is referenced by following:
APPS
SYNONYM - SO_STANDARD_VALUE_RULE_SETS
[top of page]
Table: WSH_CONTAINER_LOAD
Description: Container load
Primary Key: WSH_CONTAINER_LOAD_PK
MASTER_ORGANIZATION_ID
CONTAINER_ITEM_ID
LOAD_ITEM_ID
[top of page]
OE.WSH_CONTAINER_LOAD does not reference any database object
OE.WSH_CONTAINER_LOAD is referenced by following:
APPS
SYNONYM - WSH_CONTAINER_LOAD
[top of page]
Table: WSH_DELIVERIES
Description: Shipping deliveries
Primary Key: WSH_DELIVERIES_PK
DELIVERY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WSH_DELIVERIES.PLANNED_DEPARTURE_ID
WSH_DEPARTURES
WSH_DELIVERIES.CUSTOMER_ID
RA_CUSTOMERS
WSH_DELIVERIES.ULTIMATE_SHIP_TO_ID
RA_SITE_USES_ALL
WSH_DELIVERIES.INTERMEDIATE_SHIP_TO_ID
RA_SITE_USES_ALL
WSH_DELIVERIES.REPORT_SET_ID
SO_REPORT_SETS
WSH_DELIVERIES.ACTUAL_DEPARTURE_ID
WSH_DEPARTURES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_FREIGHT_CHARGES.DELIVERY_ID
WSH_DELIVERIES
SO_LINE_DETAILS.DELIVERY_ID
WSH_DELIVERIES
SO_PICKING_BATCHES_ALL.DELIVERY_ID
WSH_DELIVERIES
SO_PICKING_HEADERS_ALL.DELIVERY_ID
WSH_DELIVERIES
SO_PICKING_LINE_DETAILS.DELIVERY_ID
WSH_DELIVERIES
WSH_INVOICE_NUMBERS.DELIVERY_ID
WSH_DELIVERIES
WSH_PACKED_CONTAINERS.DELIVERY_ID
WSH_DELIVERIES
[top of page]
OE.WSH_DELIVERIES does not reference any database object
OE.WSH_DELIVERIES is referenced by following:
APPS
SYNONYM - WSH_DELIVERIES
[top of page]
Table: WSH_DELIVERIES_INTERFACE
Description: Interface table containing deliveries
Primary Key: WSH_DELIVERIES_INT_PK
TRANSACTION_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WSH_FREIGHT_CHARGES_INTERFACE.TRANSACTION_ID
WSH_DELIVERIES_INTERFACE
WSH_PACKED_CONTAINER_INTERFACE.TRANSACTION_ID
WSH_DELIVERIES_INTERFACE
[top of page]
OE.WSH_DELIVERIES_INTERFACE does not reference any database object
OE.WSH_DELIVERIES_INTERFACE is referenced by following:
APPS
SYNONYM - WSH_DELIVERIES_INTERFACE
[top of page]
Table: WSH_DELIVERY_TEMPLATES
Description: Shipping Delivery Templates
Primary Key: WSH_DELIVERY_TEMPLATES_PK
DELIVERY_TEMPLATE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WSH_DELIVERY_TEMPLATES.PLANNED_DEP_TEMPLATE_ID
WSH_DEPARTURE_TEMPLATES
WSH_DELIVERY_TEMPLATES.CUSTOMER_ID
RA_CUSTOMERS
WSH_DELIVERY_TEMPLATES.ULTIMATE_SHIP_TO_ID
RA_SITE_USES_ALL
WSH_DELIVERY_TEMPLATES.INTERMEDIATE_SHIP_TO_ID
RA_SITE_USES_ALL
[top of page]
OE.WSH_DELIVERY_TEMPLATES does not reference any database object
OE.WSH_DELIVERY_TEMPLATES is referenced by following:
APPS
SYNONYM - WSH_DELIVERY_TEMPLATES
[top of page]
Table: WSH_DEPARTURES
Description: Shipping departures
Primary Key: WSH_DEPARTURES_PK
DEPARTURE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WSH_DEPARTURES.ARRIVE_AFTER_DEPARTURE_ID
WSH_DEPARTURES
WSH_DEPARTURES.REPORT_SET_ID
SO_REPORT_SETS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_LINE_DETAILS.SO_LINE_DETAILS_DEPARTURE_ID
WSH_DEPARTURES
SO_PICKING_BATCHES_ALL.DEPARTURE_ID
WSH_DEPARTURES
SO_PICKING_LINE_DETAILS.DEPARTURE_ID
WSH_DEPARTURES
WSH_DELIVERIES.PLANNED_DEPARTURE_ID
WSH_DEPARTURES
WSH_DELIVERIES.ACTUAL_DEPARTURE_ID
WSH_DEPARTURES
WSH_DEPARTURES.ARRIVE_AFTER_DEPARTURE_ID
WSH_DEPARTURES
[top of page]
OE.WSH_DEPARTURES does not reference any database object
OE.WSH_DEPARTURES is referenced by following:
APPS
SYNONYM - WSH_DEPARTURES
[top of page]
Table: WSH_DEPARTURE_TEMPLATES
Primary Key: WSH_DEPARTURE_TEMPLATES_PK
DEPARTURE_TEMPLATE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
WSH_DELIVERY_TEMPLATES.PLANNED_DEP_TEMPLATE_ID
WSH_DEPARTURE_TEMPLATES
[top of page]
OE.WSH_DEPARTURE_TEMPLATES does not reference any database object
OE.WSH_DEPARTURE_TEMPLATES is referenced by following:
APPS
SYNONYM - WSH_DEPARTURE_TEMPLATES
[top of page]
Table: WSH_FREIGHT_CHARGES_INTERFACE
Description: Interface table for freight charges
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WSH_FREIGHT_CHARGES_INTERFACE.TRANSACTION_ID
WSH_DELIVERIES_INTERFACE
[top of page]
OE.WSH_FREIGHT_CHARGES_INTERFACE does not reference any database object
OE.WSH_FREIGHT_CHARGES_INTERFACE is referenced by following:
APPS
SYNONYM - WSH_FREIGHT_CHARGES_INTERFACE
[top of page]
Table: WSH_INVOICE_NUMBERS
Description: Shipping invoice numbers
Primary Key: WSH_INVOICE_NUMBERS_PK
INVOICE_NUMBER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WSH_INVOICE_NUMBERS.DELIVERY_ID
WSH_DELIVERIES
[top of page]
OE.WSH_INVOICE_NUMBERS does not reference any database object
OE.WSH_INVOICE_NUMBERS is referenced by following:
APPS
SYNONYM - WSH_INVOICE_NUMBERS
[top of page]
Table: WSH_PACKED_CONTAINERS
Description: Packed containers
Primary Key: WSH_PACKED_CONTAINERS_PK
CONTAINER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WSH_PACKED_CONTAINERS.DELIVERY_ID
WSH_DELIVERIES
WSH_PACKED_CONTAINERS.CONTAINER_INVENTORY_ITEM_ID
WSH_PACKED_CONTAINERS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_FREIGHT_CHARGES.CONTAINER_ID
WSH_PACKED_CONTAINERS
SO_PICKING_LINE_DETAILS.CONTAINER_ID
WSH_PACKED_CONTAINERS
[top of page]
OE.WSH_PACKED_CONTAINERS does not reference any database object
OE.WSH_PACKED_CONTAINERS is referenced by following:
APPS
SYNONYM - WSH_PACKED_CONTAINERS
[top of page]
Table: WSH_PACKED_CONTAINER_INTERFACE
Description: Interface table for packed containers
Foreign Keys from this table:
Foreign Key Column
Foreign Table
WSH_PACKED_CONTAINER_INTERFACE.TRANSACTION_ID
WSH_DELIVERIES_INTERFACE
[top of page]
OE.WSH_PACKED_CONTAINER_INTERFACE does not reference any database object
OE.WSH_PACKED_CONTAINER_INTERFACE is referenced by following:
APPS
SYNONYM - WSH_PACKED_CONTAINER_INTERFACE
[top of page]
Table: WSH_PARAMETERS
Description: Shipping parameters
[top of page]
OE.WSH_PARAMETERS does not reference any database object
OE.WSH_PARAMETERS is referenced by following:
APPS
SYNONYM - WSH_PARAMETERS
[top of page]
Table: WSH_PICK_SLIP_RULES
Description: Pick slip rules
Primary Key: WSH_PICK_SLIP_RULES_PK
PICK_SLIP_RULE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_PICKING_BATCHES_ALL.PICK_SLIP_RULE_ID
WSH_PICK_SLIP_RULES
SO_PICKING_RULES.PICK_SLIP_RULE_ID
WSH_PICK_SLIP_RULES
[top of page]
OE.WSH_PICK_SLIP_RULES does not reference any database object
OE.WSH_PICK_SLIP_RULES is referenced by following:
APPS
SYNONYM - WSH_PICK_SLIP_RULES
[top of page]
Table: WSH_RELEASE_SEQ_RULES
Description: Release sequence rules
Primary Key: WSH_RELEASE_SEQ_RULES_PK
RELEASE_SEQ_RULE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
SO_PICKING_BATCHES_ALL.RELEASE_SEQ_RULE_ID
WSH_RELEASE_SEQ_RULES
SO_PICKING_RULES.RELEASE_SEQ_RULE_SET_ID
WSH_RELEASE_SEQ_RULES
[top of page]
OE.WSH_RELEASE_SEQ_RULES does not reference any database object
OE.WSH_RELEASE_SEQ_RULES is referenced by following:
APPS
SYNONYM - WSH_RELEASE_SEQ_RULES
[top of page]
Table: WSH_REPORT_TEMP
Description: Temporary table
[top of page]
OE.WSH_REPORT_TEMP does not reference any database object
OE.WSH_REPORT_TEMP is referenced by following:
APPS
SYNONYM - WSH_REPORT_TEMP
[top of page]
View: OEBV_CUSTOMER_AGREEMENTS
[top of page]
APPS.OEBV_CUSTOMER_AGREEMENTS references the following:
APPS
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - OE_AGREEMENTS_B
SYNONYM - OE_AGREEMENTS_TL
APPS.OEBV_CUSTOMER_AGREEMENTS is not referenced by any database object
[top of page]
View: OEBV_ORDER_CANCELLATIONS
[top of page]
APPS.OEBV_ORDER_CANCELLATIONS references the following:
APPS
SYNONYM - OE_ORDER_LINES_HISTORY
APPS.OEBV_ORDER_CANCELLATIONS is not referenced by any database object
[top of page]
View: OEBV_ORDER_HOLDS
[top of page]
APPS.OEBV_ORDER_HOLDS references the following:
APPS
SYNONYM - OE_ORDER_HOLDS_ALL
APPS.OEBV_ORDER_HOLDS is not referenced by any database object
[top of page]
View: OEBV_PRICE_ADJUSTMENTS
[top of page]
APPS.OEBV_PRICE_ADJUSTMENTS references the following:
APPS
SYNONYM - OE_PRICE_ADJUSTMENTS
APPS.OEBV_PRICE_ADJUSTMENTS is not referenced by any database object
[top of page]
View: OEBV_SALES_CREDIT_TYPES
[top of page]
APPS.OEBV_SALES_CREDIT_TYPES references the following:
APPS
SYNONYM - OE_SALES_CREDIT_TYPES
APPS.OEBV_SALES_CREDIT_TYPES is not referenced by any database object
[top of page]
View: OEBV_SALES_ORDER_TYPES
[top of page]
APPS.OEBV_SALES_ORDER_TYPES references the following:
APPS
SYNONYM - OE_TRANSACTION_TYPES_SYN
SYNONYM - OE_TRANSACTION_TYPES_TL
APPS.OEBV_SALES_ORDER_TYPES is not referenced by any database object
[top of page]
View: OEFV_CUSTOMER_AGREEMENTS
[top of page]
APPS.OEFV_CUSTOMER_AGREEMENTS references the following:
APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OE_AGREEMENTS_B
SYNONYM - OE_AGREEMENTS_TL
PACKAGE - OE_BIS_SALESPERSON
SYNONYM - QP_LIST_HEADERS_TL
SYNONYM - RA_RULES
SYNONYM - RA_TERMS_TL
APPS.OEFV_CUSTOMER_AGREEMENTS is not referenced by any database object
[top of page]
View: OEFV_ORDER_CANCELLATIONS
[top of page]
APPS.OEFV_ORDER_CANCELLATIONS references the following:
APPS
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_HISTORY
APPS.OEFV_ORDER_CANCELLATIONS is not referenced by any database object
[top of page]
View: OEFV_ORDER_HOLDS
[top of page]
APPS.OEFV_ORDER_HOLDS references the following:
APPS
SYNONYM - MTL_PARAMETERS
SYNONYM - OE_HOLD_RELEASES
SYNONYM - OE_HOLD_SOURCES_ALL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_HOLDS_ALL
APPS.OEFV_ORDER_HOLDS is not referenced by any database object
[top of page]
View: OEFV_PRICE_ADJUSTMENTS
[top of page]
APPS.OEFV_PRICE_ADJUSTMENTS references the following:
APPS
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_PRICE_ADJUSTMENTS
SYNONYM - QP_LIST_HEADERS_TL
APPS.OEFV_PRICE_ADJUSTMENTS is not referenced by any database object
[top of page]
View: OEFV_SALES_CREDIT_TYPES
[top of page]
APPS.OEFV_SALES_CREDIT_TYPES references the following:
APPS
SYNONYM - OE_SALES_CREDIT_TYPES
APPS.OEFV_SALES_CREDIT_TYPES is not referenced by any database object
[top of page]
View: OEFV_SALES_ORDER_TYPES
[top of page]
APPS.OEFV_SALES_ORDER_TYPES references the following:
APPS
SYNONYM - FND_CURRENCIES_TL
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - MTL_PARAMETERS
SYNONYM - OE_TRANSACTION_TYPES_ALL
SYNONYM - OE_TRANSACTION_TYPES_TL
SYNONYM - ORG_FREIGHT
SYNONYM - QP_LIST_HEADERS_TL
SYNONYM - RA_RULES
APPS.OEFV_SALES_ORDER_TYPES is not referenced by any database object
[top of page]
View: OE_BIS_BACKLOG_V
[top of page]
APPS.OE_BIS_BACKLOG_V references the following:
APPS
SYNONYM - CST_ITEM_COSTS
PACKAGE - FND_GLOBAL
VIEW - GL_SETS_OF_BOOKS
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - MTL_CATEGORIES
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
SYNONYM - MTL_ITEM_CATEGORIES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_UOM_CONVERSIONS
SYNONYM - SO_CYCLE_ACTIONS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
SYNONYM - SO_LOOKUPS
SYNONYM - SO_ORDER_TYPES_ALL
APPS.OE_BIS_BACKLOG_V is referenced by following:
APPS
PACKAGE BODY - OE_BIS
[top of page]
View: OE_BIS_BILLINGS_V
[top of page]
APPS.OE_BIS_BILLINGS_V references the following:
APPS
SYNONYM - CST_ITEM_COSTS
PACKAGE - FND_GLOBAL
VIEW - GL_SETS_OF_BOOKS
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - MTL_CATEGORIES
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
SYNONYM - MTL_ITEM_CATEGORIES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_UOM_CONVERSIONS
SYNONYM - SO_CYCLE_ACTIONS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
SYNONYM - SO_LOOKUPS
SYNONYM - SO_ORDER_TYPES_ALL
APPS.OE_BIS_BILLINGS_V is referenced by following:
APPS
PACKAGE BODY - OE_BIS
[top of page]
View: OE_BIS_BOOKINGS_V
[top of page]
APPS.OE_BIS_BOOKINGS_V references the following:
APPS
SYNONYM - CST_ITEM_COSTS
PACKAGE - FND_GLOBAL
VIEW - GL_SETS_OF_BOOKS
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - MTL_CATEGORIES
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
SYNONYM - MTL_ITEM_CATEGORIES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_UOM_CONVERSIONS
SYNONYM - SO_CYCLE_ACTIONS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
SYNONYM - SO_LOOKUPS
SYNONYM - SO_ORDER_TYPES_ALL
APPS.OE_BIS_BOOKINGS_V is referenced by following:
APPS
PACKAGE BODY - OE_BIS
[top of page]
View: OE_BIS_CANCELLED_BOOKINGS_V
[top of page]
APPS.OE_BIS_CANCELLED_BOOKINGS_V references the following:
APPS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
SYNONYM - SO_ORDER_CANCELLATIONS
APPS.OE_BIS_CANCELLED_BOOKINGS_V is referenced by following:
APPS
PACKAGE BODY - OE_BIS
[top of page]
View: OE_BIS_CUSTOMER_RETURNS_V
[top of page]
APPS.OE_BIS_CUSTOMER_RETURNS_V references the following:
APPS
SYNONYM - OE_BIS_TOP_CUSTOMERS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
APPS.OE_BIS_CUSTOMER_RETURNS_V is not referenced by any database object
[top of page]
View: OE_BIS_CUST_SAT_V
[top of page]
APPS.OE_BIS_CUST_SAT_V references the following:
APPS
SYNONYM - OE_BIS_CUST_SAT_T2
APPS.OE_BIS_CUST_SAT_V is referenced by following:
APPS
PACKAGE BODY - OE_BIS_ALERTS
[top of page]
View: SO_AGREEMENTS_VL
[top of page]
APPS.SO_AGREEMENTS_VL references the following:
APPS
SYNONYM - SO_AGREEMENTS_B
SYNONYM - SO_AGREEMENTS_TL
APPS.SO_AGREEMENTS_VL is not referenced by any database object
[top of page]
View: SO_CONFIG_COMPONENTS_V
[top of page]
APPS.SO_CONFIG_COMPONENTS_V references the following:
APPS
SYNONYM - BOM_EXPLOSIONS
VIEW - BOM_INVENTORY_COMPONENTS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - MTL_SYSTEM_ITEMS_VL
APPS.SO_CONFIG_COMPONENTS_V is referenced by following:
APPS
PACKAGE BODY - BOM_CONFIG_EXPLOSIONS_PKG
[top of page]
View: SO_CREDIT_CARDS_V
[top of page]
APPS.SO_CREDIT_CARDS_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_LOOKUPS
APPS.SO_CREDIT_CARDS_V is not referenced by any database object
[top of page]
View: SO_CURRENCIES_VAL_V
[top of page]
APPS.SO_CURRENCIES_VAL_V references the following:
APPS
VIEW - FND_CURRENCIES_VL
APPS.SO_CURRENCIES_VAL_V is not referenced by any database object
[top of page]
View: SO_CYCLE_ACTION_NAMES_V
[top of page]
APPS.SO_CYCLE_ACTION_NAMES_V references the following:
APPS
SYNONYM - SO_ACTIONS
SYNONYM - SO_CYCLE_ACTIONS
APPS.SO_CYCLE_ACTION_NAMES_V is not referenced by any database object
[top of page]
View: SO_DELIVERIES_V
[top of page]
APPS.SO_DELIVERIES_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - MTL_PARAMETERS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
SYNONYM - SO_LINE_DETAILS
SYNONYM - SO_LOOKUPS
SYNONYM - SO_PICKING_HEADERS_ALL
SYNONYM - SO_PICKING_LINES_ALL
SYNONYM - SO_PICKING_LINE_DETAILS
SYNONYM - WSH_DELIVERIES
SYNONYM - WSH_DEPARTURES
APPS.SO_DELIVERIES_V is not referenced by any database object
[top of page]
View: SO_DEMAND_CLASSES_ACTIVE_V
[top of page]
APPS.SO_DEMAND_CLASSES_ACTIVE_V references the following:
APPS
VIEW - FND_COMMON_LOOKUPS
PACKAGE - FND_GLOBAL
APPS.SO_DEMAND_CLASSES_ACTIVE_V is referenced by following:
APPS
PACKAGE BODY - WIP_FLOW_VALIDATION
PACKAGE BODY - WIP_JSI_VALIDATOR
PACKAGE BODY - WIP_VALIDATE
PACKAGE BODY - WIP_VALIDATEMLHEADER_PVT
[top of page]
View: SO_DROP_SHIP_LINKS_V
[top of page]
APPS.SO_DROP_SHIP_LINKS_V references the following:
APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMETERS
PACKAGE - FND_GLOBAL
VIEW - GL_SETS_OF_BOOKS
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - OE_DROP_SHIP_PVT
VIEW - PER_PEOPLE_F
SYNONYM - PO_HEADERS
SYNONYM - PO_LINES
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_RELEASES
SYNONYM - PO_REQUISITION_HEADERS
SYNONYM - PO_REQUISITION_LINES
VIEW - PO_VENDORS
SYNONYM - SO_DROP_SHIP_SOURCES
VIEW - SO_LINES
SYNONYM - SO_LOOKUPS
APPS.SO_DROP_SHIP_LINKS_V is not referenced by any database object
[top of page]
View: SO_ENTITIES_PARAMETERS_V
[top of page]
APPS.SO_ENTITIES_PARAMETERS_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_ENTITIES
SYNONYM - SO_LOOKUPS
APPS.SO_ENTITIES_PARAMETERS_V is not referenced by any database object
[top of page]
View: SO_ENTRY_STATUSES_ACTIVE_V
[top of page]
APPS.SO_ENTRY_STATUSES_ACTIVE_V references the following:
APPS
SYNONYM - SO_ACTIONS
SYNONYM - SO_ACTION_RESULTS
SYNONYM - SO_RESULTS
APPS.SO_ENTRY_STATUSES_ACTIVE_V is not referenced by any database object
[top of page]
View: SO_FC_ORDERS_V
[top of page]
APPS.SO_FC_ORDERS_V references the following:
APPS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
APPS.SO_FC_ORDERS_V is not referenced by any database object
[top of page]
View: SO_FC_RETURNS_V
[top of page]
APPS.SO_FC_RETURNS_V references the following:
APPS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
APPS.SO_FC_RETURNS_V is not referenced by any database object
[top of page]
View: SO_FOBS_ACTIVE_V
[top of page]
APPS.SO_FOBS_ACTIVE_V references the following:
APPS
VIEW - AR_LOOKUPS
APPS.SO_FOBS_ACTIVE_V is not referenced by any database object
[top of page]
View: SO_FREIGHT_CARRIERS_ACTIVE_V
[top of page]
APPS.SO_FREIGHT_CARRIERS_ACTIVE_V references the following:
APPS
SYNONYM - ORG_FREIGHT
APPS.SO_FREIGHT_CARRIERS_ACTIVE_V is not referenced by any database object
[top of page]
View: SO_FREIGHT_CHARGES_V
[top of page]
APPS.SO_FREIGHT_CHARGES_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_FREIGHT_CHARGES
SYNONYM - SO_FREIGHT_CHARGE_TYPES
SYNONYM - SO_LOOKUPS
APPS.SO_FREIGHT_CHARGES_V is not referenced by any database object
[top of page]
View: SO_FREIGHT_CHARGE_TYPES_V
[top of page]
APPS.SO_FREIGHT_CHARGE_TYPES_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_FREIGHT_CHARGE_TYPES
SYNONYM - SO_LOOKUPS
APPS.SO_FREIGHT_CHARGE_TYPES_V is not referenced by any database object
[top of page]
View: SO_FREIGHT_TERMS_ACTIVE_V
[top of page]
APPS.SO_FREIGHT_TERMS_ACTIVE_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_LOOKUPS
APPS.SO_FREIGHT_TERMS_ACTIVE_V is referenced by following:
APPS
VIEW - OE_PRICING_CONTRACTS_V
[top of page]
View: SO_HEADERS
[top of page]
APPS.SO_HEADERS references the following:
APPS
SYNONYM - SO_HEADERS_ALL
APPS.SO_HEADERS is referenced by following:
APPS
PACKAGE BODY - CS_CSXSVODS_CHECK_PKG
VIEW - ICX_EDM_CUSTOMER_TASK_V
VIEW - ICX_SO_LINES_VIEW_LINES_V
VIEW - ICX_SO_LINES_VIEW_RETURNS_V
PACKAGE BODY - OEP_CMERGE_OEORD
PACKAGE BODY - OEXPURGE
PACKAGE BODY - OE_CANCEL
PACKAGE BODY - OE_DEMAND_STREAM_PROCESSOR
PACKAGE BODY - OE_ORDER_IMPORT_INTEROP_PUB
PACKAGE BODY - OE_QUERY
PACKAGE BODY - SHPLEFT
PACKAGE BODY - SO_ATT
VIEW - SO_LINES_CURRENT_DEMAND_V
VIEW - SO_LINES_RETURN_LINES_V
VIEW - SO_LINES_RMA_V
VIEW - SO_LINES_VIEW_RETURNS_V
VIEW - SO_LINE_SALES_CREDITS
VIEW - SO_ORDER_CANCELLATIONS_V
VIEW - SO_ORDER_HEADER_STATUS
VIEW - SO_ORDER_STATUS_V
PACKAGE BODY - SO_PRICE_LIST_LINES_PKG
PACKAGE BODY - WSH_DEL_OI_CORE
[top of page]
View: SO_HEADERS_INTERFACE
[top of page]
APPS.SO_HEADERS_INTERFACE references the following:
APPS
SYNONYM - SO_HEADERS_INTERFACE_ALL
APPS.SO_HEADERS_INTERFACE is referenced by following:
APPS
PACKAGE BODY - OE_DEMAND_STREAM_PROCESSOR
[top of page]
View: SO_HEADERS_IOP_115_V
[top of page]
APPS.SO_HEADERS_IOP_115_V references the following:
APPS
SYNONYM - SO_HEADERS_ALL
APPS.SO_HEADERS_IOP_115_V is not referenced by any database object
[top of page]
View: SO_HOLD_SOURCES
[top of page]
APPS.SO_HOLD_SOURCES references the following:
APPS
SYNONYM - SO_HOLD_SOURCES_ALL
APPS.SO_HOLD_SOURCES is referenced by following:
APPS
PACKAGE BODY - OEP_CMERGE_OEHLD
PACKAGE BODY - OEXPURGE
PACKAGE BODY - OE_CANSRV
VIEW - SO_ORDER_HOLDS_VIEW_HOLD_V
[top of page]
View: SO_INCLUDED_ITEMS_OEXORRSO_V
[top of page]
APPS.SO_INCLUDED_ITEMS_OEXORRSO_V references the following:
APPS
SYNONYM - BOM_CONFIG_EXPLOSIONS
VIEW - BOM_INVENTORY_COMPONENTS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
VIEW - MTL_SYSTEM_ITEMS_VL
PACKAGE - OE_QUERY
SYNONYM - SO_LOOKUPS
APPS.SO_INCLUDED_ITEMS_OEXORRSO_V is not referenced by any database object
[top of page]
View: SO_INVOICING_RULES_V
[top of page]
APPS.SO_INVOICING_RULES_V references the following:
APPS
SYNONYM - RA_RULES
APPS.SO_INVOICING_RULES_V is not referenced by any database object
[top of page]
View: SO_ITEM_GROUP_LINES_ALL_V
[top of page]
APPS.SO_ITEM_GROUP_LINES_ALL_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - SO_ITEM_GROUP_LINES
SYNONYM - SO_PRICING_RULES
APPS.SO_ITEM_GROUP_LINES_ALL_V is not referenced by any database object
[top of page]
View: SO_ITEM_WAREHOUSES_V
[top of page]
APPS.SO_ITEM_WAREHOUSES_V references the following:
APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
APPS.SO_ITEM_WAREHOUSES_V is referenced by following:
APPS
PACKAGE BODY - OE_RMA_QUERY_RECEIVE
[top of page]
View: SO_LINES
[top of page]
APPS.SO_LINES references the following:
APPS
SYNONYM - SO_LINES_ALL
APPS.SO_LINES is referenced by following:
APPS
PACKAGE BODY - CS_CSXSVODS_CHECK_PKG
VIEW - ICX_EDM_CUSTOMER_TASK_V
VIEW - ICX_ENG_WEB_SCHEDULE_SO_V
VIEW - ICX_SO_LINES_VIEW_LINES_V
VIEW - ICX_SO_LINES_VIEW_RETURNS_V
PACKAGE BODY - OEP_CMERGE_OEORD
PACKAGE BODY - OEXPURGE
PACKAGE BODY - OEXVWCAN
PACKAGE BODY - OEXVWLIN
PACKAGE BODY - OE_ACCOUNTING
PACKAGE BODY - OE_CANCEL
PACKAGE BODY - OE_CANSRV
PACKAGE BODY - OE_DEMAND_STREAM_PROCESSOR
PACKAGE BODY - OE_LIN
PACKAGE BODY - OE_LINE_DETAILS_PKG
PACKAGE BODY - OE_LINE_UTILITY
PACKAGE BODY - OE_LIN_SCH
PACKAGE BODY - OE_OPT_PROCESS
PACKAGE BODY - OE_ORDER_IMPORT_INTEROP_PUB
PACKAGE BODY - OE_PAYMENTS_UTIL
PACKAGE BODY - OE_QUERY
PACKAGE BODY - OE_RMA_LINE_VALIDATE
PACKAGE BODY - OE_RMA_QUERY_PRICE
PACKAGE BODY - OE_RMA_TOTAL
PACKAGE BODY - OE_SERVICES_PROCESS
PACKAGE BODY - OE_SHP_PROCESS
PACKAGE BODY - OE_SO_ATO
PACKAGE BODY - OE_SO_LIN_VALIDATE
PACKAGE BODY - QA_PLAN_ELEMENT_API
PACKAGE BODY - SHPBKLOG
PACKAGE BODY - SHPLEFT
VIEW - SO_DROP_SHIP_LINKS_V
VIEW - SO_LINES_CANCEL_V
VIEW - SO_LINES_CURRENT_DEMAND_V
VIEW - SO_LINES_RETURN_LINES_V
VIEW - SO_LINES_RMA_V
VIEW - SO_LINES_SUMMARY_V
VIEW - SO_LINES_VIEW_RETURNS_V
VIEW - SO_LINE_SALES_CREDITS
VIEW - SO_MFG_STATUS_VIEW
VIEW - SO_MODEL_LINE_COGS_ACCOUNT
VIEW - SO_OPEN_ORDER_INVOICE_REFS_V
VIEW - SO_ORDER_CANCELLATIONS_V
VIEW - SO_ORDER_LINE_STATUS
VIEW - SO_ORDER_STATUS_V
PACKAGE BODY - SO_PRICE_LIST_LINES_PKG
VIEW - SO_SCHEDULE_DETAILS
VIEW - SO_SERVICE_DETAILS
PACKAGE BODY - WSH_FLEX_PKG_COGS
[top of page]
View: SO_LINES_CANCEL_V
[top of page]
APPS.SO_LINES_CANCEL_V references the following:
APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - MTL_SYSTEM_ITEMS_VL
PACKAGE - OEXVWCAN
VIEW - SO_LINES
SYNONYM - SO_LOOKUPS
APPS.SO_LINES_CANCEL_V is referenced by following:
APPS
PACKAGE BODY - OE_CANSRV
[top of page]
View: SO_LINES_CURRENT_DEMAND_V
[top of page]
APPS.SO_LINES_CURRENT_DEMAND_V references the following:
APPS
PACKAGE - OE_QUERY
VIEW - SO_HEADERS
VIEW - SO_LINES
SYNONYM - SO_ORDER_TYPES
APPS.SO_LINES_CURRENT_DEMAND_V is not referenced by any database object
[top of page]
View: SO_LINES_INTERFACE
[top of page]
APPS.SO_LINES_INTERFACE references the following:
APPS
SYNONYM - SO_LINES_INTERFACE_ALL
APPS.SO_LINES_INTERFACE is referenced by following:
APPS
PACKAGE BODY - CS_CSXSVODS_CHECK_PKG
PACKAGE BODY - OE_DEMAND_STREAM_PROCESSOR
[top of page]
View: SO_LINES_RETURN_LINES_V
[top of page]
APPS.SO_LINES_RETURN_LINES_V references the following:
APPS
VIEW - AR_LOOKUPS
SYNONYM - MTL_UNITS_OF_MEASURE
PACKAGE - OE_QUERY
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
VIEW - SO_HEADERS
VIEW - SO_LINES
APPS.SO_LINES_RETURN_LINES_V is not referenced by any database object
[top of page]
View: SO_LINES_RMA_V
[top of page]
APPS.SO_LINES_RMA_V references the following:
APPS
VIEW - AR_LOOKUPS
SYNONYM - AR_VAT_TAX
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - MTL_PARAMETERS
VIEW - MTL_SYSTEM_ITEMS_VL
PACKAGE - OE_QUERY
PACKAGE - QP_PRICE_LIST_PVT
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
VIEW - SO_HEADERS
VIEW - SO_LINES
SYNONYM - SO_LOOKUPS
SYNONYM - SO_PRICE_LISTS
APPS.SO_LINES_RMA_V is not referenced by any database object
[top of page]
View: SO_LINES_SUMMARY_V
[top of page]
APPS.SO_LINES_SUMMARY_V references the following:
APPS
VIEW - MTL_ITEM_FLEXFIELDS
SYNONYM - MTL_UNITS_OF_MEASURE
VIEW - SO_LINES
APPS.SO_LINES_SUMMARY_V is not referenced by any database object
[top of page]
View: SO_LINES_VIEW_RETURNS_V
[top of page]
APPS.SO_LINES_VIEW_RETURNS_V references the following:
APPS
VIEW - AR_LOOKUPS
PACKAGE - FND_PROFILE
SYNONYM - MTL_PARAMETERS
VIEW - MTL_SYSTEM_ITEMS_VL
SYNONYM - MTL_UNITS_OF_MEASURE
PACKAGE - OE_QUERY
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
VIEW - SO_HEADERS
VIEW - SO_LINES
APPS.SO_LINES_VIEW_RETURNS_V is not referenced by any database object
[top of page]
View: SO_LINE_DETAILS_V
[top of page]
APPS.SO_LINE_DETAILS_V references the following:
APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - MTL_SYSTEM_ITEMS_VL
SYNONYM - SO_LINE_DETAILS
SYNONYM - SO_LOOKUPS
APPS.SO_LINE_DETAILS_V is not referenced by any database object
[top of page]
View: SO_LINE_DETAILS_VIEW_WIP_V
[top of page]
APPS.SO_LINE_DETAILS_VIEW_WIP_V references the following:
APPS
PACKAGE - FND_PROFILE
VIEW - MTL_SYSTEM_ITEMS_VL
SYNONYM - MTL_UNITS_OF_MEASURE
PACKAGE - OE_QUERY
SYNONYM - SO_LINE_DETAILS
SYNONYM - WIP_ENTITIES
APPS.SO_LINE_DETAILS_VIEW_WIP_V is not referenced by any database object
[top of page]
View: SO_LINE_SALES_CREDITS
[top of page]
APPS.SO_LINE_SALES_CREDITS references the following:
APPS
VIEW - SO_HEADERS
VIEW - SO_LINES
SYNONYM - SO_SALES_CREDITS
SYNONYM - SO_SALES_CREDIT_TYPES
SYNONYM - SO_SALES_CREDIT_TYPES_115
APPS.SO_LINE_SALES_CREDITS is referenced by following:
APPS
PACKAGE BODY - WSH_FLEX_PKG_COGS
[top of page]
View: SO_LOOKUPS_115
[top of page]
APPS.SO_LOOKUPS_115 references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
APPS.SO_LOOKUPS_115 is not referenced by any database object
[top of page]
View: SO_MANUAL_DISCOUNTS_V
[top of page]
APPS.SO_MANUAL_DISCOUNTS_V references the following:
APPS
PACKAGE - QP_PRICE_LIST_PVT
PACKAGE - QP_VIEW_UTIL
SYNONYM - SO_DISCOUNTS
SYNONYM - SO_DISCOUNT_LINES
SYNONYM - SO_PRICE_BREAK_LINES
SYNONYM - SO_PRICE_LISTS
APPS.SO_MANUAL_DISCOUNTS_V is not referenced by any database object
[top of page]
View: SO_MFG_STATUS_VIEW
[top of page]
APPS.SO_MFG_STATUS_VIEW references the following:
APPS
VIEW - SO_LINES
SYNONYM - SO_LINE_DETAILS
APPS.SO_MFG_STATUS_VIEW is not referenced by any database object
[top of page]
View: SO_MODEL_LINE_COGS_ACCOUNT
[top of page]
APPS.SO_MODEL_LINE_COGS_ACCOUNT references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS_B
VIEW - SO_LINES
SYNONYM - SO_LINE_DETAILS
APPS.SO_MODEL_LINE_COGS_ACCOUNT is referenced by following:
APPS
PACKAGE BODY - WSH_FLEX_PKG_COGS
[top of page]
View: SO_MTL_DEMAND_INT_DELIVERY
[top of page]
APPS.SO_MTL_DEMAND_INT_DELIVERY references the following:
APPS
SYNONYM - MTL_DEMAND_INTERFACE
PACKAGE - OE_QUERY
APPS.SO_MTL_DEMAND_INT_DELIVERY is not referenced by any database object
[top of page]
View: SO_MTL_DEMAND_INT_LINE_ID
[top of page]
APPS.SO_MTL_DEMAND_INT_LINE_ID references the following:
APPS
SYNONYM - MTL_DEMAND_INTERFACE
PACKAGE - OE_QUERY
APPS.SO_MTL_DEMAND_INT_LINE_ID is not referenced by any database object
[top of page]
View: SO_NOTE_USAGE_ATTR_V
[top of page]
APPS.SO_NOTE_USAGE_ATTR_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_LOOKUPS
SYNONYM - SO_NOTE_USAGE_ATTRIBUTES
SYNONYM - SO_REPORTS
APPS.SO_NOTE_USAGE_ATTR_V is not referenced by any database object
[top of page]
View: SO_OPEN_ORDER_INVOICE_REFS_V
[top of page]
APPS.SO_OPEN_ORDER_INVOICE_REFS_V references the following:
APPS
SYNONYM - RA_CUSTOMER_TRX_LINES
VIEW - SO_LINES
APPS.SO_OPEN_ORDER_INVOICE_REFS_V is not referenced by any database object
[top of page]
View: SO_ORDER_CANCELLATIONS_V
[top of page]
APPS.SO_ORDER_CANCELLATIONS_V references the following:
APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - MTL_SYSTEM_ITEMS_KFV
PACKAGE - OEXVWCAN
VIEW - SO_HEADERS
VIEW - SO_LINES
SYNONYM - SO_LOOKUPS
SYNONYM - SO_ORDER_CANCELLATIONS
SYNONYM - SO_ORDER_TYPES
APPS.SO_ORDER_CANCELLATIONS_V is not referenced by any database object
[top of page]
View: SO_ORDER_HEADER_STATUS
[top of page]
APPS.SO_ORDER_HEADER_STATUS references the following:
APPS
SYNONYM - SO_ACTIONS
VIEW - SO_HEADERS
SYNONYM - SO_RESULTS
APPS.SO_ORDER_HEADER_STATUS is not referenced by any database object
[top of page]
View: SO_ORDER_HOLDS_115
[top of page]
APPS.SO_ORDER_HOLDS_115 references the following:
APPS
SYNONYM - SO_ORDER_HOLDS_ALL
APPS.SO_ORDER_HOLDS_115 is not referenced by any database object
[top of page]
View: SO_ORDER_HOLDS_VIEW_HOLD_V
[top of page]
APPS.SO_ORDER_HOLDS_VIEW_HOLD_V references the following:
APPS
SYNONYM - FND_USER
SYNONYM - SO_ACTIONS
SYNONYM - SO_ENTITIES
SYNONYM - SO_HOLDS
SYNONYM - SO_HOLD_RELEASES
VIEW - SO_HOLD_SOURCES
SYNONYM - SO_ORDER_HOLDS
APPS.SO_ORDER_HOLDS_VIEW_HOLD_V is not referenced by any database object
[top of page]
View: SO_ORDER_LINE_STATUS
[top of page]
APPS.SO_ORDER_LINE_STATUS references the following:
APPS
SYNONYM - SO_ACTIONS
VIEW - SO_LINES
SYNONYM - SO_RESULTS
APPS.SO_ORDER_LINE_STATUS is not referenced by any database object
[top of page]
View: SO_ORDER_STATUS_V
[top of page]
APPS.SO_ORDER_STATUS_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_ACTIONS
VIEW - SO_HEADERS
VIEW - SO_LINES
SYNONYM - SO_LOOKUPS
SYNONYM - SO_RESULTS
APPS.SO_ORDER_STATUS_V is not referenced by any database object
[top of page]
View: SO_ORDER_TYPES_115
[top of page]
APPS.SO_ORDER_TYPES_115 references the following:
APPS
SYNONYM - SO_ORDER_TYPES_115_ALL
APPS.SO_ORDER_TYPES_115 is not referenced by any database object
[top of page]
View: SO_ORDER_TYPES_REGULAR_V
[top of page]
APPS.SO_ORDER_TYPES_REGULAR_V references the following:
APPS
SYNONYM - SO_ORDER_TYPES
APPS.SO_ORDER_TYPES_REGULAR_V is not referenced by any database object
[top of page]
View: SO_PAYMENT_TERMS_V
[top of page]
APPS.SO_PAYMENT_TERMS_V references the following:
APPS
SYNONYM - RA_TERMS
APPS.SO_PAYMENT_TERMS_V is not referenced by any database object
[top of page]
View: SO_PAYMENT_TYPES_V
[top of page]
APPS.SO_PAYMENT_TYPES_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_LOOKUPS
APPS.SO_PAYMENT_TYPES_V is not referenced by any database object
[top of page]
View: SO_PICKING_BATCHES
[top of page]
APPS.SO_PICKING_BATCHES references the following:
APPS
SYNONYM - SO_PICKING_BATCHES_ALL
APPS.SO_PICKING_BATCHES is referenced by following:
APPS
PACKAGE BODY - OEP_CMERGE_OEPIC
PACKAGE BODY - OEXPURGE
PACKAGE BODY - SHP_PICKING_BATCHES_PKG
[top of page]
View: SO_PICKING_HEADERS
[top of page]
APPS.SO_PICKING_HEADERS references the following:
APPS
SYNONYM - SO_PICKING_HEADERS_ALL
APPS.SO_PICKING_HEADERS is referenced by following:
APPS
PACKAGE BODY - OEP_CMERGE_OEPIC
PACKAGE BODY - OEXPURGE
PACKAGE BODY - OEXVWCAN
PACKAGE BODY - OE_CANCEL
PACKAGE BODY - SHPBKLOG
PACKAGE BODY - SHPLEFT
VIEW - SO_PICKING_LINE_DETAILS_V
PACKAGE BODY - WSH_PICKING_HEADER_PVT
[top of page]
View: SO_PICKING_LINES
[top of page]
APPS.SO_PICKING_LINES references the following:
APPS
SYNONYM - SO_PICKING_LINES_ALL
APPS.SO_PICKING_LINES is referenced by following:
APPS
PACKAGE BODY - OEP_CMERGE_OEPIC
PACKAGE BODY - OEXPURGE
PACKAGE BODY - OEXVWCAN
PACKAGE BODY - OE_CANCEL
PACKAGE BODY - OE_DEMAND_STREAM_PROCESSOR
PACKAGE BODY - OE_QUERY
PACKAGE BODY - OE_SO_PLN_SERVER
PACKAGE BODY - SHPBKLOG
PACKAGE BODY - SHPLEFT
VIEW - SO_PICKING_LINE_DETAILS_V
VIEW - SO_PICKING_LINE_DETAIL_VO_V
VIEW - SO_SCHEDULE_DETAILS
PACKAGE BODY - WSH_FLEX_PKG_COGS
PACKAGE BODY - WSH_PICKING_HEADER_PVT
[top of page]
View: SO_PICKING_LINES_V
[top of page]
APPS.SO_PICKING_LINES_V references the following:
APPS
SYNONYM - MTL_PARAMETERS
VIEW - MTL_SYSTEM_ITEMS_VL
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_PICKING_HEADERS_ALL
SYNONYM - SO_PICKING_LINES_ALL
APPS.SO_PICKING_LINES_V is not referenced by any database object
[top of page]
View: SO_PICKING_LINE_DETAILS_V
[top of page]
APPS.SO_PICKING_LINE_DETAILS_V references the following:
APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - MTL_SYSTEM_ITEMS_VL
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - SO_HEADERS_ALL
VIEW - SO_PICKING_HEADERS
VIEW - SO_PICKING_LINES
SYNONYM - SO_PICKING_LINE_DETAILS
APPS.SO_PICKING_LINE_DETAILS_V is not referenced by any database object
[top of page]
View: SO_PICKING_LINE_DETAIL_VO_V
[top of page]
APPS.SO_PICKING_LINE_DETAIL_VO_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - MTL_PARAMETERS
VIEW - MTL_SYSTEM_ITEMS_VL
PACKAGE - OE_QUERY
SYNONYM - ORG_FREIGHT
VIEW - SO_PICKING_LINES
SYNONYM - SO_PICKING_LINE_DETAILS
APPS.SO_PICKING_LINE_DETAIL_VO_V is not referenced by any database object
[top of page]
View: SO_PICKING_LINE_DET_OEXORRSO_V
[top of page]
APPS.SO_PICKING_LINE_DET_OEXORRSO_V references the following:
APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
PACKAGE - OE_QUERY
SYNONYM - SO_LOOKUPS
SYNONYM - SO_PICKING_LINE_DETAILS
APPS.SO_PICKING_LINE_DET_OEXORRSO_V is not referenced by any database object
[top of page]
View: SO_PO_REQUISITION_LINES_V
[top of page]
APPS.SO_PO_REQUISITION_LINES_V references the following:
APPS
SYNONYM - MTL_PARAMETERS
SYNONYM - PO_REQUISITION_LINES
SYNONYM - PO_REQ_DISTRIBUTIONS
APPS.SO_PO_REQUISITION_LINES_V is not referenced by any database object
[top of page]
View: SO_PRICE_ADJUSTMENTS_V
[top of page]
APPS.SO_PRICE_ADJUSTMENTS_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_DISCOUNTS
SYNONYM - SO_LOOKUPS
SYNONYM - SO_PRICE_ADJUSTMENTS
APPS.SO_PRICE_ADJUSTMENTS_V is not referenced by any database object
[top of page]
View: SO_PRICE_LISTS_ACTIVE_V
[top of page]
APPS.SO_PRICE_LISTS_ACTIVE_V references the following:
APPS
PACKAGE - QP_PRICE_LIST_PVT
SYNONYM - SO_PRICE_LISTS
APPS.SO_PRICE_LISTS_ACTIVE_V is not referenced by any database object
[top of page]
View: SO_PRICE_LISTS_VL
[top of page]
APPS.SO_PRICE_LISTS_VL references the following:
APPS
SYNONYM - SO_PRICE_LISTS_B
SYNONYM - SO_PRICE_LISTS_TL
APPS.SO_PRICE_LISTS_VL is referenced by following:
APPS
VIEW - AS_PRICE_LISTS_V
[top of page]
View: SO_PRICE_LIST_LINES_ALL_V
[top of page]
APPS.SO_PRICE_LIST_LINES_ALL_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - MTL_SYSTEM_ITEMS_VL
PACKAGE - QP_PRICE_LIST_PVT
PACKAGE - QP_UTIL
SYNONYM - SO_PRICE_LIST_LINES
SYNONYM - SO_PRICING_RULES
APPS.SO_PRICE_LIST_LINES_ALL_V is not referenced by any database object
[top of page]
View: SO_PRICING_RULES_VL
[top of page]
APPS.SO_PRICING_RULES_VL references the following:
APPS
SYNONYM - SO_PRICING_RULES_B
SYNONYM - SO_PRICING_RULES_TL
APPS.SO_PRICING_RULES_VL is referenced by following:
APPS
PACKAGE BODY - QP_PRICE_FORMULA_UPG_UTIL_PVT
SYNONYM - SO_PRICING_RULES
[top of page]
View: SO_RA_CUSTOMER_TRX_V
[top of page]
APPS.SO_RA_CUSTOMER_TRX_V references the following:
APPS
PACKAGE - OE_QUERY
SYNONYM - RA_BATCH_SOURCES
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
SYNONYM - RA_CUST_TRX_TYPES
APPS.SO_RA_CUSTOMER_TRX_V is not referenced by any database object
[top of page]
View: SO_REPORT_NAMES_V
[top of page]
APPS.SO_REPORT_NAMES_V references the following:
APPS
VIEW - FND_CONCURRENT_PROGRAMS_VL
SYNONYM - SO_REPORT_SET_LINES
APPS.SO_REPORT_NAMES_V is not referenced by any database object
[top of page]
View: SO_REPORT_PRINTERS_QF_V
[top of page]
APPS.SO_REPORT_PRINTERS_QF_V references the following:
APPS
SYNONYM - FND_APPLICATION_TL
VIEW - FND_CONCURRENT_PROGRAMS_VL
SYNONYM - FND_PRINTER_TL
SYNONYM - FND_PROFILE_OPTION_VALUES
SYNONYM - FND_RESPONSIBILITY_TL
SYNONYM - FND_USER
SYNONYM - SO_REPORTS
SYNONYM - SO_REPORT_PRINTERS
APPS.SO_REPORT_PRINTERS_QF_V is not referenced by any database object
[top of page]
View: SO_REPORT_SET_LINES_V
[top of page]
APPS.SO_REPORT_SET_LINES_V references the following:
APPS
VIEW - FND_CONCURRENT_PROGRAMS_VL
SYNONYM - SO_REPORTS
SYNONYM - SO_REPORT_SET_LINES
APPS.SO_REPORT_SET_LINES_V is not referenced by any database object
[top of page]
View: SO_RESULTS_VL
[top of page]
APPS.SO_RESULTS_VL references the following:
APPS
SYNONYM - SO_RESULTS_B
SYNONYM - SO_RESULTS_TL
APPS.SO_RESULTS_VL is referenced by following:
APPS
SYNONYM - SO_RESULTS
[top of page]
View: SO_RMA_MTL_INT_DETAIL_V
[top of page]
APPS.SO_RMA_MTL_INT_DETAIL_V references the following:
APPS
SYNONYM - MTL_SO_RMA_INTERFACE
SYNONYM - MTL_SO_RMA_RECEIPTS
SYNONYM - SO_LINE_DETAILS
APPS.SO_RMA_MTL_INT_DETAIL_V is referenced by following:
APPS
PACKAGE BODY - OE_QUERY
[top of page]
View: SO_RMA_MTL_INT_V
[top of page]
APPS.SO_RMA_MTL_INT_V references the following:
APPS
SYNONYM - MTL_SO_RMA_INTERFACE
SYNONYM - MTL_SO_RMA_RECEIPTS
APPS.SO_RMA_MTL_INT_V is referenced by following:
APPS
PACKAGE BODY - OE_QUERY
[top of page]
View: SO_SALESPERSONS_ACTIVE_V
[top of page]
APPS.SO_SALESPERSONS_ACTIVE_V references the following:
APPS
VIEW - RA_SALESREPS
APPS.SO_SALESPERSONS_ACTIVE_V is not referenced by any database object
[top of page]
View: SO_SALES_CHANNELS_V
[top of page]
APPS.SO_SALES_CHANNELS_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_LOOKUPS
APPS.SO_SALES_CHANNELS_V is not referenced by any database object
[top of page]
View: SO_SALES_CREDITS_V
[top of page]
APPS.SO_SALES_CREDITS_V references the following:
APPS
VIEW - RA_SALESREPS
SYNONYM - SO_SALES_CREDITS
SYNONYM - SO_SALES_CREDIT_TYPES
APPS.SO_SALES_CREDITS_V is not referenced by any database object
[top of page]
View: SO_SCHEDULE_DETAILS
[top of page]
APPS.SO_SCHEDULE_DETAILS references the following:
APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - MTL_PARAMETERS
VIEW - MTL_SYSTEM_ITEMS_VL
VIEW - SO_LINES
SYNONYM - SO_LINE_DETAILS
SYNONYM - SO_LOOKUPS
VIEW - SO_PICKING_LINES
SYNONYM - SO_PICKING_LINE_DETAILS
APPS.SO_SCHEDULE_DETAILS is not referenced by any database object
[top of page]
View: SO_SERVICE_DETAILS
[top of page]
APPS.SO_SERVICE_DETAILS references the following:
APPS
PACKAGE - CSICUMPI_PUB
SYNONYM - CS_CP_REVISIONS
VIEW - CS_CUSTOMER_PRODUCTS
SYNONYM - CS_CUSTOMER_PRODUCT_STATUSES
SYNONYM - CS_SYSTEMS
PACKAGE - FND_PROFILE
SYNONYM - MTL_SYSTEM_ITEMS
VIEW - SO_LINES
SYNONYM - SO_LINE_SERVICE_DETAILS
APPS.SO_SERVICE_DETAILS is not referenced by any database object
[top of page]
View: SO_SHIP_PRIORITIES_ACTIVE_V
[top of page]
APPS.SO_SHIP_PRIORITIES_ACTIVE_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_LOOKUPS
APPS.SO_SHIP_PRIORITIES_ACTIVE_V is not referenced by any database object
[top of page]
View: SO_STANDARD_VALUE_SOURCES
[top of page]
APPS.SO_STANDARD_VALUE_SOURCES references the following:
APPS
SYNONYM - SO_ATTRIBUTES
SYNONYM - SO_ATTRIBUTE_USES
SYNONYM - SO_GENERAL_STD_VALUE_SOURCES
SYNONYM - SO_OBJECTS
APPS.SO_STANDARD_VALUE_SOURCES is not referenced by any database object
[top of page]
View: SO_TAX_CODES_V
[top of page]
APPS.SO_TAX_CODES_V references the following:
APPS
SYNONYM - AR_SYSTEM_PARAMETERS
SYNONYM - AR_VAT_TAX
APPS.SO_TAX_CODES_V is not referenced by any database object
[top of page]
View: SO_TAX_REASONS_V
[top of page]
APPS.SO_TAX_REASONS_V references the following:
APPS
VIEW - AR_LOOKUPS
APPS.SO_TAX_REASONS_V is not referenced by any database object
[top of page]
View: SO_TAX_STATUSES_V
[top of page]
APPS.SO_TAX_STATUSES_V references the following:
APPS
VIEW - AR_LOOKUPS
APPS.SO_TAX_STATUSES_V is not referenced by any database object
[top of page]
View: SO_USERS_VAL_V
[top of page]
APPS.SO_USERS_VAL_V references the following:
APPS
SYNONYM - FND_USER
APPS.SO_USERS_VAL_V is not referenced by any database object
[top of page]
View: SO_VALID_RESULTS_V
[top of page]
APPS.SO_VALID_RESULTS_V references the following:
APPS
SYNONYM - SO_ACTION_RESULTS
SYNONYM - SO_RESULTS
APPS.SO_VALID_RESULTS_V is not referenced by any database object
[top of page]
View: WSHBV_CONTAINER_CONTENT
[top of page]
APPS.WSHBV_CONTAINER_CONTENT references the following:
APPS
VIEW - WSH_CONTAINER_CONTENTS_V
SYNONYM - WSH_DELIVERIES
APPS.WSHBV_CONTAINER_CONTENT is not referenced by any database object
[top of page]
View: WSHBV_CONTAINER_LOAD
[top of page]
APPS.WSHBV_CONTAINER_LOAD references the following:
APPS
SYNONYM - WSH_CONTAINER_LOAD
APPS.WSHBV_CONTAINER_LOAD is not referenced by any database object
[top of page]
View: WSHBV_DELIVERY
[top of page]
APPS.WSHBV_DELIVERY references the following:
APPS
SYNONYM - WSH_DELIVERIES
APPS.WSHBV_DELIVERY is not referenced by any database object
[top of page]
View: WSHBV_DEPARTURE
[top of page]
APPS.WSHBV_DEPARTURE references the following:
APPS
SYNONYM - WSH_DEPARTURES
APPS.WSHBV_DEPARTURE is not referenced by any database object
[top of page]
View: WSHBV_FREIGHT_CHARGE
[top of page]
APPS.WSHBV_FREIGHT_CHARGE references the following:
APPS
SYNONYM - SO_FREIGHT_CHARGES
APPS.WSHBV_FREIGHT_CHARGE is not referenced by any database object
[top of page]
View: WSHBV_FREIGHT_CHARGE_TYPE
[top of page]
APPS.WSHBV_FREIGHT_CHARGE_TYPE references the following:
APPS
SYNONYM - SO_FREIGHT_CHARGE_TYPES
APPS.WSHBV_FREIGHT_CHARGE_TYPE is not referenced by any database object
[top of page]
View: WSHBV_LINE_PICK_SEQUENCE_RULE
[top of page]
APPS.WSHBV_LINE_PICK_SEQUENCE_RULE references the following:
APPS
SYNONYM - WSH_RELEASE_SEQ_RULES
APPS.WSHBV_LINE_PICK_SEQUENCE_RULE is not referenced by any database object
[top of page]
View: WSHBV_PACKED_CONTAINER
[top of page]
APPS.WSHBV_PACKED_CONTAINER references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSH_PACKED_CONTAINERS
APPS.WSHBV_PACKED_CONTAINER is not referenced by any database object
[top of page]
View: WSHBV_PICKING_BATCH
[top of page]
APPS.WSHBV_PICKING_BATCH references the following:
APPS
SYNONYM - SO_PICKING_BATCHES_ALL
APPS.WSHBV_PICKING_BATCH is not referenced by any database object
[top of page]
View: WSHBV_PICK_HEADER
[top of page]
APPS.WSHBV_PICK_HEADER references the following:
APPS
SYNONYM - SO_PICKING_HEADERS_ALL
APPS.WSHBV_PICK_HEADER is not referenced by any database object
[top of page]
View: WSHBV_PICK_LINE
[top of page]
APPS.WSHBV_PICK_LINE references the following:
APPS
SYNONYM - SO_PICKING_LINES_ALL
APPS.WSHBV_PICK_LINE is not referenced by any database object
[top of page]
View: WSHBV_PICK_LINE_DETAIL
[top of page]
APPS.WSHBV_PICK_LINE_DETAIL references the following:
APPS
SYNONYM - SO_PICKING_LINE_DETAILS
APPS.WSHBV_PICK_LINE_DETAIL is not referenced by any database object
[top of page]
View: WSHBV_PICK_LINE_GROUPING_RULE
[top of page]
APPS.WSHBV_PICK_LINE_GROUPING_RULE references the following:
APPS
SYNONYM - WSH_PICK_SLIP_RULES
APPS.WSHBV_PICK_LINE_GROUPING_RULE is not referenced by any database object
[top of page]
View: WSHBV_PICK_RELEASE_RULE
[top of page]
APPS.WSHBV_PICK_RELEASE_RULE references the following:
APPS
SYNONYM - SO_PICKING_RULES
APPS.WSHBV_PICK_RELEASE_RULE is not referenced by any database object
[top of page]
View: WSHFV_CONTAINER_CONTENT
[top of page]
APPS.WSHFV_CONTAINER_CONTENT references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
SYNONYM - SO_PICKING_LINES_ALL
SYNONYM - SO_PICKING_LINE_DETAILS
SYNONYM - WSH_DELIVERIES
SYNONYM - WSH_PACKED_CONTAINERS
APPS.WSHFV_CONTAINER_CONTENT is not referenced by any database object
[top of page]
View: WSHFV_CONTAINER_LOAD
[top of page]
APPS.WSHFV_CONTAINER_LOAD references the following:
APPS
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSH_CONTAINER_LOAD
APPS.WSHFV_CONTAINER_LOAD is not referenced by any database object
[top of page]
View: WSHFV_DEPARTURE
[top of page]
APPS.WSHFV_DEPARTURE references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - SO_REPORT_SETS
SYNONYM - WSH_DEPARTURES
APPS.WSHFV_DEPARTURE is not referenced by any database object
[top of page]
View: WSHFV_FREIGHT_CHARGE
[top of page]
APPS.WSHFV_FREIGHT_CHARGE references the following:
APPS
SYNONYM - SO_FREIGHT_CHARGES
SYNONYM - SO_FREIGHT_CHARGE_TYPES
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_PICKING_HEADERS_ALL
SYNONYM - WSH_DELIVERIES
SYNONYM - WSH_PACKED_CONTAINERS
APPS.WSHFV_FREIGHT_CHARGE is not referenced by any database object
[top of page]
View: WSHFV_FREIGHT_CHARGE_TYPE
[top of page]
APPS.WSHFV_FREIGHT_CHARGE_TYPE references the following:
APPS
SYNONYM - SO_FREIGHT_CHARGE_TYPES
APPS.WSHFV_FREIGHT_CHARGE_TYPE is not referenced by any database object
[top of page]
View: WSHFV_LINE_PICK_SEQUENCE_RULE
[top of page]
APPS.WSHFV_LINE_PICK_SEQUENCE_RULE references the following:
APPS
SYNONYM - WSH_RELEASE_SEQ_RULES
APPS.WSHFV_LINE_PICK_SEQUENCE_RULE is not referenced by any database object
[top of page]
View: WSHFV_PACKED_CONTAINER
[top of page]
APPS.WSHFV_PACKED_CONTAINER references the following:
APPS
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSH_DELIVERIES
SYNONYM - WSH_PACKED_CONTAINERS
APPS.WSHFV_PACKED_CONTAINER is not referenced by any database object
[top of page]
View: WSHFV_PICK_LINE_GROUPING_RULE
[top of page]
APPS.WSHFV_PICK_LINE_GROUPING_RULE references the following:
APPS
SYNONYM - WSH_PICK_SLIP_RULES
APPS.WSHFV_PICK_LINE_GROUPING_RULE is not referenced by any database object
[top of page]
View: WSH_BIS_BACKORDERED_SUM_V
[top of page]
APPS.WSH_BIS_BACKORDERED_SUM_V references the following:
APPS
SYNONYM - SO_PICKING_LINES_ALL
SYNONYM - SO_PICKING_LINE_DETAILS
APPS.WSH_BIS_BACKORDERED_SUM_V is not referenced by any database object
[top of page]
View: WSH_BIS_FILL_BY_DAY_V
[top of page]
APPS.WSH_BIS_FILL_BY_DAY_V references the following:
APPS
VIEW - WSH_BIS_FILL_RATE_V
APPS.WSH_BIS_FILL_BY_DAY_V is not referenced by any database object
[top of page]
View: WSH_BIS_FILL_RATE_V
[top of page]
APPS.WSH_BIS_FILL_RATE_V references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
SYNONYM - SO_PICKING_BATCHES_ALL
SYNONYM - SO_PICKING_HEADERS_ALL
SYNONYM - SO_PICKING_LINES_ALL
SYNONYM - SO_PICKING_LINE_DETAILS
SYNONYM - WSH_DEPARTURES
APPS.WSH_BIS_FILL_RATE_V is referenced by following:
APPS
PACKAGE BODY - OE_BIS
VIEW - WSH_BIS_FILL_BY_DAY_V
VIEW - WSH_BIS_SHIPPED_BY_DAY_V
[top of page]
View: WSH_BIS_SHIPPED_BY_DAY_V
[top of page]
APPS.WSH_BIS_SHIPPED_BY_DAY_V references the following:
APPS
VIEW - WSH_BIS_FILL_RATE_V
APPS.WSH_BIS_SHIPPED_BY_DAY_V is not referenced by any database object
[top of page]
View: WSH_BIS_WAREHOUSE_DOCS_V
[top of page]
APPS.WSH_BIS_WAREHOUSE_DOCS_V references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - SO_LINES_ALL
SYNONYM - SO_PICKING_BATCHES_ALL
SYNONYM - SO_PICKING_HEADERS_ALL
SYNONYM - SO_PICKING_LINES_ALL
SYNONYM - SO_PICKING_LINE_DETAILS
SYNONYM - WSH_DEPARTURES
PACKAGE - WSH_WV_PVT
APPS.WSH_BIS_WAREHOUSE_DOCS_V is not referenced by any database object
[top of page]
View: WSH_CHARGES_V
[top of page]
APPS.WSH_CHARGES_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - SO_FREIGHT_CHARGES
SYNONYM - SO_FREIGHT_CHARGE_TYPES
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LOOKUPS
SYNONYM - SO_PICKING_HEADERS_ALL
SYNONYM - WSH_PACKED_CONTAINERS
APPS.WSH_CHARGES_V is not referenced by any database object
[top of page]
View: WSH_CONTAINER_CONTENTS_V
[top of page]
APPS.WSH_CONTAINER_CONTENTS_V references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
SYNONYM - SO_PICKING_LINES_ALL
SYNONYM - SO_PICKING_LINE_DETAILS
SYNONYM - WSH_PACKED_CONTAINERS
APPS.WSH_CONTAINER_CONTENTS_V is referenced by following:
APPS
VIEW - WSHBV_CONTAINER_CONTENT
[top of page]
View: WSH_DELIVERIES_DPW_LOV_V
[top of page]
APPS.WSH_DELIVERIES_DPW_LOV_V references the following:
APPS
SYNONYM - WSH_DELIVERIES
SYNONYM - WSH_DEPARTURES
APPS.WSH_DELIVERIES_DPW_LOV_V is not referenced by any database object
[top of page]
View: WSH_DEPARTURES_V
[top of page]
APPS.WSH_DEPARTURES_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - SO_LOOKUPS
SYNONYM - SO_REPORT_SETS
SYNONYM - WSH_DEPARTURES
APPS.WSH_DEPARTURES_V is not referenced by any database object
[top of page]
View: WSH_DEPARTURE_TEMPLATES_V
[top of page]
APPS.WSH_DEPARTURE_TEMPLATES_V references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSH_DEPARTURE_TEMPLATES
APPS.WSH_DEPARTURE_TEMPLATES_V is not referenced by any database object
[top of page]
View: WSH_PACKED_CONTAINERS_DPW_V
[top of page]
APPS.WSH_PACKED_CONTAINERS_DPW_V references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSH_DELIVERIES
SYNONYM - WSH_DEPARTURES
SYNONYM - WSH_PACKED_CONTAINERS
APPS.WSH_PACKED_CONTAINERS_DPW_V is not referenced by any database object
[top of page]
View: WSH_PACKED_CONTAINERS_V
[top of page]
APPS.WSH_PACKED_CONTAINERS_V references the following:
APPS
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WSH_PACKED_CONTAINERS
APPS.WSH_PACKED_CONTAINERS_V is not referenced by any database object
[top of page]
View: WSH_PICKING_DETAILS_INTERFACE
[top of page]
APPS.WSH_PICKING_DETAILS_INTERFACE references the following:
APPS
SYNONYM - MTL_TRANSACTIONS_INTERFACE
SYNONYM - SO_HEADERS_ALL
SYNONYM - SO_LINES_ALL
SYNONYM - SO_ORDER_TYPES_ALL
SYNONYM - SO_PICKING_LINES_ALL
SYNONYM - SO_PICKING_LINE_DETAILS
APPS.WSH_PICKING_DETAILS_INTERFACE is referenced by following:
APPS
PACKAGE BODY - WSH_SC_TRX_INTERFACE
[top of page]
View: WSH_SHIPPING_DETAILS_V
[top of page]
APPS.WSH_SHIPPING_DETAILS_V references the following:
APPS
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - OE_INSTALL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
VIEW - WSH_DELIVERY_ASSIGNMENTS_V
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_LOCATIONS
VIEW - WSH_LOOKUPS
SYNONYM - WSH_NEW_DELIVERIES
SYNONYM - WSH_TRIP_STOPS
APPS.WSH_SHIPPING_DETAILS_V is not referenced by any database object
[top of page]