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

VIEW: APPS.MST_PQ_CM_RESULTS_V

Object Details
Object Name: MST_PQ_CM_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 Query.
PLAN_ID NUMBER
Yes Primary key
PLAN_NAME VARCHAR2 (10) Yes Why not simple plan_code?
CM_TRIP_NUMBER NUMBER

Continuous move trip number
CONTINUOUS_MOVE_ID NUMBER
Yes Primary key for the table
CARRIER_ID NUMBER

Carrier of the continuous move
CARRIER_NAME VARCHAR2 (30) Yes Name of Carrier of the CM.
TOTAL_COST NUMBER

Total Cost of the CM.
CURRENCY_UOM VARCHAR2 (3)
Currency for Total Cost
TIME_TO_DEPARTURE NUMBER

Time left for Departure.
TIME_UNIT NUMBER

Unit for Time left. 1=>Days, 2=>Hours.
TIME_UNIT_DESC VARCHAR2 (10)
Descriptive text for Time Unit. (Days, Hours)
Query Text

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


SELECT QUERY_ID
,      PLAN_ID
,      PLAN_NAME
,      CM_TRIP_NUMBER
,      CONTINUOUS_MOVE_ID
,      CARRIER_ID
,      CARRIER_NAME
,      TOTAL_COST
,      CURRENCY_UOM
,      TIME_TO_DEPARTURE
,      TIME_UNIT
,      TIME_UNIT_DESC
FROM APPS.MST_PQ_CM_RESULTS_V;

Dependencies

[top of page]

APPS.MST_PQ_CM_RESULTS_V references the following:

SchemaAPPS
SynonymMST_CM_SELECTION_CRITERIA
SynonymMST_CM_TRIPS
SynonymMST_PERSONAL_QUERY_RESULTS
SynonymMST_PLANS
PL/SQL PackageMST_WB_UTIL - show dependent code
SynonymWSH_CARRIERS

APPS.MST_PQ_CM_RESULTS_V is not referenced by any database object