DBA Data[Home] [Help]

VIEW: APPS.MST_R_SUPP_DETAIL_V

Source

View Text - Preformatted

SELECT plan_id , 0 , supplier_name , orders , weight , volume , pieces , mtl_count , dtl_count , ltl_count , parcel_count , tl_cost , ltl_cost , parcel_cost , total_cost , cost_per_unit_weight , cost_per_unit_volume , percent_value , percent_alloc_cost from mst_mast_sum_report_temp_gt WHERE view_id = 7
View Text - HTML Formatted

SELECT PLAN_ID
, 0
, SUPPLIER_NAME
, ORDERS
, WEIGHT
, VOLUME
, PIECES
, MTL_COUNT
, DTL_COUNT
, LTL_COUNT
, PARCEL_COUNT
, TL_COST
, LTL_COST
, PARCEL_COST
, TOTAL_COST
, COST_PER_UNIT_WEIGHT
, COST_PER_UNIT_VOLUME
, PERCENT_VALUE
, PERCENT_ALLOC_COST
FROM MST_MAST_SUM_REPORT_TEMP_GT
WHERE VIEW_ID = 7