DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OZF_ORDER_SALES_V

Object Details
Object Name: OZF_ORDER_SALES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

PERIOD_TYPE_ID NUMBER

CUST_ACCOUNT_ID NUMBER

SHIP_TO_SITE_USE_ID NUMBER

BILL_TO_SITE_USE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

SALES NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      CUST_ACCOUNT_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      INVENTORY_ITEM_ID
,      SALES
FROM APPS.OZF_ORDER_SALES_V;

Dependencies

[top of page]

APPS.OZF_ORDER_SALES_V references the following:

SchemaAPPS
SynonymOZF_ORDER_SALES_SUMRY_MV
PL/SQL PackageOZF_TP_UTIL_QUERIES - show dependent code
APPS.OZF_ORDER_SALES_V is referenced by following:

SchemaAPPS
Package BodyOZF_ALLOCATION_ENGINE_PVT - show dependent code
Package BodyOZF_CUST_FACTS_PVT - show dependent code