VIEW: APPS.MST_FTE_LANE_VEHICLES_V

Source

View Text - Preformatted

SELECT lv.LANE_VEHICLE_ID LANE_VEHICLE_ID, lv.LANE_GROUP_ID LANE_GROUP_ID, lv.LANE_ID LANE_ID, lv.VEHICLE_TYPE_ID VEHICLE_TYPE_ID, lv.QUANTITY QUANTITY, lv.FREQUENCY_UOM FREQUENCY_UOM, lv.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, lv.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, decode(lv.lane_id, null,decode(lv.LANE_GROUP_ID,null, null,lg.carrier_id),l.carrier_id) CARRIER_ID from fte_lane_vehicles lv, fte_lanes l, fte_lane_groups lg WHERE lv.lane_id = l.lane_id(+) and lv.LANE_GROUP_ID = lg.LANE_GROUP_ID(+)

View Text - HTML Formatted

SELECT LV.LANE_VEHICLE_ID LANE_VEHICLE_ID
, LV.LANE_GROUP_ID LANE_GROUP_ID
, LV.LANE_ID LANE_ID
, LV.VEHICLE_TYPE_ID VEHICLE_TYPE_ID
, LV.QUANTITY QUANTITY
, LV.FREQUENCY_UOM FREQUENCY_UOM
, LV.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, LV.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, DECODE(LV.LANE_ID
, NULL
, DECODE(LV.LANE_GROUP_ID
, NULL
, NULL
, LG.CARRIER_ID)
, L.CARRIER_ID) CARRIER_ID
FROM FTE_LANE_VEHICLES LV
, FTE_LANES L
, FTE_LANE_GROUPS LG
WHERE LV.LANE_ID = L.LANE_ID(+)
AND LV.LANE_GROUP_ID = LG.LANE_GROUP_ID(+)