2.12. Pohled "STD_BIM_USE_PRJ_PHASE_VW"
| název sloupce | Typ | výchozí | upravitelný |
|---|
| ID | NUMBER ( 22 ) | | Ne |
| KDO | VARCHAR2 ( 120 ) | | Ne |
| KDY | DATE ( ) | | Ne |
| KDY_DMR | VARCHAR2 ( 10 ) | | Ne |
| KDY_DMRHM | VARCHAR2 ( 16 ) | | Ne |
| VISIBLE | VARCHAR2 ( 20 ) | | Ne |
| IS_I | CHAR ( 1 ) | | Ne |
| IS_P | CHAR ( 1 ) | | Ne |
| IS_S | CHAR ( 1 ) | | Ne |
| IS_Z | CHAR ( 1 ) | | Ne |
| KOD | VARCHAR2 ( 20 ) | | Ne |
| POR_PUV | NUMBER ( 22 ) | | Ne |
| POR_NOV | NUMBER ( 22 ) | | Ne |
| NAZEV | VARCHAR2 ( 800 ) | | Ne |
| KOMENTAR | VARCHAR2 ( 2000 ) | | Ne |
| NAZEV_CZ | VARCHAR2 ( 800 ) | | Ne |
| KOMENTAR_CZ | VARCHAR2 ( 2000 ) | | Ne |
| LINK_TEXT | VARCHAR2 ( 800 ) | | Ne |
| LINK_URL | VARCHAR2 ( 800 ) | | Ne |
| P_VISIBLE | VARCHAR2 ( 20 ) | | Ne |
| P_ZNAK | CHAR ( 4 ) | | Ne |
| P_KOD | VARCHAR2 ( 20 ) | | Ne |
| X_VISIBLE | VARCHAR2 ( 20 ) | | Ne |
| X_VAHA | NUMBER ( 22 ) | | Ne |
select
UP.ID,
--
UP.Kdo,
UP.Kdy,
To_Char(UP.Kdy,'dd.mm.yyyy') Kdy_DMR,
To_Char(UP.Kdy,'dd.mm.yyyy hh24:mi') Kdy_DMRHM,
--
UP.Visible,
case when UP.Visible like '%I%' then 'Y' else 'N' end is_I,
case when UP.Visible like '%P%' then 'Y' else 'N' end is_P,
case when UP.Visible like '%S%' then 'Y' else 'N' end is_S,
case when UP.Visible like '%Z%' then 'Y' else 'N' end is_Z,
--
UP.Kod,
UP.Por_puv,
UP.Por_nov,
UP.Nazev,
UP.Komentar,
UP.Nazev_CZ,
UP.Komentar_CZ,
UP.Link_Text,
UP.Link_URL,
--
UP.P_Visible,
UP.P_Znak,
UP.P_Kod,
--
X.Visible X_Visible,
X.Vaha X_Vaha
from
(
select
U.ID,
--
U.Kdo,
U.Kdy,
--
U.Visible,
--
U.Kod,
U.Por_puv,
U.Por_nov,
U.Nazev,
U.Komentar,
U.Nazev_CZ,
U.Komentar_CZ,
U.Link_Text,
U.Link_URL,
--
P.ID P_ID,
P.Visible P_Visible,
P.Znak P_Znak,
P.Kod P_Kod
from
STD_BIM_Use U,
STD_Prj_Phase P
) UP,
STD_Phase_Use X
where X.Use_ID(+)=UP.ID
and X.Phase_ID(+)=UP.P_ID
