DBA Data[Home] [Help]

VIEW: APPS.MST_R_MASTER_SUM_PLAN_HDR_V

Source

View Text - Preformatted

SELECT plan_id , compile_designator , report_date , plan_start_date , plan_end_date , orders , order_groups , weight , volume , pieces , pallets , allocated_cost , plan_value , total_tl_count , ltl_count , parcel_count , tl_cost , ltl_cost , parcel_cost , transportation_cost , handling_cost , total_cost , tl_stops , tl_distance , percent_alloc_cost , percent_value from mst_mast_sum_report_temp_gt WHERE view_id = 1
View Text - HTML Formatted

SELECT PLAN_ID
, COMPILE_DESIGNATOR
, REPORT_DATE
, PLAN_START_DATE
, PLAN_END_DATE
, ORDERS
, ORDER_GROUPS
, WEIGHT
, VOLUME
, PIECES
, PALLETS
, ALLOCATED_COST
, PLAN_VALUE
, TOTAL_TL_COUNT
, LTL_COUNT
, PARCEL_COUNT
, TL_COST
, LTL_COST
, PARCEL_COST
, TRANSPORTATION_COST
, HANDLING_COST
, TOTAL_COST
, TL_STOPS
, TL_DISTANCE
, PERCENT_ALLOC_COST
, PERCENT_VALUE
FROM MST_MAST_SUM_REPORT_TEMP_GT
WHERE VIEW_ID = 1