Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* CabinetContracts - ContractsView */
- Select c.id_contract
- ,ps.name_Kind_paragraph
- ,ps.Status_Text
- ,c.d_start
- ,c.d_end
- ,c.dp_end
- From web_user_wp wu
- ,employees_ e
- ,contracts_ c
- ,paragraphs_status_ ps
- Where
- wu.id_web_user = :Bind_IdWebUser
- and wu.id_e_kis = e.id_e
- and e.id_contractor = c.id_with_whom
- and c.id_paragraph = ps.id_paragraph
- Order by c.d_start desc, ps.name_Kind_paragraph, ps.Status_Text
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement