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

VIEW: APPS.MST_PQ_UA_DEL_RESULTS_V

Object Details
Object Name: MST_PQ_UA_DEL_RESULTS_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
QUERY_ID NUMBER
Yes ID of the Query.
PLAN_ID NUMBER
Yes ID of the plan used in the query.
DELIVERY_ID NUMBER
Yes ID of the Delivery for the Unassigned delivery.
DELIVERY_NUMBER NUMBER

TP Delivery Number
ORIGIN_FACILITY_ID NUMBER
Yes ID of the Origin Facility for the Unassigned delivery.
ORIGIN_FACILITY VARCHAR2 (60) Yes Name of the Origin Facility for the Unassigned delivery.
ORIGIN_CITY VARCHAR2 (120)
Origin City for the Unassigned delivery.
ORIGIN_STATE VARCHAR2 (120)
Origin State for the Unassigned delivery.
DESTINATION_FACILITY_ID NUMBER
Yes ID of the Destination Facility for the Unassigned delivery.
DESTINATION_FACILITY VARCHAR2 (60) Yes Name of the Destination Facility for the Unassigned delivery.
DESTINATION_CITY VARCHAR2 (120)
Destination City for the Unassigned delivery.
DESTINATION_STATE VARCHAR2 (120)
Destination State for the Unassigned delivery.
Query Text

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


SELECT QUERY_ID
,      PLAN_ID
,      DELIVERY_ID
,      DELIVERY_NUMBER
,      ORIGIN_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_CITY
,      ORIGIN_STATE
,      DESTINATION_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_CITY
,      DESTINATION_STATE
FROM APPS.MST_PQ_UA_DEL_RESULTS_V;

Dependencies

[top of page]

APPS.MST_PQ_UA_DEL_RESULTS_V references the following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS
SynonymMST_DELIVERIES
SynonymMST_PERSONAL_QUERY_RESULTS
SynonymMST_PLANS
SynonymWSH_LOCATIONS

APPS.MST_PQ_UA_DEL_RESULTS_V is not referenced by any database object