API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 1st, 2020
108
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.52 KB | None | 0 0
raw download clone embed print report
  1. create view fcapta_xbm_v (
  2. cod_emp,
  3. cod_ope,
  4. cen_ope,
  5. nro_ope,
  6. fch_ope,
  7. cod_amb,
  8. cod_mae,
  9. den_mae,
  10. cod_cen,
  11. den_cen,
  12. cod_tar,
  13. den_tar,
  14. cod_gta,
  15. den_gta,
  16. fch_ini,
  17. cod_bie_1,
  18. cod_bie_2,
  19. cod_bie_3,
  20. cod_cua,
  21. enu_cua,
  22. flg_sub_acv,
  23. cod_sub_acv,
  24. cod_apl_cua,
  25. cod_bie,
  26. den_bie,
  27. cen_cos,
  28. fac_cnv,
  29. vol,
  30. tip_cmo,
  31. cod_cmo,
  32. den_cmo,
  33. can_cmo,
  34. uni_cmo,
  35. tab_uni,
  36. cod_uni,
  37. tar_uni,
  38. can,
  39. uni_med,
  40. mto_ref,
  41. dal_ope,
  42. dal_op2,
  43. uni_dal,
  44. can_alt,
  45. obs,
  46. seq_ope_id,
  47. den_est_trs,
  48. hil_dde,
  49. hil_hta,
  50. mts_hil,
  51. ren_hil,
  52. cod_ord,
  53. nro_ord) as
  54. select
  55. a.cod_emp,
  56. a.cod_ope,
  57. a.cen_ope,
  58. a.nro_ope,
  59. b.fch_ope,
  60. a.cod_amb,
  61. a.cod_mae,
  62. ltrim(rtrim(c.den)),
  63. a.cod_cen,
  64. d.abr,
  65. a.cod_tar,
  66. ltrim(rtrim(e.den)),
  67. a.cod_gta,
  68. ltrim(rtrim(f.den)),
  69. a.fch_ini,
  70. a.cod_bie_1,
  71. a.cod_bie_2,
  72. a.cod_bie_3,
  73. a.cod_cua,
  74. a.enu_cua,
  75. a.flg_sub_acv,
  76. a.cod_sub_acv,
  77. a.cod_apl_cua,
  78. a.cod_bie,
  79. ltrim(rtrim(g.den)),
  80. a.cen_cos,
  81. a.fac_cnv,
  82. a.vol,
  83. a.tip_cmo,
  84. a.cod_cmo,
  85. arballon.cos_dencmo(a.cod_emp, a.cod_amb, a.tip_cmo, a.cod_cmo),
  86. a.can_cmo,
  87. arballon.cos_unicmo(a.cod_emp, a.cod_amb, a.tip_cmo, a.cod_cmo, 1),
  88. a.tab_uni,
  89. a.cod_uni,
  90. k.val_004,
  91. a.can,
  92. h.uni_med,
  93. arballon.fca_ptacanmda(a.can, a.cod_uni),
  94. a.dal_ope,
  95. a.dal_op2,
  96. substring(k.val_002, 1, 4),
  97. a.can_alt,
  98. a.obs,
  99. a.seq_ope_id,
  100. arballon.gen_denest(arballon.fca_esttrs(a.cod_emp, a.cod_ope, a.cen_ope, a.nro_ope, b.est_trs), ' ', 'Aprobado'),
  101. a.hil_dde,
  102. a.hil_hta,
  103. arballon.fca_mtshil(a.cod_emp, a.cod_cen, a.cod_cua, a.hil_dde, a.hil_hta) as "mts_hil",
  104. arballon.gen_div(arballon.fca_mtshil(a.cod_emp, a.cod_cen, a.cod_cua, a.hil_dde, a.hil_hta), a.can, 0) as "ren_hil",
  105. a.cod_ord,
  106. a.nro_ord
  107. from fcaptacab b
  108. inner join fcapta a on
  109. a.cod_emp = b.cod_emp and
  110. a.cod_ope = b.cod_ope and
  111. a.cen_ope = b.cen_ope and
  112. a.nro_ope = b.nro_ope
  113. left outer join genmae c on
  114. c.cod_emp = a.cod_emp and
  115. c.cod_amb = a.cod_amb and
  116. c.tip_mae = a.tip_mae and
  117. c.cod_mae = a.cod_mae
  118. inner join logcen d on
  119. d.cod_emp = a.cod_emp and
  120. d.cod_cen = a.cod_cen
  121. inner join genmae e on
  122. e.cod_emp = a.cod_emp and
  123. e.cod_amb = a.cod_amb and
  124. e.tip_mae = a.tip_tar and
  125. e.cod_mae = a.cod_tar
  126. left outer join logcma f on
  127. f.cod_emp = a.cod_emp and
  128. f.cod_amb = a.cod_amb and
  129. f.tip_mae = a.tip_tar and
  130. f.cod_tab = a.tab_gta and
  131. f.cod_aux = a.cod_gta
  132. left outer join genmae g on
  133. g.cod_emp = a.cod_emp and
  134. g.cod_amb = a.cod_amb and
  135. g.tip_mae = a.tip_bie and
  136. g.cod_mae = a.cod_bie
  137. inner join genfac h on
  138. h.cod_emp = a.cod_emp and
  139. h.cod_amb = a.cod_amb and
  140. h.tip_mae = a.tip_tar and
  141. h.cod_mae = a.cod_tar
  142. inner join logvar k on
  143. k.cod_tab = a.tab_uni and
  144. k.cod_aux = a.cod_uni
  145. where not exists (
  146. select
  147. 1
  148. from adkfcaopecab x
  149. where x.cod_emp = b.cod_emp
  150. and x.cod_ope = b.cod_ope
  151. and x.cen_ope = b.cen_ope
  152. and x.nro_ope = b.nro_ope
  153. )
  154.  
  155. union all
  156.  
  157. select
  158. a.cod_emp,
  159. a.cod_ope,
  160. a.cen_ope,
  161. a.nro_ope,
  162. b.fch_ope,
  163. a.cod_amb,
  164. a.cod_mae,
  165. ltrim(rtrim(c.den)),
  166. a.cod_cen,
  167. d.abr,
  168. a.cod_tar,
  169. ltrim(rtrim(e.den)),
  170. a.cod_gta,
  171. ltrim(rtrim(f.den)),
  172. a.fch_ini,
  173. a.cod_bie_1,
  174. a.cod_bie_2,
  175. a.cod_bie_3,
  176. a.cod_cua,
  177. a.enu_cua,
  178. a.flg_sub_acv,
  179. a.cod_sub_acv,
  180. a.cod_apl_cua,
  181. a.cod_bie,
  182. ltrim(rtrim(g.den)),
  183. a.cen_cos,
  184. a.fac_cnv,
  185. a.vol,
  186. a.tip_cmo,
  187. a.cod_cmo,
  188. arballon.cos_dencmo(a.cod_emp, a.cod_amb, a.tip_cmo, a.cod_cmo),
  189. a.can_cmo,
  190. arballon.cos_unicmo(a.cod_emp, a.cod_amb, a.tip_cmo, a.cod_cmo, 1),
  191. a.tab_uni,
  192. a.cod_uni,
  193. k.val_004,
  194. a.can,
  195. h.uni_med,
  196. arballon.fca_ptacanmda(a.can, a.cod_uni),
  197. a.dal_ope,
  198. a.dal_op2,
  199. substring(k.val_002, 1, 4),
  200. a.can_alt,
  201. a.obs,
  202. a.seq_ope_id,
  203. arballon.gen_denest(arballon.fca_esttrs(a.cod_emp, a.cod_ope, a.cen_ope, a.nro_ope, b.est_trs), ' ', 'Aprobado'),
  204. a.hil_dde,
  205. a.hil_hta,
  206. arballon.fca_mtshil(a.cod_emp, a.cod_cen, a.cod_cua, a.hil_dde, a.hil_hta) as "mts_hil",
  207. arballon.gen_div(arballon.fca_mtshil(a.cod_emp, a.cod_cen, a.cod_cua, a.hil_dde, a.hil_hta), a.can, 0) as "ren_hil",
  208. a.cod_ord,
  209. a.nro_ord
  210. from fcaptacab b
  211. inner join fcapta a on
  212. a.cod_emp = 1 and
  213. a.cen_ope = 105 and
  214. a.cod_ope = 'Pta3' and
  215. a.nro_ope in (65007425, 65007426, 65007427, 65007428, 65007429, 65007430, 65007431, 65007432, 65007433, 65007434, 65007435, 65007436, 65007437, 65007438, 65007439, 65007440, 65007441, 65007442, 65007443, 65007444, 65007445, 65007446, 65007447, 65007448, 65007449, 65007450, 65007451, 65007452, 65007453, 65007454, 65007455, 65007456, 65007457, 65007458, 65007459, 65007460, 65007461, 65007462, 65007463, 65007464, 65007465, 65007466, 65007467, 65007468, 65007469, 65007470, 65007471, 65007472, 65007473, 65007474, 65007475, 65007476, 65007477, 65007478, 65007479, 65007480, 65007481, 65007482, 65007483, 65007484, 65007485, 65007486, 65007487, 65007488, 65007489, 65007490, 65007491, 65007492, 65007493, 65007494, 65007495, 65007496, 65007497, 65007498, 65007499, 65007500, 65007501, 65007502, 65007503, 65007504, 65007505, 65007506, 65007507, 65007508, 65007509, 65007510, 65007511, 65007512, 65007513, 65007514, 65007515, 65007516, 65007517, 65007518, 65007519, 65007520, 65007521, 65007522, 65007523, 65007524, 65007525, 65007526, 65007527, 65007528, 65007529, 65007530, 65007531, 65007532, 65007533, 65007534, 65007535, 65007536, 65007537, 65007538, 65007539, 65007540, 65007541, 65007542, 65007543, 65007544, 65007545, 65007546, 65007547, 65007548, 65007549, 65007550, 65007551, 65007552, 65007553, 65007554, 65007555, 65007556, 65007557, 65007558, 65007559, 65007560, 65007561, 65007562, 65007563, 65007564, 65007565, 65007566, 65007567, 65007568, 65007569, 65007570, 65007571, 65007572, 65007573, 65007574, 65007575, 65007576, 65007577, 65007578, 65007579, 65007580, 65007581, 65007582, 65007583, 65007584, 65007585, 65007586, 65007587, 65007588, 65007589, 65007590, 65007591, 65007592, 65007593, 65007594, 65007595, 65007596, 65007597, 65007598, 65007599, 65007600, 65007601, 65007602, 65007603, 65007604, 65007605, 65007606, 65007607, 65007608, 65007609, 65007610, 65007611, 65007612, 65007613, 65007614, 65007615, 65007616, 65007617, 65007618, 65007619, 65007620, 65007621, 65007622, 65007623, 65007624, 65007625, 65007626, 65007627, 65007628, 65007629, 65007630, 65007631, 65007632, 65007633, 65007634, 65007635, 65007636, 65007637, 65007638, 65007639, 65007640, 65007641, 65007642, 65007643, 65007644, 65007645, 65007646, 65007647, 65007648, 65007649, 65007650, 65007651, 65007652, 65007653, 65007654, 65007655, 65007656, 65007657, 65007658, 65007659, 65007660, 65007661, 65007662, 65007663, 65007664, 65007665, 65007666, 65007667, 65007668, 65007669, 65007670, 65007671, 65007672, 65007673, 65007674, 65007675, 65007676, 65007677, 65007678, 65007679, 65007680, 65007681, 65007682, 65007683, 65007684, 65007685, 65007686, 65007687, 65007688, 65007689, 65007690, 65007691, 65007692, 65007693, 65007694, 65007695, 65007696, 65007697, 65007698, 65007699, 65007700, 65007701, 65007702, 65007703, 65007704, 65007705, 65007706, 65007707, 65007708, 65007709, 65007710, 65007711, 65007712, 65007713, 65007714, 65007715, 65007716, 65007717, 65007718, 65007719, 65007720, 65007721, 65007722, 65007723, 65007724, 65007725, 65007726, 65007727, 65007728, 65007729, 65007730, 65007731, 65007732, 65007733, 65007734, 65007735, 65007736, 65007737, 65007738, 65007739, 65007740, 65007741, 65007742, 65007743, 65007744, 65007745, 65007746, 65007747, 65007748, 65007749, 65007750, 65007751, 65007752, 65007753, 65007754, 65007755, 65007756, 65007757, 65007758, 65007759, 65007760, 65007761, 65007762, 65007763, 65007764, 65007765, 65007766, 65007767, 65007768, 65007769, 65007770, 65007771, 65007772, 65007773, 65007774, 65007775, 65007776, 65007777, 65007778, 65007779, 65007780, 65007781, 65007782, 65007783, 65007784, 65007785, 65007786, 65007787, 65007788, 65007789, 65007790, 65007791, 65007792, 65007793, 65007794, 65007795, 65007796, 65007797, 65007798, 65007799, 65007800, 65007801, 65007802, 65007803, 65007804, 65007805, 65007806, 65007807, 65007808, 65007809, 65007810, 65007811, 65007812, 65007813, 65007814, 65007815, 65007816, 65007817, 65007818, 65007819, 65007820, 65007821, 65007822, 65007823, 65007824, 65007825, 65007826, 65007827, 65007828, 65007829, 65007830, 65007831, 65007832, 65007833, 65007834, 65007835, 65007836, 65007837, 65007838, 65007839, 65007840, 65007841, 65007842, 65007843, 65007844, 65007845, 65007846, 65007847, 65007848, 65007849, 65007850, 65007851, 65007852, 65007853, 65007854, 65007855, 65007856, 65007857, 65007858, 65007859, 65007860, 65007861, 65007862, 65007863, 65007864, 65007865, 65007866, 65007867, 65007868, 65007869, 65007870, 65007871, 65007872, 65007873, 65007874, 65007875, 65007876, 65007877, 65007878, 65007879, 65007880, 65007881, 65007882, 65007883, 65007884, 65007885, 65007886, 65007887, 65007888, 65007889, 65007890, 65007891, 65007892, 65007893, 65007894, 65007895, 65007896, 65007897, 65007898, 65007899, 65007900, 65007901, 65007902, 65007903, 65007904, 65007905, 65007906, 65007907, 65007908, 65007909, 65007910, 65007911, 65007912, 65007913, 65007914, 65007915, 65007916, 65007917, 65007918, 65007919, 65007920, 65007921, 65007922, 65007923, 65007924, 65007925, 65007926, 65007927, 65007928, 65007929, 65007930, 65007931, 65007932, 65007933, 65007934, 65007935, 65007936, 65007937, 65007938, 65007939, 65007940, 65007941, 65007942, 65007943, 65007944, 65007945, 65007946, 65007947, 65007948, 65007949, 65007950, 65007951, 65007952, 65007953, 65007954, 65007955, 65007956, 65007957, 65007958, 65007959, 65007960, 65007961, 65007962, 65007963, 65007964, 65007965, 65007966, 65007967, 65007968, 65007969, 65007970, 65007971, 65007972, 65007973, 65007974, 65007975, 65007976, 65007977, 65007978, 65007979, 65007980, 65007981, 65007982, 65007983, 65007984, 65007985, 65007986, 65007987, 65007988, 65007989, 65007990, 65007991, 65007992, 65007993, 65007994, 65007995, 65007996, 65007997, 65007998, 65007999, 65008000, 65008001, 65008002, 65008003, 65008004, 65008005, 65008006, 65008007, 65008008, 65008009, 65008010, 65008011, 65008012, 65008013, 65008014, 65008015, 65008016, 65008017, 65008018, 65008019, 65008020, 65008021, 65008022, 65008023, 65008024, 65008025, 65008026, 65008027, 65008028, 65008029, 65008030, 65008031, 65008032, 65008033, 65008034, 65008035, 65008036, 65008037, 65008038, 65008039, 65008040, 65008041, 65008042, 65008043, 65008044, 65008045, 65008046, 65008047, 65008048, 65008049, 65008050, 65008051, 65008052, 65008053, 65008054, 65008055, 65008056, 65008057, 65008058, 65008059, 65008060, 65008061, 65008062, 65008063, 65008064, 65008065, 65008066, 65008067, 65008068, 65008069, 65008070, 65008071, 65008072, 65008073, 65008074, 65008075, 65008076, 65008077, 65008078, 65008079, 65008080, 65008081, 65008082, 65008083, 65008084, 65008085, 65008086, 65008087, 65008088, 65008089, 65008090, 65008091, 65008092, 65008093, 65008094, 65008095, 65008096, 65008097, 65008098, 65008099, 65008100, 65008101, 65008102, 65008103, 65008104, 65008105, 65008106, 65008107, 65008108, 65008109, 65008110, 65008111, 65008112, 65008113, 65008114, 65008115, 65008116, 65008117, 65008118, 65008119, 65008120, 65008121, 65008122) and
  216. a.cod_emp = b.cod_emp and
  217. a.cod_ope = b.cod_ope and
  218. a.cen_ope = b.cen_ope and
  219. a.nro_ope = b.nro_ope
  220. left outer join genmae c on
  221. c.cod_emp = a.cod_emp and
  222. c.cod_amb = a.cod_amb and
  223. c.tip_mae = a.tip_mae and
  224. c.cod_mae = a.cod_mae
  225. inner join logcen d on
  226. d.cod_emp = a.cod_emp and
  227. d.cod_cen = a.cod_cen
  228. inner join genmae e on
  229. e.cod_emp = a.cod_emp and
  230. e.cod_amb = a.cod_amb and
  231. e.tip_mae = a.tip_tar and
  232. e.cod_mae = a.cod_tar
  233. left outer join logcma f on
  234. f.cod_emp = a.cod_emp and
  235. f.cod_amb = a.cod_amb and
  236. f.tip_mae = a.tip_tar and
  237. f.cod_tab = a.tab_gta and
  238. f.cod_aux = a.cod_gta
  239. left outer join genmae g on
  240. g.cod_emp = a.cod_emp and
  241. g.cod_amb = a.cod_amb and
  242. g.tip_mae = a.tip_bie and
  243. g.cod_mae = a.cod_bie
  244. inner join genfac h on
  245. h.cod_emp = a.cod_emp and
  246. h.cod_amb = a.cod_amb and
  247. h.tip_mae = a.tip_tar and
  248. h.cod_mae = a.cod_tar
  249. inner join logvar k on
  250. k.cod_tab = a.tab_uni and
  251. k.cod_aux = a.cod_uni
  252. where exists (
  253. select
  254. 1
  255. from adkfcaopecab x
  256. where x.cod_emp = b.cod_emp
  257. and x.cod_ope = b.cod_ope
  258. and x.cen_ope = b.cen_ope
  259. and x.nro_ope = b.nro_ope
  260. )
  261. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!