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.

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

VIEW: APPS.MST_R_MASTER_SUM_PLAN_HDR_V

Object Details

Object Name:	MST_R_MASTER_SUM_PLAN_HDR_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	Comments
PLAN_ID	NUMBER		plan for which report is generated
COMPILE_DESIGNATOR	VARCHAR2	(10)	plan name
REPORT_DATE	DATE		report run date
PLAN_START_DATE	DATE		plan's start date
PLAN_COMPLETION_DATE	DATE		plan's end date
TOTAL_ORDERS	NUMBER		total number of orders included in the plan
TOTAL_DELIVERIES	NUMBER		total logical orders in the plan
TOTAL_WEIGHT	NUMBER		weight of all the plan orders
TOTAL_VOLUME	NUMBER		volume of all the plan orders
TOTAL_PIECES	NUMBER		number of pieces in all the plan orders
TOTAL_PALLETS	NUMBER
ALLOCATED_COST	NUMBER
PLAN_VALUE	NUMBER		Sum of value for all order lines - same as used in determing penalties for late delivery
TOTAL_TL_COUNT	NUMBER		total truckloads in the plan
TOTAL_LTL_COUNT	NUMBER		total LTLs in the plan
TOTAL_PARCEL_COUNT	NUMBER		total parcels in the plan
TOTAL_TL_COST	NUMBER		truckload's transportation + loading/unloading cost in the plan
TOTAL_LTL_COST	NUMBER		LTL's transportation + loading/unloading cost in the plan
TOTAL_PARCEL_COST	NUMBER		Parcel's transportation + loading/unloading cost in the plan
TOTAL_TRANSPORTATION_COST	NUMBER		Transportation + loading/unloading cost of TLs, LTLs, Parcels
TOTAL_HANDLING_COST	NUMBER		Total handling cost for a plan, as defined in the legs
TOTAL_PLAN_COST	NUMBER		Transportation + Handling cost
TOTAL_STOPS	NUMBER		The total number of stops, not counting the initial origin, made by all truckloads in the plan, divided by the number of truckloads in the plan
TOTAL_DISTANCE	NUMBER		The total distance traversed by all truckloads in the plan
PERCENT_OF_ALLOC_COST	NUMBER
PERCENT_OF_VALUE	NUMBER		Parcentage of total cost of the plan to the total plan value

Query Text

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


SELECT PLAN_ID
,      COMPILE_DESIGNATOR
,      REPORT_DATE
,      PLAN_START_DATE
,      PLAN_COMPLETION_DATE
,      TOTAL_ORDERS
,      TOTAL_DELIVERIES
,      TOTAL_WEIGHT
,      TOTAL_VOLUME
,      TOTAL_PIECES
,      TOTAL_PALLETS
,      ALLOCATED_COST
,      PLAN_VALUE
,      TOTAL_TL_COUNT
,      TOTAL_LTL_COUNT
,      TOTAL_PARCEL_COUNT
,      TOTAL_TL_COST
,      TOTAL_LTL_COST
,      TOTAL_PARCEL_COST
,      TOTAL_TRANSPORTATION_COST
,      TOTAL_HANDLING_COST
,      TOTAL_PLAN_COST
,      TOTAL_STOPS
,      TOTAL_DISTANCE
,      PERCENT_OF_ALLOC_COST
,      PERCENT_OF_VALUE
FROM APPS.MST_R_MASTER_SUM_PLAN_HDR_V;

Dependencies

[top of page]

APPS.MST_R_MASTER_SUM_PLAN_HDR_V references the following:

APPS: MST_MAST_SUM_REPORT_TEMP_GT

APPS.MST_R_MASTER_SUM_PLAN_HDR_V is not referenced by any database object