===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-111-mJh\~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:112:ir9"^r;Zm`YP7D`#&!u:)0ECXr;Quo,6.]KHeeQ!#Ke"d!&KPYqtpBnXSi,#/$AXGrrAPe!!5`f
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-113-m/-e`r\j`U#",/u]Y2klrr35I'`\8)R+VB8rrA8^!!50dq#13mW;Zc+0;JGf!*c2'#QOiaTC)%G
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-114-J,~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:115:ir9"^r;Zm`YP7D`#&!u:)0ECXr;Quo,6.]KHeeQ!#Ke"d!&KPYqtpBnXSi,#/$AXGrrAPe!!5`f
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-116-m/-e`r\j`U#",/u]Y2klrr35I'`\8)R+VB8rrA8^!!50dq#13mW;Zc+0;JGf!*c2'#QOiaTC)%G
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-117-J,~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:118:ir9"^r;Zm`YP7D`#&!u:)0ECXr;Quo,6.]KHeeQ!#Ke"d!&KPYqtpBnXSi,#/$AXGrrAPe!!5`f
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-119-m/-e`r\j`U#",/u]Y2klrr35I'`\8)R+VB8rrA8^!!50dq#13mW;Zc+0;JGf!*c2'#QOiaTC)%G
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-120-J,~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:121:ir9!rrW!$$AB4]:rs"5Y!"!2?nb`=dS,NBh.$j,rrs.$n!!"-k`r#W4!2'5j#6@lIrr<#f+T;?B
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-122-(Ojg/rrN'XrW!*U]_h^,rr2p&j<O^*0TFT]r;R#p/H>bP@Di'Brr@*=!"DfKScD]\f):FO0R_+B
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-123-mJh\~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:124:ir9!rrW!$$AB4]:rs"5Y!"!2?nb`=dS,NBh.$j,rrs.$n!!"-k`r#W4!2'5j#6@lIrr<#f+T;?B
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-125-(Ojg/rrN'XrW!*U]_h^,rr2p&j<O^*0TFT]r;R#p/H>bP@Di'Brr@*=!"DfKScD]\f):FO0R_+B
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-126-mJh\~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:127:ir9!rrW!$$AB4]:rs"5Y!"!2?nb`=dS,NBh.$j,rrs.$n!!"-k`r#W4!2'5j#6@lIrr<#f+T;?B
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-128-(Ojg/rrN'XrW!*U]_h^,rr2p&j<O^*0TFT]r;R#p/H>bP@Di'Brr@*=!"DfKScD]\f):FO0R_+B
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-183-!#JL91B7C^04^Qmo)&Ffm1B6s"\,rboD&=UrrLONrW!!jWU\pHJ,~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:184:jo5A$!r`0$<5&5%rs!9>Fi41XE;fh=&Wc;KrrLgZrW!!u`W#`6"18+U,Q7ZE7CDsdrsd.Z"onWD
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-185-1JDG:W6+9$qYpTT$N:#+9#pB"!0@*Z!Y0J%huA3~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:186:jo5A$!r`0$<5&5%rs!9>Fi41XE;fh=&Wc;KrrLgZrW!!u`W#`6"18+U,Q7ZE7CDsdrsd.Z"onWD
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-187-1JDG:W6+9$qYpTT$N:#+9#pB"!0@*Z!Y0J%huA3~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:188:jo5A$!r`0$<5&5%rs!9>Fi41XE;fh=&Wc;KrrLgZrW!!u`W#`6"18+U,Q7ZE7CDsdrsd.Z"onWD
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-189-1JDG:W6+9$qYpTT$N:#+9#pB"!0@*Z!Y0J%huA3~>
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-223-lMgtbn!k$f!!+E:r_iqn7Q_h#qu?g$BZU2NrrAJa!!rrB%KZV1146=dr;QfL(&7h>$<3GCs3q/O
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:224:!!*?SU;Zj*rrN!hq#CO36$'$cp&>'8&c2P7%1`aF!"iA$an>W4#0[,K!"=>2h>`!~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-225-lMgtbn!ase!!+E:r_iqn7Q_h#qu?g$BZU2NrrAJa!!rrB%KZV1146=dr;QfL(&7h>$<3GCs3q/O
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:226:!!*?SU;Zj*rrN!hq#CO36$'$cp&>'8&c2P7%1`aF!"iA$an>W4#0[,K!"450h>`!~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-227-lMgtbn!apd!!suB;H$Lf7Q_h#qu?g$BZU2NrrAJa!!rrB%KZV1146=dr;QfL(&7h>$<3GCs3q/O
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:228:!!*?SU;Zj*rrN!hq#CO36$'$cp&>'8&c2P7%1`aF!"iA$an>W4#0[,K!"450h>`!~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-229-m/I1T;*Gub!!4."iqiZUEs2=>"U6JiT?[*+rrKYLqZ$jKCo6%fs6LI!!!=Np](,[t!O)b$!!<j/
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-256-7n#[/9ldH'lMlA~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:257:nc'a'W-`l@JUi,nI=mH=P*1l_Jpr3#JUi5uI"@$1PEj&Zo`#-kc(BrFI=:a:#(V8NF+ga`q>UKl
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-258-qtpC)HiX3o8n<:!J:;icA5bW?'`7q5*/(WZq>Ucj]Uk7<H@16mIf=cpIK=qKrdOiprd=`os*b0"
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-259-H$Y(2`9upjJ,~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:260:o)Aa@/H#PY)c;3c`Rj,4lK[Wi_MUGK!!-$Ho)Amfl,o)T"S;Zt(M]ktnGVqX#*T#e)g@&do`+sq
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-261-rW!$9U@A-Vrrr8kmb=9Wp](a80MZ;.MNjBlOagh$%f-/,++rkFs*t~>
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-271-9)hNi8QKRH!!!_)p@A4bdoo6<8d@q%T#]RIm-t#F#Oq!2]8Tl[8H)3a76tFtrU0]9~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:272:oD]3lP^.e0Irp:Jh":R@rrr/U[u5W`qg\cuHG9CJrri,W]oIR9J-1:CV<dXN$0`-(!(sHdhhlm\
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-273-JGt**K6h>S!!!_)p@J:drRm'Vqg\p$G+->$jm2C7nH\LEf>!u4H[l$F"FYTWb51Q+J,~>
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-345-lMgn)H2N0oI=T`5rrVP@If+]tIs\s&s*t~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:346:pAY0a(\n%3%]8Lj!ntEWmf*FF#67oMrVll5q>^RH`W#B,$&8K`BuU)Os8"GI!!3:ZlK\BLNVWVU
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-347-A(L)J!QG6<!!,m9o`'F~>
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-365-&,H8-4Jq]As*t~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:366:o`"up6V.#F"@YU\T\\<$"JItRN9:'<!r[4-rCR/`9;2"LrrrCG5?*X%r;Qet5lF:V7UsC%rrK8f
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-367-r(7#]FOT^Y!pEQQr(7&^>bU`\s*t~>
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-371-CAIo4$Za>fo`'F~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:372:o`#$mT0c-E8d%RL:m0Yhrre9E;3pVHrrKf#r(7#ZFklTg"kH78B=%F3rrV(Q8H)3`7p<=tli.!g
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-373-5l=4U89E>LrrJBMr(7)`9QnJUo`'F~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:374:o`#$l\9`Z"J-::IK<O=irrfKMGa@^nrrLJnr."itMV@\%"lb&]FKkT=rrVD:J,Om!HF!G6rrL,b
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-375-r."isJC3ic!O[4NJ-:FMH,fjUs*t~>
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-413-74B#[!rW*(!Xfhp4]Pf(rW!$%0pD(ps*t~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:414:li.1ceX0`66qHuC"%GUteE[&:Ps.cjh"UgMa$iSu8chJ9kP>,]gdt"M[JBUt!oZpGr^m8`;l9*O
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-415-rrK8fqaq*1Q&9E`;G9X[7h/*a;-7:FG#^q&8P3["nF-C-~>
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-455-rrLpdqZ$[>_>X-.J,~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:456:h#@KO\Q_Ds8cqOg`r>Q/"eInJA\S09rrK`!rC[)]$'t&[s/\IV?)7&`rrW")7fH!^8P4`tmJd3i
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-457-5l=4U89E>HrrV=^8,Z$^7p*S)p]#a~>
##############################################
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-513-r."isJC3Z^!Np_FJ-(1Ia8#[b~>
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps:514:pAY+_r;Zk4nEBlQpaQ+@!`$Q0p&>6l-NF,UNpH06!+u*.!_T`lmf*9GqZ$[!HgL5$!.t%I!Fs^H
ledgersmb-1.6.9+ds/UI/images/ledgersmb.eps-515-rrM^3q#CG.e+irn~>
##############################################
ledgersmb-1.6.9+ds/UI/images/logo.eps-175-iW"E~>
ledgersmb-1.6.9+ds/UI/images/logo.eps:176:g&M%j!1`BT#40[N\\?AUnc&dPaLoOEqYpKpSGmL$rs&J\a1TFDqsFCfm*EGW^<Z*5rrr;T`4EY=
ledgersmb-1.6.9+ds/UI/images/logo.eps-177-iW"E~>
##############################################
ledgersmb-1.6.9+ds/UI/images/logo.eps-237-g&M%j!1`W[!-.FGrVlt?E,_<?rrAMeE;TY;Ec>udpAY,]rc%c7!-.FGqu?Y7!1_^AJ,~>
ledgersmb-1.6.9+ds/UI/images/logo.eps:238:g&M%3!-[r5"$S_*E:*Z-76*AEpAY,.r]0lU"%P@3C%hQ,B`:$hrrYGF3H4<ar]'t%f`-I~>
ledgersmb-1.6.9+ds/UI/images/logo.eps-239-g&M%)!,qH."#V_bC$kp&4"i6upAY,&r\+0K"$S@k@eTg%@K%qWrrY,3059bPr\"7if`-I~>
ledgersmb-1.6.9+ds/UI/images/logo.eps:240:g&M%j!1`W["*AL$R-jnUG]7VepAY,Wrc%c7"+"p*PP5"VP5]Ftrr[@^E1#tkrbqk-f`-I~>
ledgersmb-1.6.9+ds/UI/images/logo.eps-241-g&M%3!-[r5"&M!<@I='s;E6aApAY+rr]0lU"'7KC;>1"i;#WKPrrZ(X3FV7Rr]'t%f`-I~>
##############################################
ledgersmb-1.6.9+ds/UI/images/logo.eps-253-f`-I~>
ledgersmb-1.6.9+ds/UI/images/logo.eps:254:g&M%j!1`W["n$DME/XY_rrD-ZDuc:#rrAA`E;TY=noJbhJGK'A!Vq9EE;TY=mW*8cMu;uBrbqk-
ledgersmb-1.6.9+ds/UI/images/logo.eps-255-f`-I~>
##############################################
ledgersmb-1.6.9+ds/UI/images/logo.eps-265-r\+-J!UrVY0*,M/qYpZdY$E^Ws8FYODqP)?~>
ledgersmb-1.6.9+ds/UI/images/logo.eps:266:g&M%j!1`TZ!VM!BDul-[qYpZia,b3:rrq4uE,]m;rVm$"`H-!>rc%`6!V:[;E!_BHoD\@,M/[Zq
ledgersmb-1.6.9+ds/UI/images/logo.eps-267-rc%`6!VM!BDul-[qYpZia,b39s8Hs;SCmjl~>
##############################################
ledgersmb-1.6.9+ds/UI/images/logo.eps-372-PlCp;"p"`.[IX>"C`VrNrYtpbqYp]S,@(5JrYtopci8L~>
ledgersmb-1.6.9+ds/UI/images/logo.eps:373:PQ(X^rVZ`qo`#'m,s_LRrXf.:qu6it80$[iBDrJC`:s93Oo>=\HMd^Gi=,be-hHX'J,~>
ledgersmb-1.6.9+ds/UI/images/logo.eps-374-PQ(WHrW*$*]Cc++rf!?HjSj`2fDGROrh##9s0)ER!9!VO!0R6\!.+PB"lTmj!%7C's*t~>
##############################################
ledgersmb-1.6.9+ds/UI/images/logo.eps-412-R/d-`qu6`srVcQl!bW+9qu6a_&J9HgrrD$W&HGArrrr'$!!!E)qu6]rCAn25HKY<Y~>
ledgersmb-1.6.9+ds/UI/images/logo.eps:413:RK!9RrW*$Uh>R?Vl9YL_fD>LKYCb!qrr\^AK"Lp[!:To=!2'#c"n`-$!"8`%rrN+6rVuqEkPp&~>
ledgersmb-1.6.9+ds/UI/images/logo.eps-414-RK!9RrW*$Uh>R?Vl9YL_fD>LKDB,DJrrYe3*/".g!9=%u!)^r>J,~>
##############################################
ledgersmb-1.6.9+ds/UI/images/logo.eps-419-RK*<drr<#trr)lrq>UTk<"T_'qu6_=&]XbK!r]29rXf0$qYC-li[+O'$<Oj`^meI4!!"RYjo9i~>
ledgersmb-1.6.9+ds/UI/images/logo.eps:420:RK!\eMuWhBP!fi`(eUCrqYp]pV1O<;qu6`*K&QY-!rgZ%rdk0BrV?Hoi[+O'$<Oj`^meI4!!"RY
ledgersmb-1.6.9+ds/UI/images/logo.eps-421-jo9i~>
##############################################
ledgersmb-1.6.9+ds/bin/delete-company-database-13-cmd="select rolname FROM pg_roles WHERE rolname LIKE 'lsmb_${1}__%';"
ledgersmb-1.6.9+ds/bin/delete-company-database:14:company_roles=`su -c "psql -U postgres -t -c \"$cmd\"" postgres`
ledgersmb-1.6.9+ds/bin/delete-company-database-15-
##############################################
ledgersmb-1.6.9+ds/bin/patch-release-upgrade-10-my $user;
ledgersmb-1.6.9+ds/bin/patch-release-upgrade:11:my $script_name = `basename $0`; chomp $script_name;
ledgersmb-1.6.9+ds/bin/patch-release-upgrade-12-my $usage = qq|
##############################################
ledgersmb-1.6.9+ds/bin/diagnose-2-
ledgersmb-1.6.9+ds/bin/diagnose:3:scriptpath=`readlink -f "$0"`
ledgersmb-1.6.9+ds/bin/diagnose-4-clear;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34922- DELETE FROM account_translation
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:34923: WHERE trans_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34924- AND language_code = $2;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34934- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:34935:SELECT * FROM account WHERE accno = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34936-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34947-SELECT * FROM account
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:34948:WHERE id IN (SELECT account_id FROM account_link WHERE description = $1);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34949-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34959- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:34960: select * from account where accno = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34961-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34986- JOIN account ON account.id = c2a.chart_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:34987: WHERE accno = $1; </pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-34988-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35007- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:35008: SELECT * FROM account_translation WHERE trans_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35009-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35215- ON (c.id = l.account_id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:35216: where id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35217-group by c.id, c.accno, c.description, c.category,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35299- DELETE FROM account_heading_translation
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:35300: WHERE trans_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35301- AND language_code = $2;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35321- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:35322: SELECT * FROM account_heading_translation WHERE trans_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35323-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35878- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:35879:SELECT * FROM lsmb_group_grants WHERE group_name = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-35880-ORDER BY granted_role;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36376- from generate_subscripts($2,1) as i
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36377: where $2[i] = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36378- order by i
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36391- from generate_subscripts($2,1) as i
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36392: where $2[i] = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36393- order by i
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36419- SELECT currval('mfg_lot_id_seq')::int, parts_id, qty * $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36420: FROM assembly WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36421-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36616-SELECT * from asset_dep_method
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36617:WHERE id = (select method from asset_class where id = $1);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36618-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36783- LEFT JOIN asset_report r ON (l.report_id = r.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36784: WHERE ai.id = ANY($1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36785- GROUP BY ai.id, ai.start_depreciation, ai.purchase_date, ai.purchase_value,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36787-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36788: UPDATE asset_report SET report_class = 1 WHERE id = $3;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36789-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36821- LEFT JOIN asset_report r ON (l.report_id = r.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36822: WHERE ai.id = ANY($1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36823- GROUP BY ai.id, ai.start_depreciation, ai.purchase_date, ai.purchase_value,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36825-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36826: UPDATE asset_report SET report_class = 1 WHERE id = $3;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36827-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36862- LEFT JOIN asset_report r ON (l.report_id = r.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36863: WHERE ai.id = ANY($1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36864- GROUP BY ai.id, ai.start_depreciation, ai.purchase_date, ai.purchase_value,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36866-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:36867: UPDATE asset_report SET report_class = 1 WHERE id = $3;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-36868-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37168- JOIN asset_item ON (asset_report_line.asset_id = asset_item.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37169: WHERE asset_report.id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37170-GROUP BY asset_report.id, asset_report.report_date;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37237-LEFT JOIN asset_report ar ON (arl.report_id = ar.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37238: WHERE COALESCE(ai.start_depreciation, ai.purchase_date) <= $3 AND ac.id = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37239- AND obsolete_by IS NULL
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37308- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37309:select * from asset_report where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37310-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37412-LEFT JOIN asset_report pr ON (prl.report_id = pr.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37413: WHERE rl.report_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37414- GROUP BY ai.tag, ai.start_depreciation, ai.purchase_value, m.short_name,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37449- SET obsolete_by = -1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37450: WHERE tag = $2 and $17 is true;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37451-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37479- approved_at = now()
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37480: where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37481-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37482:select * from asset_report where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37483-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37570- ON ((arld.report_id, arld.asset_id) = (l.report_id, l.asset_id))
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37571: WHERE ar.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37572-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37637- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37638:SELECT * FROM batch WHERE id = $1 FOR UPDATE;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37639-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37724-UPDATE batch SET locked_by = NULL
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37725: WHERE id = $1 AND locked_by IN (select session_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37726- from "session" s
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37829- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37830:SELECT id FROM batch_class WHERE class = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37831-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37976- set approved_at = now(), approved_by = person__get_my_entity_id()
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37977: WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37978-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37992- JOIN budget_info bi ON bi.id = b2bu.budget_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:37993: WHERE bi.id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-37994- ORDER BY bu.class_id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38010- JOIN account a ON a.id = l.account_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38011: where budget_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38012-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38029- LEFT JOIN entity oe ON bi.obsolete_by = oe.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38030: where bi.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38031-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38041- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38042:SELECT * FROM budget_note WHERE ref_key = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38043- ORDER BY created;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38055- set obsolete_by = person__get_my_entity_id(), obsolete_at = now()
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38056: WHERE id = $1 and approved_by is not null;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38057-SELECT budget__get_info($1)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38192- LEFT JOIN entity oe ON bi.obsolete_by = oe.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38193: WHERE (start_date = $1 or $1 is null) AND ($2 = end_date or $2 is null)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38194- AND ($3 BETWEEN start_date AND end_date or $2 is null)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38229- AND a.id = b.account_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38230: WHERE bi.id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38231- GROUP BY act.accno, act.description, act.id, b.description, b.amount
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38252-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38253: <pre> SELECT * FROM business_unit where id = $1; </pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38254-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38316- FROM business_unit_class bc
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38317: WHERE (active = $1 OR $1 IS NULL)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38318- AND (id IN (select bu_class_id
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38320- JOIN lsmb_module mod ON mod.id = bcm.module_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38321: WHERE lower(label) = lower($2))
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38322- OR $2 is null)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38374- <pre> SELECT * FROM lsmb_module
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38375: WHERE id IN (select module_id from bu_class_to_module where bu_class_id = $1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38376- ORDER BY id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38422- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38423:DELETE FROM bu_class_to_module WHERE bu_class_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38424-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38438-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38439: <pre> SELECT * FROM business_unit WHERE id = $1; </pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38440-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38758- JOIN parts p ON p.id = i.parts_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38759: WHERE i.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38760-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38762- SET allocated = allocated + retval
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:38763: WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-38764-ELSE -- reversal
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39045- JOIN entity e ON e.id = c.entity_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39046: WHERE entity_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39047-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39059- FROM entity_credit_account
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39060: WHERE entity_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39061- AND entity_class = $2;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39076- JOIN entity e ON e.id = c.entity_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39077: WHERE e.control_code = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39078-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39477- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39478:SELECT * FROM payroll_deduction WHERE entity_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39479-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39488- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39489:SELECT * FROM payroll_deduction_type where country_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39490-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39526- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39527:SELECT * FROM account WHERE contra AND category = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39528-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39806-SELECT * FROM entity_credit_account
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39807: WHERE entity_class = $2 AND meta_number = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39808-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39843- JOIN entity_credit_account eca ON pc.credit_id = eca.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39844: WHERE pc.credit_id = $1 AND eca.entity_class = 2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39845- UNION
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39851- JOIN entity_credit_account eca ON pv.credit_id = eca.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39852: WHERE pv.credit_id = $1 and eca.entity_class = 1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39853- ORDER BY partnumber, validfrom
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39870- JOIN entity_credit_account eca ON pc.pricegroup_id = eca.pricegroup_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39871: WHERE eca.id = $1 AND eca.entity_class = 2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39872-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39881- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39882:select * from eca_tax where eca_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39883-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39903- and l.description = 'AR'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39904: where $16 = 2 and $13 = 'i'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39905- GROUP BY 1, 2, 3, 4, 5, 6, 7
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39914- and l.description = 'AP'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39915: where $16 = 1 and $13 = 'i'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39916- GROUP BY 1, 2, 3, 4, 5, 6, 7
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39931- FROM (select * from entity_credit_account
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39932: where meta_number = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39933- UNION
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39942- from oe
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39943: where ($16= 1 and oe.oe_class_id = 2 and $13 = 'o'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39944- and quotation is not true)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39949- from oe
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:39950: where ($16= 2 and oe.oe_class_id = 1 and $13 = 'o'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-39951- and quotation is not true)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40411- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:40412: DELETE FROM eca_tax WHERE eca_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40413- INSERT INTO eca_tax (eca_id, chart_id)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40506-LEFT JOIN person mp ON ee.manager_id = p.entity_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:40507: WHERE p.entity_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40508-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40516- <p> Returns username, user_id, etc. information if the employee is a user.</p>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:40517: <pre>SELECT * FROM users WHERE entity_id = $1;</pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40518-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40719- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:40720:SELECT * FROM entity_bank_account WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40721-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40920- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:40921:SELECT * FROM entity_credit_account WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-40922-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41024- FROM account_checkpoint
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41025: WHERE end_date >= $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41026- GROUP BY end_date
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41032-SELECT CASE WHEN (SELECT count(*) > 0 from account_checkpoint
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41033: where end_date = $1 - 1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41034- THEN true
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41419- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41420:SELECT * FROM file_base where id = $1 and file_class = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41421-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41438- JOIN entity e ON f.uploaded_by = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41439: WHERE f.ref_key = $1 and f.file_class = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41440- AND m.invoice_include
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41459-select * from mime_type
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41460: where ($1 IS NULL OR id = $1) AND ($2 IS NULL OR mime_type = $2);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41461-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41478- JOIN entity e ON f.uploaded_by = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41479: WHERE f.ref_key = $1 and f.file_class = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41480-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41489- <p> This function retrieves a list of file attachments on a specified object.</p>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41490: <pre> select * from file_links where ref_key = $1 and dest_class = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41491-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41522- where username = session_user)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41523: WHERE file_name = $3
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41524- RETURNING true as found_it
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41578- JOIN users u ON (s.users_id = u.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41579: WHERE f.session_id = $1 and f.id = $2 and u.username = SESSION_USER;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41580-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41889- ON (a.id = i.trans_id AND a.approved)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41890: WHERE ($1 IS NULL OR a.transdate >= $1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41891- AND ($2 IS NULL OR a.transdate <= $2)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41904- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41905:SELECT * FROM parts WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41906-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41915- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41916:SELECT * FROM parts WHERE obsolete is not true AND partnumber = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41917-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41938- LEFT JOIN order_sum oi ON oi.parts_id = p.id OR a.parts_id = i.parts_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41939: WHERE p.id = $1 OR p.partnumber = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41940: OR (p.id IN (select parts_id FROM makemodel WHERE barcode = $2)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41941- AND NOT EXISTS (select id from parts
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41942: where partnumber = $2 AND NOT obsolete
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41943- ))
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41961- JOIN parts p ON l.parts_id = p.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41962: WHERE l.adjust_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41963-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41980-LEFT JOIN ap ON ap.id = r.ap_trans_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:41981: WHERE r.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-41982-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42121- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42122:SELECT * FROM inventory_report WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42123-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42132- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42133:SELECT * FROM inventory_report_line l WHERE adjust_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42134- ORDER BY parts_id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42146-SELECT * FROM inventory_report
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42147: WHERE ($1 is null or transdate >= $1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42148- AND ($2 IS NULL OR transdate <= $2)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42269- SET ar_trans_id = $2, ap_trans_id = $3
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42270: WHERE id = $1 AND ar_trans_id IS NULL AND ap_trans_id IS NULL
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42271-RETURNING id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42281- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42282:DELETE FROM inventory_report_line WHERE adjust_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42283:DELETE FROM inventory_report WHERE id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42284-RETURNING id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42397- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42398:SELECT * FROM journal_entry where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42399-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42408- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42409:SELECT * FROM eca_invoice where journal_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42410-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42419- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42420:select * from journal_line where journal_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42421-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42509- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42510: SELECT sum(amount) = 0 FROM journal_line WHERE journal_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42511-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42589-UPDATE location set active = false, inactive_date = now()
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42590: WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42591-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42734-begin
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42735: SELECT locked_by into locked from transactions where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42736- IF NOT FOUND THEN
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42740- END IF;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42741: UPDATE transactions set locked_by = $2 where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42742- RETURN TRUE;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42951- <p> Retrieves a single module's info by id. </p>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42952: <pre> SELECT * FROM lsmb_module where id = $1; </pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42953-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42975- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:42976:SELECT * FROM menu_generate() where parent = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-42977-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43096-BEGIN
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:43097: SELECT * INTO t_mfg_lot FROM mfg_lot WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43098- IF NOT FOUND THEN
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43106- WHERE id in (select parts_id from mfg_lot_item
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:43107: WHERE mfg_lot_id = $1);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43108-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43117- SELECT currval('id')::int, parts_id, qty, 0
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:43118: FROM mfg_lot_item WHERE mfg_lot_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43119-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43411- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:43412:select * from parts where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43413-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43422- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:43423:SELECT * FROM parts WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43424-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43433- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:43434:SELECT * FROM parts where partnumber = $1 AND NOT OBSOLETE;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43435-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43478- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:43479:SELECT * FROM gl WHERE id = (select id from payment where id = $1);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-43480-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44137- JOIN company cp ON (cp.entity_id = e.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:44138: WHERE ec.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44139-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44719- FROM payroll_deduction_type
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:44720: where (account_id = $1 OR $1 IS NULL) AND
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44721- (pdc_id = $2 OR $2 IS NULL) AND
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44745- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:44746:SELECT * FROM payroll_income_class where country_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44747-ORDER BY label;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44757- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:44758:SELECT * FROM payroll_income_type WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44759-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44807- FROM payroll_income_type
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:44808: where (account_id = $1 OR $1 IS NULL) AND
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44809- (pic_id = $2 OR $2 IS NULL) AND
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44873- JOIN person p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:44874: WHERE e.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44875-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44890- JOIN person p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:44891: WHERE e.control_code = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-44892-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45230-WITH gl (id) AS
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45231: ( SELECT id FROM ap WHERE approved is true AND entity_credit_account = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45232-UNION ALL
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45233: SELECT id FROM ar WHERE approved is true AND entity_credit_account = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45234-)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45336- SELECT id, null, row(array[id])::tree_record FROM business_unit
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45337: WHERE id = any($4)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45338- UNION ALL
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45459- SELECT id, null, row(array[id])::tree_record FROM business_unit
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45460: WHERE id = any($4)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45461- UNION ALL
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45470- FROM cash_impact ca
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45471: WHERE ($1 IS NULL OR ca.transdate >= $1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45472- AND ($2 IS NULL OR ca.transdate <= $2)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45586- FROM acc_trans ac
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45587: WHERE ac.approved AND ac.trans_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45588- GROUP BY ac.chart_id
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45682- SELECT id, null, row(array[id])::tree_record FROM business_unit
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45683: WHERE id = any($4)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45684- UNION ALL
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45697- GROUP BY entry_id) bui ON bui.entry_id = i.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45698: WHERE i.parts_id = $3
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45699- AND (ac.transdate >= $1 OR $1 IS NULL)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45715- GROUP BY entry_id) bui ON bui.entry_id = i.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45716: WHERE i.parts_id = $3
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45717- AND (ac.transdate >= $1 OR $1 IS NULL)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45805- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45806:delete from partscustomer where entry_id = $1 and credit_id = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:45807:delete from partsvendor where entry_id = $1 and credit_id = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-45808-select true;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-46164- UNION SELECT id::text FROM gl WHERE approved IS FALSE AND transdate < $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:46165: UNION SELECT DISTINCT source FROM acc_trans WHERE approved IS FALSE AND transdate < $1 AND chart_id = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-46166- ) tx
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-46170- FROM cr_report
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:46171: WHERE end_date < $1 AND approved IS NOT TRUE AND chart_id = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-46172-)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-46235- ) g ON g.id = ac.trans_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:46236: WHERE c.id = $1 AND cleared
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-46237- AND ac.approved IS true
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-46812- JOIN tx_report t ON t.approved AND t.id = ac.trans_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:46813: WHERE ac.transdate <= coalesce($1, (select max(transdate) from acc_trans))
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-46814- GROUP BY ac.chart_id
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47283- JOIN robot p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:47284: WHERE e.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47285-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47299- JOIN robot p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:47300: WHERE e.control_code = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47301-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47403- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:47404:DELETE FROM lsmb_sequence where label = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47405-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47416- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:47417:SELECT * FROM lsmb_sequence WHERE label = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47418-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47464- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:47465:SELECT * FROM lsmb_sequence where setting_key = $1 order by label;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47466-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47609- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:47610:SELECT * FROM defaults WHERE setting_key = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47611-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47661- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:47662:SELECT * FROM country_tax_form where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-47663-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48030-SELECT * FROM template
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:48031: WHERE template_name = $1 AND format = $3 AND
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48032- language_code IS NOT DISTINCT FROM $2;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48042- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:48043:SELECT * FROM template WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48044-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48166- WHERE id in (select business_unit_id from jcitems
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:48167: WHERE id = $1));
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48168-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48176-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:48177: <pre> SELECT * FROM jcitems WHERE id = $1; </pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48178-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48294-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:48295:SELECT * FROM jctype where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48296-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48899- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:48900:SELECT * FROM payroll_wage WHERE entity_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48901-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48910- <pre>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html:48911:SELECT * FROM payroll_income_type where country_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.html-48912-</pre>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35204- DELETE FROM account_translation
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:35205: WHERE trans_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35206- AND language_code = $2;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35234- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:35235:SELECT * FROM account WHERE accno = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35236-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35265-SELECT * FROM account
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:35266:WHERE id IN (SELECT account_id FROM account_link WHERE description = $1);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35267-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35295- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:35296: select * from account where accno = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35297-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35358- JOIN account ON account.id = c2a.chart_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:35359: WHERE accno = $1; </programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35360- </para>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35415- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:35416: SELECT * FROM account_translation WHERE trans_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35417-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35731- ON (c.id = l.account_id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:35732: where id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35733-group by c.id, c.accno, c.description, c.category,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35887- DELETE FROM account_heading_translation
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:35888: WHERE trans_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35889- AND language_code = $2;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35945- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:35946: SELECT * FROM account_heading_translation WHERE trans_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-35947-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-36862- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:36863:SELECT * FROM lsmb_group_grants WHERE group_name = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-36864-ORDER BY granted_role;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-37558- from generate_subscripts($2,1) as i
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:37559: where $2[i] = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-37560- order by i
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-37591- from generate_subscripts($2,1) as i
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:37592: where $2[i] = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-37593- order by i
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-37655- SELECT currval('mfg_lot_id_seq')::int, parts_id, qty * $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:37656: FROM assembly WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-37657-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-37996-SELECT * from asset_dep_method
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:37997:WHERE id = (select method from asset_class where id = $1);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-37998-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38307- LEFT JOIN asset_report r ON (l.report_id = r.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:38308: WHERE ai.id = ANY($1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38309- GROUP BY ai.id, ai.start_depreciation, ai.purchase_date, ai.purchase_value,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38311-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:38312: UPDATE asset_report SET report_class = 1 WHERE id = $3;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38313-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38363- LEFT JOIN asset_report r ON (l.report_id = r.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:38364: WHERE ai.id = ANY($1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38365- GROUP BY ai.id, ai.start_depreciation, ai.purchase_date, ai.purchase_value,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38367-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:38368: UPDATE asset_report SET report_class = 1 WHERE id = $3;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38369-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38422- LEFT JOIN asset_report r ON (l.report_id = r.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:38423: WHERE ai.id = ANY($1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38424- GROUP BY ai.id, ai.start_depreciation, ai.purchase_date, ai.purchase_value,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38426-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:38427: UPDATE asset_report SET report_class = 1 WHERE id = $3;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38428-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38890- JOIN asset_item ON (asset_report_line.asset_id = asset_item.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:38891: WHERE asset_report.id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38892-GROUP BY asset_report.id, asset_report.report_date;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38995-LEFT JOIN asset_report ar ON (arl.report_id = ar.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:38996: WHERE COALESCE(ai.start_depreciation, ai.purchase_date) <= $3 AND ac.id = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-38997- AND obsolete_by IS NULL
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39102- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:39103:select * from asset_report where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39104-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39296-LEFT JOIN asset_report pr ON (prl.report_id = pr.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:39297: WHERE rl.report_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39298- GROUP BY ai.tag, ai.start_depreciation, ai.purchase_value, m.short_name,
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39369- SET obsolete_by = -1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:39370: WHERE tag = $2 and $17 is true;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39371-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39417- approved_at = now()
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:39418: where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39419-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:39420:select * from asset_report where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39421-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39562- ON ((arld.report_id, arld.asset_id) = (l.report_id, l.asset_id))
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:39563: WHERE ar.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39564-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39683- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:39684:SELECT * FROM batch WHERE id = $1 FOR UPDATE;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39685-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39806-UPDATE batch SET locked_by = NULL
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:39807: WHERE id = $1 AND locked_by IN (select session_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39808- from "session" s
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39965- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:39966:SELECT id FROM batch_class WHERE class = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-39967-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40220- set approved_at = now(), approved_by = person__get_my_entity_id()
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40221: WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40222-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40254- JOIN budget_info bi ON bi.id = b2bu.budget_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40255: WHERE bi.id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40256- ORDER BY bu.class_id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40290- JOIN account a ON a.id = l.account_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40291: where budget_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40292-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40327- LEFT JOIN entity oe ON bi.obsolete_by = oe.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40328: where bi.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40329-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40357- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40358:SELECT * FROM budget_note WHERE ref_key = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40359- ORDER BY created;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40389- set obsolete_by = person__get_my_entity_id(), obsolete_at = now()
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40390: WHERE id = $1 and approved_by is not null;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40391-SELECT budget__get_info($1)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40616- LEFT JOIN entity oe ON bi.obsolete_by = oe.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40617: WHERE (start_date = $1 or $1 is null) AND ($2 = end_date or $2 is null)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40618- AND ($3 BETWEEN start_date AND end_date or $2 is null)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40671- AND a.id = b.account_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40672: WHERE bi.id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40673- GROUP BY act.accno, act.description, act.id, b.description, b.amount
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40730-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40731: <programlisting> SELECT * FROM business_unit where id = $1; </programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40732- </para>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40848- FROM business_unit_class bc
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40849: WHERE (active = $1 OR $1 IS NULL)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40850- AND (id IN (select bu_class_id
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40852- JOIN lsmb_module mod ON mod.id = bcm.module_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40853: WHERE lower(label) = lower($2))
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40854- OR $2 is null)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40942- <programlisting> SELECT * FROM lsmb_module
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:40943: WHERE id IN (select module_id from bu_class_to_module where bu_class_id = $1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-40944- ORDER BY id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41026- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:41027:DELETE FROM bu_class_to_module WHERE bu_class_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41028-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41060-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:41061: <programlisting> SELECT * FROM business_unit WHERE id = $1; </programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41062- </para>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41542- JOIN parts p ON p.id = i.parts_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:41543: WHERE i.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41544-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41546- SET allocated = allocated + retval
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:41547: WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41548-ELSE -- reversal
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41919- JOIN entity e ON e.id = c.entity_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:41920: WHERE entity_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41921-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41951- FROM entity_credit_account
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:41952: WHERE entity_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41953- AND entity_class = $2;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41986- JOIN entity e ON e.id = c.entity_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:41987: WHERE e.control_code = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-41988-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-42657- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:42658:SELECT * FROM payroll_deduction WHERE entity_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-42659-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-42686- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:42687:SELECT * FROM payroll_deduction_type where country_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-42688-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-42760- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:42761:SELECT * FROM account WHERE contra AND category = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-42762-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43238-SELECT * FROM entity_credit_account
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43239: WHERE entity_class = $2 AND meta_number = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43240-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43311- JOIN entity_credit_account eca ON pc.credit_id = eca.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43312: WHERE pc.credit_id = $1 AND eca.entity_class = 2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43313- UNION
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43319- JOIN entity_credit_account eca ON pv.credit_id = eca.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43320: WHERE pv.credit_id = $1 and eca.entity_class = 1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43321- ORDER BY partnumber, validfrom
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43356- JOIN entity_credit_account eca ON pc.pricegroup_id = eca.pricegroup_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43357: WHERE eca.id = $1 AND eca.entity_class = 2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43358-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43385- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43386:select * from eca_tax where eca_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43387-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43425- and l.description = 'AR'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43426: where $16 = 2 and $13 = 'i'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43427- GROUP BY 1, 2, 3, 4, 5, 6, 7
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43436- and l.description = 'AP'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43437: where $16 = 1 and $13 = 'i'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43438- GROUP BY 1, 2, 3, 4, 5, 6, 7
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43453- FROM (select * from entity_credit_account
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43454: where meta_number = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43455- UNION
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43464- from oe
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43465: where ($16= 1 and oe.oe_class_id = 2 and $13 = 'o'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43466- and quotation is not true)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43471- from oe
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:43472: where ($16= 2 and oe.oe_class_id = 1 and $13 = 'o'
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-43473- and quotation is not true)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-44113- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:44114: DELETE FROM eca_tax WHERE eca_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-44115- INSERT INTO eca_tax (eca_id, chart_id)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-44280-LEFT JOIN person mp ON ee.manager_id = p.entity_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:44281: WHERE p.entity_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-44282-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-44308- Returns username, user_id, etc. information if the employee is a user.
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:44309: <programlisting>SELECT * FROM users WHERE entity_id = $1;</programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-44310- </para>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-44673- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:44674:SELECT * FROM entity_bank_account WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-44675-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45072- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:45073:SELECT * FROM entity_credit_account WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45074-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45266- FROM account_checkpoint
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:45267: WHERE end_date >= $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45268- GROUP BY end_date
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45274-SELECT CASE WHEN (SELECT count(*) > 0 from account_checkpoint
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:45275: where end_date = $1 - 1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45276- THEN true
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45859- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:45860:SELECT * FROM file_base where id = $1 and file_class = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45861-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45896- JOIN entity e ON f.uploaded_by = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:45897: WHERE f.ref_key = $1 and f.file_class = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45898- AND m.invoice_include
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45935-select * from mime_type
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:45936: where ($1 IS NULL OR id = $1) AND ($2 IS NULL OR mime_type = $2);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45937-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45972- JOIN entity e ON f.uploaded_by = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:45973: WHERE f.ref_key = $1 and f.file_class = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-45974-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46001- This function retrieves a list of file attachments on a specified object.
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46002: <programlisting> select * from file_links where ref_key = $1 and dest_class = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46003-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46070- where username = session_user)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46071: WHERE file_name = $3
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46072- RETURNING true as found_it
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46162- JOIN users u ON (s.users_id = u.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46163: WHERE f.session_id = $1 and f.id = $2 and u.username = SESSION_USER;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46164-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46725- ON (a.id = i.trans_id AND a.approved)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46726: WHERE ($1 IS NULL OR a.transdate >= $1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46727- AND ($2 IS NULL OR a.transdate <= $2)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46758- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46759:SELECT * FROM parts WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46760-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46787- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46788:SELECT * FROM parts WHERE obsolete is not true AND partnumber = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46789-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46828- LEFT JOIN order_sum oi ON oi.parts_id = p.id OR a.parts_id = i.parts_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46829: WHERE p.id = $1 OR p.partnumber = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46830: OR (p.id IN (select parts_id FROM makemodel WHERE barcode = $2)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46831- AND NOT EXISTS (select id from parts
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46832: where partnumber = $2 AND NOT obsolete
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46833- ))
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46869- JOIN parts p ON l.parts_id = p.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46870: WHERE l.adjust_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46871-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46906-LEFT JOIN ap ON ap.id = r.ap_trans_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:46907: WHERE r.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-46908-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47119- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47120:SELECT * FROM inventory_report WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47121-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47148- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47149:SELECT * FROM inventory_report_line l WHERE adjust_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47150- ORDER BY parts_id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47180-SELECT * FROM inventory_report
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47181: WHERE ($1 is null or transdate >= $1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47182- AND ($2 IS NULL OR transdate <= $2)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47411- SET ar_trans_id = $2, ap_trans_id = $3
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47412: WHERE id = $1 AND ar_trans_id IS NULL AND ap_trans_id IS NULL
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47413-RETURNING id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47441- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47442:DELETE FROM inventory_report_line WHERE adjust_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47443:DELETE FROM inventory_report WHERE id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47444-RETURNING id;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47701- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47702:SELECT * FROM journal_entry where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47703-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47730- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47731:SELECT * FROM eca_invoice where journal_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47732-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47759- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47760:select * from journal_line where journal_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47761-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47921- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:47922: SELECT sum(amount) = 0 FROM journal_line WHERE journal_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-47923-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48073-UPDATE location set active = false, inactive_date = now()
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:48074: WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48075-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48326-begin
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:48327: SELECT locked_by into locked from transactions where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48328- IF NOT FOUND THEN
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48332- END IF;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:48333: UPDATE transactions set locked_by = $2 where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48334- RETURN TRUE;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48777- Retrieves a single module's info by id.
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:48778: <programlisting> SELECT * FROM lsmb_module where id = $1; </programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48779- </para>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48837- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:48838:SELECT * FROM menu_generate() where parent = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-48839-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49012-BEGIN
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:49013: SELECT * INTO t_mfg_lot FROM mfg_lot WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49014- IF NOT FOUND THEN
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49022- WHERE id in (select parts_id from mfg_lot_item
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:49023: WHERE mfg_lot_id = $1);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49024-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49033- SELECT currval('id')::int, parts_id, qty, 0
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:49034: FROM mfg_lot_item WHERE mfg_lot_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49035-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49453- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:49454:select * from parts where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49455-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49482- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:49483:SELECT * FROM parts WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49484-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49511- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:49512:SELECT * FROM parts where partnumber = $1 AND NOT OBSOLETE;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49513-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49610- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:49611:SELECT * FROM gl WHERE id = (select id from payment where id = $1);
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-49612-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-50449- JOIN company cp ON (cp.entity_id = e.id)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:50450: WHERE ec.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-50451-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51265- FROM payroll_deduction_type
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:51266: where (account_id = $1 OR $1 IS NULL) AND
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51267- (pdc_id = $2 OR $2 IS NULL) AND
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51327- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:51328:SELECT * FROM payroll_income_class where country_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51329-ORDER BY label;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51357- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:51358:SELECT * FROM payroll_income_type WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51359-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51443- FROM payroll_income_type
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:51444: where (account_id = $1 OR $1 IS NULL) AND
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51445- (pic_id = $2 OR $2 IS NULL) AND
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51581- JOIN person p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:51582: WHERE e.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51583-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51616- JOIN person p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:51617: WHERE e.control_code = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-51618-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52172-WITH gl (id) AS
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52173: ( SELECT id FROM ap WHERE approved is true AND entity_credit_account = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52174-UNION ALL
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52175: SELECT id FROM ar WHERE approved is true AND entity_credit_account = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52176-)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52296- SELECT id, null, row(array[id])::tree_record FROM business_unit
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52297: WHERE id = any($4)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52298- UNION ALL
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52437- SELECT id, null, row(array[id])::tree_record FROM business_unit
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52438: WHERE id = any($4)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52439- UNION ALL
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52448- FROM cash_impact ca
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52449: WHERE ($1 IS NULL OR ca.transdate >= $1)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52450- AND ($2 IS NULL OR ca.transdate <= $2)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52582- FROM acc_trans ac
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52583: WHERE ac.approved AND ac.trans_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52584- GROUP BY ac.chart_id
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52696- SELECT id, null, row(array[id])::tree_record FROM business_unit
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52697: WHERE id = any($4)
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52698- UNION ALL
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52711- GROUP BY entry_id) bui ON bui.entry_id = i.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52712: WHERE i.parts_id = $3
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52713- AND (ac.transdate >= $1 OR $1 IS NULL)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52729- GROUP BY entry_id) bui ON bui.entry_id = i.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52730: WHERE i.parts_id = $3
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52731- AND (ac.transdate >= $1 OR $1 IS NULL)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52909- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52910:delete from partscustomer where entry_id = $1 and credit_id = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:52911:delete from partsvendor where entry_id = $1 and credit_id = $2;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-52912-select true;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-53430- UNION SELECT id::text FROM gl WHERE approved IS FALSE AND transdate < $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:53431: UNION SELECT DISTINCT source FROM acc_trans WHERE approved IS FALSE AND transdate < $1 AND chart_id = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-53432- ) tx
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-53436- FROM cr_report
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:53437: WHERE end_date < $1 AND approved IS NOT TRUE AND chart_id = $2
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-53438-)
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-53555- ) g ON g.id = ac.trans_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:53556: WHERE c.id = $1 AND cleared
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-53557- AND ac.approved IS true
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-54420- JOIN tx_report t ON t.approved AND t.id = ac.trans_id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:54421: WHERE ac.transdate <= coalesce($1, (select max(transdate) from acc_trans))
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-54422- GROUP BY ac.chart_id
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55053- JOIN robot p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:55054: WHERE e.id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55055-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55087- JOIN robot p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:55088: WHERE e.control_code = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55089-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55281- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:55282:DELETE FROM lsmb_sequence where label = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55283-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55312- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:55313:SELECT * FROM lsmb_sequence WHERE label = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55314-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55414- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:55415:SELECT * FROM lsmb_sequence where setting_key = $1 order by label;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55416-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55667- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:55668:SELECT * FROM defaults WHERE setting_key = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55669-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55791- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:55792:SELECT * FROM country_tax_form where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-55793-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56304-SELECT * FROM template
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:56305: WHERE template_name = $1 AND format = $3 AND
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56306- language_code IS NOT DISTINCT FROM $2;
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56334- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:56335:SELECT * FROM template WHERE id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56336-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56548- WHERE id in (select business_unit_id from jcitems
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:56549: WHERE id = $1));
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56550-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56576-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:56577: <programlisting> SELECT * FROM jcitems WHERE id = $1; </programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56578- </para>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56766-
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:56767:SELECT * FROM jctype where id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-56768-
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-57731- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:57732:SELECT * FROM payroll_wage WHERE entity_id = $1;
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-57733-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-57760- <programlisting>
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml:57761:SELECT * FROM payroll_income_type where country_id = $1
ledgersmb-1.6.9+ds/doc/database/ledgersmb.xml-57762-</programlisting>
##############################################
ledgersmb-1.6.9+ds/doc/dev_manual/workflow.tex-733-
ledgersmb-1.6.9+ds/doc/dev_manual/workflow.tex:734:This is a hashref where country\_id =$>$ arrayref of hashrefs, where that hashref
ledgersmb-1.6.9+ds/doc/dev_manual/workflow.tex-735-has the following keys:
##############################################
ledgersmb-1.6.9+ds/doc/manual/LedgerSMB-manual.tex-3385-
ledgersmb-1.6.9+ds/doc/manual/LedgerSMB-manual.tex:3386: $results = `$cmd 2>&1`;
ledgersmb-1.6.9+ds/doc/manual/LedgerSMB-manual.tex-3387-
##############################################
ledgersmb-1.6.9+ds/lib/LedgerSMB/PSGI.pm-185- return builder {
ledgersmb-1.6.9+ds/lib/LedgerSMB/PSGI.pm:186: enable match_if addr([qw{ 127.0.0.0/8 ::1 ::ffff:127.0.0.0/108 }]),
ledgersmb-1.6.9+ds/lib/LedgerSMB/PSGI.pm-187- 'ReverseProxy';
##############################################
ledgersmb-1.6.9+ds/lib/LedgerSMB/Scripts/import_csv.pm-253- ap_trans_id = $ap_form->{id}
ledgersmb-1.6.9+ds/lib/LedgerSMB/Scripts/import_csv.pm:254: WHERE id = $report_id"
ledgersmb-1.6.9+ds/lib/LedgerSMB/Scripts/import_csv.pm-255- ) or $ap_form->dberror());
##############################################
ledgersmb-1.6.9+ds/lib/LedgerSMB/Scripts/setup.pm-583- from chart
ledgersmb-1.6.9+ds/lib/LedgerSMB/Scripts/setup.pm:584: where link = '$link'");
ledgersmb-1.6.9+ds/lib/LedgerSMB/Scripts/setup.pm-585- $sth->execute();
##############################################
ledgersmb-1.6.9+ds/lib/LedgerSMB/Scripts/vouchers.pm-489- $zipcmd =~ s/\%dir/$dirname/g;
ledgersmb-1.6.9+ds/lib/LedgerSMB/Scripts/vouchers.pm:490: `$zipcmd`;
ledgersmb-1.6.9+ds/lib/LedgerSMB/Scripts/vouchers.pm-491-
##############################################
ledgersmb-1.6.9+ds/old/bin/io.pl-404-<script type="dojo/on" data-dojo-event="click">
ledgersmb-1.6.9+ds/old/bin/io.pl:405:require('dijit/registry').byId('invoice-lines').removeLine('line-$i');
ledgersmb-1.6.9+ds/old/bin/io.pl-406-</script>
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-316- FROM $table
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm:317: WHERE id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-318- my ($exists) = $dbh->selectrow_array($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-332- (SELECT entry_id FROM acc_trans
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm:333: WHERE trans_id = $id)|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-334-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-338- DELETE FROM acc_trans
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm:339: WHERE trans_id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-340-
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-341- $dbh->do($query) || $form->dberror($query);
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm:342: $dbh->do("DELETE FROM $table where id = $id");
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-343- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-1009- $transdate = $dbh->quote( $form->{transdate} );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm:1010: my $where = $form->{transdate}
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm:1011: ? qq|WHERE (t.validto >= $transdate OR t.validto IS NULL)|
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AA.pm-1012- : '';
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-416- FROM sic
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm:417: WHERE code = | . $dbh->quote( $form->{code} );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-418-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-590- DELETE FROM language
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm:591: WHERE code = | . $dbh->quote( $form->{code} );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-592-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-975- FROM recurring
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm:976: WHERE id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-977-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-986- FROM recurring
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm:987: WHERE id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-988-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-993- SET nextdate = NULL
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm:994: WHERE id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-995- } else {
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-998- SET nextdate = (date $nextdate + interval $interval)
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm:999: WHERE id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/AM.pm-1000- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm-89-
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm:90: $query = qq|SELECT id FROM gl WHERE id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm-91- ( $form->{id} ) = $dbh->selectrow_array($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm-96- $query = qq|
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm:97: DELETE FROM acc_trans WHERE trans_id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm-98-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm-100- $query = qq|
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm:101: DELETE FROM voucher WHERE trans_id = $id
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm-102- and batch_class = 5|;
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm-122- FROM gl
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm:123: WHERE reference = '$uid'|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/GL.pm-124-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-179- $query = qq|
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm:180: SELECT parts_id FROM invoice WHERE parts_id = $id
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-181- UNION
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm:182: SELECT parts_id FROM orderitems WHERE parts_id = $id
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-183- UNION
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm:184: SELECT parts_id FROM assembly WHERE parts_id = $id
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-185- UNION
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm:186: SELECT parts_id FROM jcitems WHERE parts_id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-187- ( $form->{orphaned} ) = $dbh->selectrow_array($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-410-
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm:411: $query = qq|SELECT id FROM parts WHERE partnumber = '$uid'|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-412- $sth = $dbh->prepare($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-664- $qty * cast($weight AS numeric)
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm:665: WHERE id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-666- $dbh->do($query) || $form->dberror($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-681- my $partnumber = $dbh->quote( $form->like( lc $form->{partnumber} ) );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm:682: $where .= " AND lower(p.partnumber) LIKE $partnumber";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-683- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-686- my $description = $dbh->quote( $form->like( lc $form->{description} ) );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm:687: $where .= " AND lower(p.description) LIKE $description";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-688- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-910- $var = $dbh->quote( $form->{"partnumber_$i"} );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm:911: $where .= " AND p.partnumber = $var";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IC.pm-912- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-157-
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm:158: $query = qq|SELECT id FROM ap WHERE invnumber = '$uid'|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-159- $sth = $dbh->prepare($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-334- SELECT id FROM invoice
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm:335: WHERE description = '$uid'|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-336- ($invoice_id) = $dbh->selectrow_array($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-829- lastcost = lastcost($item)
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm:830: WHERE id = $item|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-831- $dbh->do($query) || $form->dberror($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-1084- $var = $dbh->quote( $form->{"partnumber_$i"} );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm:1085: $where .= " AND p.partnumber = $var or mm.barcode is not null";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-1086- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-1090- $var = $dbh->quote($var);
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm:1091: $where .= qq| AND p.partsgroup_id = $var|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IR.pm-1092- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm-811-
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm:812: $query = qq|SELECT id FROM ar WHERE invnumber = '$uid'|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm-813- $sth = $dbh->prepare($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm-991- SELECT id FROM invoice
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm:992: WHERE description = '$uid'|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm-993- ($invoice_id) = $dbh->selectrow_array($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm-1650- $var = $dbh->quote( $form->{"partnumber_$i"} );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm:1651: $where .= " AND (p.partnumber = $var or mm.barcode is not null)";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm-1652- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm-1664- $var = $dbh->quote($var);
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm:1665: $where .= qq| AND p.partsgroup_id = $var|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/IS.pm-1666- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-161-
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm:162: $query = qq|SELECT id FROM oe WHERE id = $form->{id}|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-163-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-1554- FROM project
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm:1555: WHERE id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-1556- ($_) = $dbh->selectrow_array($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-1779- FROM warehouse_inventory
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm:1780: WHERE trans_id = $id|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-1781- my $ith = $dbh->prepare($query) || $form->dberror($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-1878- LEFT JOIN warehouse w ON (w.id = i.warehouse_id)
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm:1879: WHERE (i.warehouse_id = $fromwarehouse_id OR
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-1880- i.warehouse_id IS NULL)
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-1912- LEFT JOIN warehouse w ON (w.id = i.warehouse_id)
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm:1913: WHERE i.warehouse_id != $towarehouse_id
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-1914- $where
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-2169-
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm:2170: $query = qq|SELECT id FROM oe WHERE ordnumber = '$uid'|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/OE.pm-2171- $sth = $dbh->prepare($query);
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-218- pricegroup = ?
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:219: WHERE id = | . $dbh->quote( $form->{id} );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-220- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-293- $var = $dbh->quote( $form->like( lc $form->{$_} ) );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:294: $where .= " AND lower(p.$_) LIKE $var";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-295- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-298- $where .= " AND p.obsolete = '0'";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:299: $where .= " AND p.id = " . $dbh->quote( $form->{id} ) if $form->{id};
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-300-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-371- $var = $dbh->quote( $form->like( lc $form->{description} ) );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:372: $where .= " AND lower(p.partsgroup) LIKE $var";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-373- }
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:374: $where .= " AND p.id = " . $dbh->quote( $form->{id} ) if $form->{id};
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-375-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-444- $var = $dbh->quote( $form->like( lc $form->{$_} ) );
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:445: $where .= " AND lower(p.$_) LIKE $var";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-446- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-448-
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:449: $where .= " AND p.id = " . $dbh->quote( $form->{id} ) if $form->{id};
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-450-
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-684- $var = $dbh->quote($var);
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:685: $where .= " AND j.business_unit_id = $var";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-686- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-690- $var = $dbh->quote($var);
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:691: $where .= " AND j.person_id = $var";
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-692- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-725- LEFT JOIN company c ON eca.entity_id = c.entity_id
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm:726: WHERE j.allocated != j.qty $where
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/PE.pm-727- ORDER BY pr.description, c.legal_name, j.checkedin::date|;
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm-2469- SELECT value::date FROM defaults
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm:2470: WHERE setting_key = '$_'|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm-2471- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm-2477- SELECT value FROM defaults
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm:2478: WHERE setting_key = '$_'|;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm-2479- }
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm-2560-
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm:2561: $where = "AND $where " if $where;
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm-2562- my $query = qq|
##############################################
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm-2567- JOIN entity ON (ct.entity_id = entity.id)
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm:2568: WHERE entity.id = (select entity_id from $arap
ledgersmb-1.6.9+ds/old/lib/LedgerSMB/Form.pm-2569- where entity_id IS NOT NULL $where
##############################################
ledgersmb-1.6.9+ds/sql/modules/Account.sql-227-$$
ledgersmb-1.6.9+ds/sql/modules/Account.sql:228: select * from account where accno = $1;
ledgersmb-1.6.9+ds/sql/modules/Account.sql-229-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Account.sql-238- JOIN account ON account.id = c2a.chart_id
ledgersmb-1.6.9+ds/sql/modules/Account.sql:239: WHERE accno = $1; $$
ledgersmb-1.6.9+ds/sql/modules/Account.sql-240-LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Account.sql-280- ON (c.id = l.account_id)
ledgersmb-1.6.9+ds/sql/modules/Account.sql:281: where id = $1
ledgersmb-1.6.9+ds/sql/modules/Account.sql-282-group by c.id, c.accno, c.description, c.category,
##############################################
ledgersmb-1.6.9+ds/sql/modules/Account.sql-293-$$
ledgersmb-1.6.9+ds/sql/modules/Account.sql:294: SELECT * FROM account_translation WHERE trans_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Account.sql-295-$$ LANGUAGE sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Account.sql-327- DELETE FROM account_translation
ledgersmb-1.6.9+ds/sql/modules/Account.sql:328: WHERE trans_id = $1
ledgersmb-1.6.9+ds/sql/modules/Account.sql-329- AND language_code = $2;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Account.sql-352-$$
ledgersmb-1.6.9+ds/sql/modules/Account.sql:353: SELECT * FROM account_heading_translation WHERE trans_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Account.sql-354-$$ LANGUAGE sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Account.sql-386- DELETE FROM account_heading_translation
ledgersmb-1.6.9+ds/sql/modules/Account.sql:387: WHERE trans_id = $1
ledgersmb-1.6.9+ds/sql/modules/Account.sql-388- AND language_code = $2;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Account.sql-609-SELECT * FROM account
ledgersmb-1.6.9+ds/sql/modules/Account.sql:610:WHERE id IN (SELECT account_id FROM account_link WHERE description = $1);
ledgersmb-1.6.9+ds/sql/modules/Account.sql-611-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/App_Module.sql-7-CREATE OR REPLACE FUNCTION lsmb_module__get(in_id int) RETURNS lsmb_module AS
ledgersmb-1.6.9+ds/sql/modules/App_Module.sql:8:$$ SELECT * FROM lsmb_module where id = $1; $$ LANGUAGE SQL;
ledgersmb-1.6.9+ds/sql/modules/App_Module.sql-9-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-93- LEFT JOIN asset_report r ON (l.report_id = r.id)
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:94: WHERE ai.id = ANY($1)
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-95- GROUP BY ai.id, ai.start_depreciation, ai.purchase_date, ai.purchase_value,
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-97-
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:98: UPDATE asset_report SET report_class = 1 WHERE id = $3;
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-99-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-126- LEFT JOIN asset_report r ON (l.report_id = r.id)
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:127: WHERE ai.id = ANY($1)
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-128- GROUP BY ai.id, ai.start_depreciation, ai.purchase_date, ai.purchase_value,
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-130-
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:131: UPDATE asset_report SET report_class = 1 WHERE id = $3;
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-132-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-165- LEFT JOIN asset_report r ON (l.report_id = r.id)
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:166: WHERE ai.id = ANY($1)
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-167- GROUP BY ai.id, ai.start_depreciation, ai.purchase_date, ai.purchase_value,
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-169-
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:170: UPDATE asset_report SET report_class = 1 WHERE id = $3;
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-171-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-513-SELECT * from asset_dep_method
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:514:WHERE id = (select method from asset_class where id = $1);
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-515-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-709- ON ((arld.report_id, arld.asset_id) = (l.report_id, l.asset_id))
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:710: WHERE ar.id = $1;
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-711-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-759- JOIN asset_item ON (asset_report_line.asset_id = asset_item.id)
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:760: WHERE asset_report.id = $1
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-761-GROUP BY asset_report.id, asset_report.report_date;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-840-$$
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:841:select * from asset_report where id = $1;
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-842-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-888-LEFT JOIN asset_report pr ON (prl.report_id = pr.id)
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:889: WHERE rl.report_id = $1
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-890- GROUP BY ai.tag, ai.start_depreciation, ai.purchase_value, m.short_name,
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-952-LEFT JOIN asset_report ar ON (arl.report_id = ar.id)
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:953: WHERE ai.start_depreciation <= $3 AND ac.id = $2
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-954- AND obsolete_by IS NULL
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-1017- SET obsolete_by = -1
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:1018: WHERE tag = $2 and $17 is true;
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-1019-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-1089- approved_at = now()
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:1090: where id = $1;
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-1091-
ledgersmb-1.6.9+ds/sql/modules/Assets.sql:1092:select * from asset_report where id = $1;
ledgersmb-1.6.9+ds/sql/modules/Assets.sql-1093-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-54- LEFT JOIN entity oe ON bi.obsolete_by = oe.id
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql:55: where bi.id = $1;
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-56-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-66- JOIN budget_info bi ON bi.id = b2bu.budget_id
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql:67: WHERE bi.id = $1
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-68- ORDER BY bu.class_id;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-91- LEFT JOIN entity oe ON bi.obsolete_by = oe.id
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql:92: WHERE (start_date = $1 or $1 is null) AND ($2 = end_date or $2 is null)
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-93- AND ($3 BETWEEN start_date AND end_date or $2 is null)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-165- set approved_at = now(), approved_by = person__get_my_entity_id()
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql:166: WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-167-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-225- JOIN account a ON a.id = l.account_id
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql:226: where budget_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-227-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-234-$$
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql:235: SELECT * FROM budget_note WHERE ref_key = $1;
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-236-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-257-$$
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql:258:SELECT * FROM budget_note WHERE ref_key = $1
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-259- ORDER BY created;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-300- AND a.id = b.account_id
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql:301: WHERE bi.id = $1
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-302- GROUP BY act.accno, act.description, act.id, b.description, b.amount
##############################################
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-313- set obsolete_by = person__get_my_entity_id(), obsolete_at = now()
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql:314: WHERE id = $1 and approved_by is not null;
ledgersmb-1.6.9+ds/sql/modules/Budgetting.sql-315-SELECT budget__get_info($1)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-12- FROM business_unit_class bc
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql:13: WHERE (active = $1 OR $1 IS NULL)
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-14- AND (id IN (select bu_class_id
##############################################
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-16- JOIN lsmb_module mod ON mod.id = bcm.module_id
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql:17: WHERE lower(label) = lower($2))
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-18- OR $2 is null)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-29-AS
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql:30:$$ SELECT * FROM business_unit WHERE id = $1; $$ LANGUAGE SQL;
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-31-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-97-$$
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql:98:DELETE FROM bu_class_to_module WHERE bu_class_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-99-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-109-$$ SELECT * FROM lsmb_module
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql:110: WHERE id IN (select module_id from bu_class_to_module where bu_class_id = $1)
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-111- ORDER BY id;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-184-RETURNS business_unit AS
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql:185:$$ SELECT * FROM business_unit where id = $1; $$ LANGUAGE SQL;
ledgersmb-1.6.9+ds/sql/modules/Business_Unit.sql-186-
##############################################
ledgersmb-1.6.9+ds/sql/modules/COGS.sql-372- JOIN parts p ON p.id = i.parts_id
ledgersmb-1.6.9+ds/sql/modules/COGS.sql:373: WHERE i.id = $1;
ledgersmb-1.6.9+ds/sql/modules/COGS.sql-374-
##############################################
ledgersmb-1.6.9+ds/sql/modules/COGS.sql-376- SET allocated = allocated + retval
ledgersmb-1.6.9+ds/sql/modules/COGS.sql:377: WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/COGS.sql-378-ELSE -- reversal
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-89-SELECT * FROM entity_credit_account
ledgersmb-1.6.9+ds/sql/modules/Company.sql:90: WHERE entity_class = $2 AND meta_number = $1;
ledgersmb-1.6.9+ds/sql/modules/Company.sql-91-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-113- and l.description = 'AR'
ledgersmb-1.6.9+ds/sql/modules/Company.sql:114: where $16 = 2 and $13 = 'i'
ledgersmb-1.6.9+ds/sql/modules/Company.sql-115- GROUP BY 1, 2, 3, 4, 5, 6, 7
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-124- and l.description = 'AP'
ledgersmb-1.6.9+ds/sql/modules/Company.sql:125: where $16 = 1 and $13 = 'i'
ledgersmb-1.6.9+ds/sql/modules/Company.sql-126- GROUP BY 1, 2, 3, 4, 5, 6, 7
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-141- FROM (select * from entity_credit_account
ledgersmb-1.6.9+ds/sql/modules/Company.sql:142: where meta_number = $2
ledgersmb-1.6.9+ds/sql/modules/Company.sql-143- UNION
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-152- from oe
ledgersmb-1.6.9+ds/sql/modules/Company.sql:153: where ($16= 1 and oe.oe_class_id = 2 and $13 = 'o'
ledgersmb-1.6.9+ds/sql/modules/Company.sql-154- and quotation is not true)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-159- from oe
ledgersmb-1.6.9+ds/sql/modules/Company.sql:160: where ($16= 2 and oe.oe_class_id = 1 and $13 = 'o'
ledgersmb-1.6.9+ds/sql/modules/Company.sql-161- and quotation is not true)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-398-$$
ledgersmb-1.6.9+ds/sql/modules/Company.sql:399:select * from eca_tax where eca_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Company.sql-400-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-408-$$
ledgersmb-1.6.9+ds/sql/modules/Company.sql:409: DELETE FROM eca_tax WHERE eca_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Company.sql-410- INSERT INTO eca_tax (eca_id, chart_id)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-473-$$
ledgersmb-1.6.9+ds/sql/modules/Company.sql:474:SELECT * FROM entity_credit_account WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Company.sql-475-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-591- JOIN entity e ON e.id = c.entity_id
ledgersmb-1.6.9+ds/sql/modules/Company.sql:592: WHERE entity_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Company.sql-593-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-604- JOIN entity e ON e.id = c.entity_id
ledgersmb-1.6.9+ds/sql/modules/Company.sql:605: WHERE e.control_code = $1;
ledgersmb-1.6.9+ds/sql/modules/Company.sql-606-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1381- FROM entity_credit_account
ledgersmb-1.6.9+ds/sql/modules/Company.sql:1382: WHERE entity_id = $1
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1383- AND entity_class = $2;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1403- JOIN entity_credit_account eca ON pc.pricegroup_id = eca.pricegroup_id
ledgersmb-1.6.9+ds/sql/modules/Company.sql:1404: WHERE eca.id = $1 AND eca.entity_class = 2
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1405-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1416- JOIN entity_credit_account eca ON pc.credit_id = eca.id
ledgersmb-1.6.9+ds/sql/modules/Company.sql:1417: WHERE pc.credit_id = $1 AND eca.entity_class = 2
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1418- UNION
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1424- JOIN entity_credit_account eca ON pv.credit_id = eca.id
ledgersmb-1.6.9+ds/sql/modules/Company.sql:1425: WHERE pv.credit_id = $1 and eca.entity_class = 1
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1426- ORDER BY partnumber, validfrom
##############################################
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1660-$$
ledgersmb-1.6.9+ds/sql/modules/Company.sql:1661:delete from partscustomer where entry_id = $1 and credit_id = $2;
ledgersmb-1.6.9+ds/sql/modules/Company.sql:1662:delete from partsvendor where entry_id = $1 and credit_id = $2;
ledgersmb-1.6.9+ds/sql/modules/Company.sql-1663-select true;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Employee.sql-62-RETURNS users AS
ledgersmb-1.6.9+ds/sql/modules/Employee.sql:63:$$SELECT * FROM users WHERE entity_id = $1;$$ language sql;
ledgersmb-1.6.9+ds/sql/modules/Employee.sql-64-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Employee.sql-134-LEFT JOIN person mp ON ee.manager_id = p.entity_id
ledgersmb-1.6.9+ds/sql/modules/Employee.sql:135: WHERE p.entity_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Employee.sql-136-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/EndOfYear.sql-198- FROM account_checkpoint
ledgersmb-1.6.9+ds/sql/modules/EndOfYear.sql:199: WHERE end_date >= $1
ledgersmb-1.6.9+ds/sql/modules/EndOfYear.sql-200- GROUP BY end_date
##############################################
ledgersmb-1.6.9+ds/sql/modules/EndOfYear.sql-206-SELECT CASE WHEN (SELECT count(*) > 0 from account_checkpoint
ledgersmb-1.6.9+ds/sql/modules/EndOfYear.sql:207: where end_date = $1 - 1)
ledgersmb-1.6.9+ds/sql/modules/EndOfYear.sql-208- THEN true
##############################################
ledgersmb-1.6.9+ds/sql/modules/Entity.sql-109-LANGUAGE SQL AS $$
ledgersmb-1.6.9+ds/sql/modules/Entity.sql:110:SELECT * FROM entity_bank_account WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Entity.sql-111-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Files.sql-11-select * from mime_type
ledgersmb-1.6.9+ds/sql/modules/Files.sql:12: where ($1 IS NULL OR id = $1) AND ($2 IS NULL OR mime_type = $2);
ledgersmb-1.6.9+ds/sql/modules/Files.sql-13-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Files.sql-242- where username = session_user)
ledgersmb-1.6.9+ds/sql/modules/Files.sql:243: WHERE file_name = $3
ledgersmb-1.6.9+ds/sql/modules/Files.sql-244- RETURNING true as found_it
##############################################
ledgersmb-1.6.9+ds/sql/modules/Files.sql-292- JOIN entity e ON f.uploaded_by = e.id
ledgersmb-1.6.9+ds/sql/modules/Files.sql:293: WHERE f.ref_key = $1 and f.file_class = $2
ledgersmb-1.6.9+ds/sql/modules/Files.sql-294- AND m.invoice_include
##############################################
ledgersmb-1.6.9+ds/sql/modules/Files.sql-315- JOIN entity e ON f.uploaded_by = e.id
ledgersmb-1.6.9+ds/sql/modules/Files.sql:316: WHERE f.ref_key = $1 and f.file_class = $2;
ledgersmb-1.6.9+ds/sql/modules/Files.sql-317-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Files.sql-326-$$
ledgersmb-1.6.9+ds/sql/modules/Files.sql:327:SELECT * FROM file_base where id = $1 and file_class = $2;
ledgersmb-1.6.9+ds/sql/modules/Files.sql-328-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Files.sql-397-RETURNS setof file_links AS
ledgersmb-1.6.9+ds/sql/modules/Files.sql:398:$$ select * from file_links where ref_key = $1 and dest_class = $2;
ledgersmb-1.6.9+ds/sql/modules/Files.sql-399-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-9-$$
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:10:select * from parts where id = $1;
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-11-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-18-BEGIN
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:19: SELECT * INTO t_mfg_lot FROM mfg_lot WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-20- IF NOT FOUND THEN
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-28- WHERE id in (select parts_id from mfg_lot_item
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:29: WHERE mfg_lot_id = $1);
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-30-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-40- SELECT currval('id')::int, parts_id, qty, 0
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:41: FROM mfg_lot_item WHERE mfg_lot_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-42-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-85- SELECT currval('mfg_lot_id_seq')::int, parts_id, qty * $2
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:86: FROM assembly WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-87-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-225- ON (a.id = i.trans_id AND a.approved)
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:226: WHERE ($1 IS NULL OR a.transdate >= $1)
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-227- AND ($2 IS NULL OR a.transdate <= $2)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-280- LEFT JOIN order_sum oi ON oi.parts_id = p.id OR a.parts_id = i.parts_id
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:281: WHERE p.id = $1 OR p.partnumber = $2
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:282: OR (p.id IN (select parts_id FROM makemodel WHERE barcode = $2)
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-283- AND NOT EXISTS (select id from parts
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:284: where partnumber = $2 AND NOT obsolete
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-285- ))
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-426-SELECT * FROM inventory_report
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:427: WHERE ($1 is null or transdate >= $1)
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-428- AND ($2 IS NULL OR transdate <= $2)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-437-$$
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:438:SELECT * FROM inventory_report WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-439-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-443-$$
ledgersmb-1.6.9+ds/sql/modules/Goods.sql:444:SELECT * FROM inventory_report_line l WHERE adjust_id = $1
ledgersmb-1.6.9+ds/sql/modules/Goods.sql-445- ORDER BY parts_id;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Inventory.sql-61-$$
ledgersmb-1.6.9+ds/sql/modules/Inventory.sql:62:SELECT * FROM parts WHERE obsolete is not true AND partnumber = $1;
ledgersmb-1.6.9+ds/sql/modules/Inventory.sql-63-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Inventory.sql-67-$$
ledgersmb-1.6.9+ds/sql/modules/Inventory.sql:68:SELECT * FROM parts WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Inventory.sql-69-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-29- SELECT currval('id')::int, $2, a.id, $4, true
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql:30: FROM account a WHERE accno = $16;
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-31-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-58- SELECT currval('id')::int, $2, a.id, $4 * -1, true
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql:59: FROM account a WHERE accno = $16;
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-60-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-95-SELECT $1, p.id, $3 * -1, $4, coalesce($5, p.unit), 0, $6
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql:96: FROM parts p WHERE id = $2;
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-97-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-107-SELECT $1, p.id, $3, $4, coalesce($5, p.unit), 0, $6
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql:108: FROM parts p WHERE id = $2;
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-109-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-126- approved)
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql:127:VALUES ($1, (select id from account where accno = $2), coalesce($4, 'today'), $5,
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-128- $6, $7, true),
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql:129: ($1, (select id from account where accno = $3), coalesce($4, 'today'), $5,
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-130- $6, $7 * -1, true);
##############################################
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-141- approved)
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql:142:VALUES ($1, (select id from account where accno = $2), coalesce($4, 'today'), $5,
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-143- $6, $7 * -1, true),
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql:144: ($1, (select id from account where accno = $3), coalesce($4, 'today'), $5,
ledgersmb-1.6.9+ds/sql/modules/Invoice.sql-145- $6, $7, true);
##############################################
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-54- JOIN journal_line jl ON jl.je_id = je.id
ledgersmb-1.6.9+ds/sql/modules/Journal.sql:55: WHERE je.id = $1
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-56- GROUP BY je.id, je.reference, je.journal, j.name, je.post_date,
##############################################
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-71- approved_by = person__get_my_entity_id()
ledgersmb-1.6.9+ds/sql/modules/Journal.sql:72: WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-73-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-85- from journal_entry
ledgersmb-1.6.9+ds/sql/modules/Journal.sql:86: where id = $1 and approved is false);
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-87-
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-88-DELETE FROM journal_id
ledgersmb-1.6.9+ds/sql/modules/Journal.sql:89: WHERE id = $1 and approved is false;
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-90-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-212- FROM journal_entry je, defaults d
ledgersmb-1.6.9+ds/sql/modules/Journal.sql:213: WHERE d.setting_key = 'separate_duties' and je.id = $1;
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-214-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-220- FROM journal_line
ledgersmb-1.6.9+ds/sql/modules/Journal.sql:221: WHERE je_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Journal.sql-222-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Menu.sql-93-AS $$
ledgersmb-1.6.9+ds/sql/modules/Menu.sql:94:SELECT * FROM menu_generate() where parent = $1;
ledgersmb-1.6.9+ds/sql/modules/Menu.sql-95-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-98- SELECT id, null, row(array[id])::tree_record FROM business_unit
ledgersmb-1.6.9+ds/sql/modules/PNL.sql:99: WHERE id = any($4)
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-100- UNION ALL
##############################################
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-113- GROUP BY entry_id) bui ON bui.entry_id = i.id
ledgersmb-1.6.9+ds/sql/modules/PNL.sql:114: WHERE i.parts_id = $3
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-115- AND (ac.transdate >= $1 OR $1 IS NULL)
##############################################
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-131- GROUP BY entry_id) bui ON bui.entry_id = i.id
ledgersmb-1.6.9+ds/sql/modules/PNL.sql:132: WHERE i.parts_id = $3
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-133- AND (ac.transdate >= $1 OR $1 IS NULL)
##############################################
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-228- SELECT id, null, row(array[id])::tree_record FROM business_unit
ledgersmb-1.6.9+ds/sql/modules/PNL.sql:229: WHERE id = any($4)
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-230- UNION ALL
##############################################
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-349- SELECT id, null, row(array[id])::tree_record FROM business_unit
ledgersmb-1.6.9+ds/sql/modules/PNL.sql:350: WHERE id = any($4)
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-351- UNION ALL
##############################################
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-360- FROM cash_impact ca
ledgersmb-1.6.9+ds/sql/modules/PNL.sql:361: WHERE ($1 IS NULL OR ca.transdate >= $1)
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-362- AND ($2 IS NULL OR ca.transdate <= $2)
##############################################
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-472- FROM acc_trans ac
ledgersmb-1.6.9+ds/sql/modules/PNL.sql:473: WHERE ac.approved AND ac.trans_id = $1
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-474- GROUP BY ac.chart_id
##############################################
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-563-WITH gl (id) AS
ledgersmb-1.6.9+ds/sql/modules/PNL.sql:564: ( SELECT id FROM ap WHERE approved is true AND entity_credit_account = $1
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-565-UNION ALL
ledgersmb-1.6.9+ds/sql/modules/PNL.sql:566: SELECT id FROM ar WHERE approved is true AND entity_credit_account = $1
ledgersmb-1.6.9+ds/sql/modules/PNL.sql-567-)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Parts.sql-27-$$
ledgersmb-1.6.9+ds/sql/modules/Parts.sql:28:SELECT * FROM parts WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Parts.sql-29-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Parts.sql-32-RETURNS parts LANGUAGE SQL AS $$
ledgersmb-1.6.9+ds/sql/modules/Parts.sql:33:SELECT * FROM PARTS WHERE partnumber = $1 and obsolete is not true;
ledgersmb-1.6.9+ds/sql/modules/Parts.sql-34-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Parts.sql-38-$$
ledgersmb-1.6.9+ds/sql/modules/Parts.sql:39:SELECT * FROM parts where partnumber = $1 AND NOT OBSOLETE;
ledgersmb-1.6.9+ds/sql/modules/Parts.sql-40-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payment.sql-76- JOIN company cp ON (cp.entity_id = e.id)
ledgersmb-1.6.9+ds/sql/modules/Payment.sql:77: WHERE ec.id = $1;
ledgersmb-1.6.9+ds/sql/modules/Payment.sql-78-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payment.sql-1493-$$
ledgersmb-1.6.9+ds/sql/modules/Payment.sql:1494:SELECT * FROM gl WHERE id = (select id from payment where id = $1);
ledgersmb-1.6.9+ds/sql/modules/Payment.sql-1495-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-9-$$
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql:10:SELECT * FROM payroll_wage WHERE entity_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-11-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-15-$$
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql:16:SELECT * FROM payroll_income_type where country_id = $1
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-17-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-51-$$
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql:52:SELECT * FROM payroll_deduction WHERE entity_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-53-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-57-$$
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql:58:SELECT * FROM payroll_deduction_type where country_id = $1
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-59-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-89-RETURNS payroll_income_type AS $$
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql:90:SELECT * FROM payroll_income_type WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-91-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-100-$$
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql:101:SELECT * FROM payroll_income_class where country_id = $1
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-102-ORDER BY label;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-144- FROM payroll_income_type
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql:145: where (account_id = $1 OR $1 IS NULL) AND
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-146- (pic_id = $2 OR $2 IS NULL) AND
##############################################
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-158- FROM payroll_deduction_type
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql:159: where (account_id = $1 OR $1 IS NULL) AND
ledgersmb-1.6.9+ds/sql/modules/Payroll.sql-160- (pdc_id = $2 OR $2 IS NULL) AND
##############################################
ledgersmb-1.6.9+ds/sql/modules/Person.sql-63- JOIN person p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/sql/modules/Person.sql:64: WHERE e.id = $1;
ledgersmb-1.6.9+ds/sql/modules/Person.sql-65-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Person.sql-75- JOIN person p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/sql/modules/Person.sql:76: WHERE e.control_code = $1;
ledgersmb-1.6.9+ds/sql/modules/Person.sql-77-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql-53- FROM (SELECT count(*) as c FROM ar
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql:54: WHERE approved IS FALSE AND transdate <= $1
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql-55- UNION SELECT count(*) as c FROM ap
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql:56: WHERE approved IS FALSE AND transdate <= $1
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql-57- UNION SELECT count(*) FROM gl
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql:58: WHERE approved IS FALSE AND transdate <= $1
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql-59- UNION SELECT count(DISTINCT source) FROM acc_trans
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql:60: WHERE approved IS FALSE AND transdate <= $1 AND chart_id = $2
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql-61- ) tx
##############################################
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql-65- FROM cr_report
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql:66: WHERE end_date < $1 AND approved IS NOT TRUE AND chart_id = $2
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql-67-)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql-194- ) g ON g.id = ac.trans_id
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql:195: WHERE c.id = $1 AND cleared
ledgersmb-1.6.9+ds/sql/modules/Reconciliation.sql-196- AND ac.approved IS true
##############################################
ledgersmb-1.6.9+ds/sql/modules/Report.sql-701- JOIN tx_report t ON t.approved AND t.id = ac.trans_id
ledgersmb-1.6.9+ds/sql/modules/Report.sql:702: WHERE ac.transdate <= coalesce($1, (select max(transdate) from acc_trans))
ledgersmb-1.6.9+ds/sql/modules/Report.sql-703- GROUP BY ac.chart_id
##############################################
ledgersmb-1.6.9+ds/sql/modules/Robot.sql-41- JOIN robot p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/sql/modules/Robot.sql:42: WHERE e.id = $1;
ledgersmb-1.6.9+ds/sql/modules/Robot.sql-43-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Robot.sql-52- JOIN robot p ON p.entity_id = e.id
ledgersmb-1.6.9+ds/sql/modules/Robot.sql:53: WHERE e.control_code = $1;
ledgersmb-1.6.9+ds/sql/modules/Robot.sql-54-$$ LANGUAGE SQL;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Session.sql-13- JOIN users u ON (s.users_id = u.id)
ledgersmb-1.6.9+ds/sql/modules/Session.sql:14: WHERE f.session_id = $1 and f.id = $2 and u.username = SESSION_USER;
ledgersmb-1.6.9+ds/sql/modules/Session.sql-15-$$ language sql SECURITY DEFINER;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-45-$$
ledgersmb-1.6.9+ds/sql/modules/Settings.sql:46:SELECT * FROM defaults WHERE setting_key = $1;
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-47-$$ LANGUAGE sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-159-$$
ledgersmb-1.6.9+ds/sql/modules/Settings.sql:160:SELECT * FROM lsmb_sequence WHERE label = $1;
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-161-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-165-$$
ledgersmb-1.6.9+ds/sql/modules/Settings.sql:166:SELECT * FROM lsmb_sequence where setting_key = $1 order by label;
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-167-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-227-$$
ledgersmb-1.6.9+ds/sql/modules/Settings.sql:228:DELETE FROM lsmb_sequence where label = $1;
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-229-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-235-$$
ledgersmb-1.6.9+ds/sql/modules/Settings.sql:236:SELECT * FROM account WHERE contra AND category = $1;
ledgersmb-1.6.9+ds/sql/modules/Settings.sql-237-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/TaxForm.sql-43-as $$
ledgersmb-1.6.9+ds/sql/modules/TaxForm.sql:44:SELECT * FROM country_tax_form where id = $1;
ledgersmb-1.6.9+ds/sql/modules/TaxForm.sql-45-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Templates.sql-11-SELECT * FROM template
ledgersmb-1.6.9+ds/sql/modules/Templates.sql:12: WHERE template_name = $1 AND format = $3 AND
ledgersmb-1.6.9+ds/sql/modules/Templates.sql-13- language_code IS NOT DISTINCT FROM $2;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Templates.sql-18-$$
ledgersmb-1.6.9+ds/sql/modules/Templates.sql:19:SELECT * FROM template WHERE id = $1;
ledgersmb-1.6.9+ds/sql/modules/Templates.sql-20-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Timecards.sql-8-LANGUAGE SQL AS
ledgersmb-1.6.9+ds/sql/modules/Timecards.sql:9:$$ SELECT * FROM jcitems WHERE id = $1; $$;
ledgersmb-1.6.9+ds/sql/modules/Timecards.sql-10-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Timecards.sql-76- WHERE id in (select business_unit_id from jcitems
ledgersmb-1.6.9+ds/sql/modules/Timecards.sql:77: WHERE id = $1));
ledgersmb-1.6.9+ds/sql/modules/Timecards.sql-78-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Timecards.sql-185-
ledgersmb-1.6.9+ds/sql/modules/Timecards.sql:186:SELECT * FROM jctype where id = $1;
ledgersmb-1.6.9+ds/sql/modules/Timecards.sql-187-
##############################################
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-56-$$
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql:57: SELECT sum(amount) = 0 FROM journal_line WHERE journal_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-58-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-143-$$
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql:144:SELECT * FROM eca_invoice where journal_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-145-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-148-$$
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql:149:SELECT * FROM journal_entry where id = $1;
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-150-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-153-$$
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql:154:select * from journal_line where journal_id = $1;
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-155-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-163-$$
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql:164:delete from recurringprint where id = $5;
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql:165:delete from recurring where id = $5;
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-166-insert into recurring (id, reference, startdate, recurring_interval, howmany)
##############################################
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-187- nextdate = $2::timestamp + recurring_interval
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql:188: WHERE id = $1 AND howmany > 0
ledgersmb-1.6.9+ds/sql/modules/Transaction_Templates.sql-189-RETURNING *;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Util.sql-101- from generate_subscripts($2,1) as i
ledgersmb-1.6.9+ds/sql/modules/Util.sql:102: where $2[i] = $1
ledgersmb-1.6.9+ds/sql/modules/Util.sql-103- order by i
##############################################
ledgersmb-1.6.9+ds/sql/modules/Util.sql-113- from generate_subscripts($2,1) as i
ledgersmb-1.6.9+ds/sql/modules/Util.sql:114: where $2[i] = $1
ledgersmb-1.6.9+ds/sql/modules/Util.sql-115- order by i
##############################################
ledgersmb-1.6.9+ds/sql/modules/Voucher.sql-10-$$
ledgersmb-1.6.9+ds/sql/modules/Voucher.sql:11:SELECT * FROM batch WHERE id = $1 FOR UPDATE;
ledgersmb-1.6.9+ds/sql/modules/Voucher.sql-12-$$;
##############################################
ledgersmb-1.6.9+ds/sql/modules/Voucher.sql-171-UPDATE batch SET locked_by = NULL
ledgersmb-1.6.9+ds/sql/modules/Voucher.sql:172: WHERE id = $1 AND locked_by IN (select session_id
ledgersmb-1.6.9+ds/sql/modules/Voucher.sql-173- from "session" s
##############################################
ledgersmb-1.6.9+ds/sql/modules/Voucher.sql-261-$$
ledgersmb-1.6.9+ds/sql/modules/Voucher.sql:262:SELECT id FROM batch_class WHERE class = $1;
ledgersmb-1.6.9+ds/sql/modules/Voucher.sql-263-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/admin.sql-581-RETURNS SETOF lsmb_group_grants AS $$
ledgersmb-1.6.9+ds/sql/modules/admin.sql:582:SELECT * FROM lsmb_group_grants WHERE group_name = $1
ledgersmb-1.6.9+ds/sql/modules/admin.sql-583-ORDER BY granted_role;
##############################################
ledgersmb-1.6.9+ds/sql/modules/reload_modules.sh-11-
ledgersmb-1.6.9+ds/sql/modules/reload_modules.sh:12:for a in `sed -e 's/^\s*//' -e 's/\s*$//' -e 's/#.*$//' LOADORDER | grep -v '^$'`
ledgersmb-1.6.9+ds/sql/modules/reload_modules.sh-13-do
##############################################
ledgersmb-1.6.9+ds/sql/modules/test/Base.sql-37-$$
ledgersmb-1.6.9+ds/sql/modules/test/Base.sql:38:SELECT id FROM account WHERE accno = $1;
ledgersmb-1.6.9+ds/sql/modules/test/Base.sql-39-$$ language sql;
##############################################
ledgersmb-1.6.9+ds/sql/modules/test/data/Reconciliation.sql-32-
ledgersmb-1.6.9+ds/sql/modules/test/data/Reconciliation.sql:33:CREATE OR REPLACE FUNCTION test_get_account_id(in_accno text) returns int as $$ SELECT id FROM account WHERE accno = $1; $$ language sql;
ledgersmb-1.6.9+ds/sql/modules/test/data/Reconciliation.sql-34-
##############################################
ledgersmb-1.6.9+ds/sql/upgrade/sl3.0.sql-397- JOIN transactions t ON t.id = ac.trans_id AND t.approved
ledgersmb-1.6.9+ds/sql/upgrade/sl3.0.sql:398: WHERE c.id = $1 AND cleared
ledgersmb-1.6.9+ds/sql/upgrade/sl3.0.sql-399- AND ac.approved IS true
##############################################
ledgersmb-1.6.9+ds/sql/Pg-database.sql-624-begin
ledgersmb-1.6.9+ds/sql/Pg-database.sql:625: SELECT locked_by into locked from transactions where id = $1;
ledgersmb-1.6.9+ds/sql/Pg-database.sql-626- IF NOT FOUND THEN
##############################################
ledgersmb-1.6.9+ds/sql/Pg-database.sql-630- END IF;
ledgersmb-1.6.9+ds/sql/Pg-database.sql:631: UPDATE transactions set locked_by = $2 where id = $1;
ledgersmb-1.6.9+ds/sql/Pg-database.sql-632- RETURN TRUE;
##############################################
ledgersmb-1.6.9+ds/t/06-blacklist.t-23-
ledgersmb-1.6.9+ds/t/06-blacklist.t:24:my $contents2 = `perl $FindBin::Bin/../utils/test/makeblacklist.pl`;
ledgersmb-1.6.9+ds/t/06-blacklist.t-25-$? and BAIL_OUT 'makeblacklist.pl gave non-zero exit code';
##############################################
ledgersmb-1.6.9+ds/t/07.1-extract-perl.t-80- my ($stderr,$exit) = capture_stderr {
ledgersmb-1.6.9+ds/t/07.1-extract-perl.t:81: system("echo \"$testfile\" | utils/devel/extract-perl > $pofile");
ledgersmb-1.6.9+ds/t/07.1-extract-perl.t-82- };
##############################################
ledgersmb-1.6.9+ds/utils/devel/chart-load-test.sh-41-if [ -f "$sqldir" ] ; then
ledgersmb-1.6.9+ds/utils/devel/chart-load-test.sh:42: chart=`basename $sqldir`
ledgersmb-1.6.9+ds/utils/devel/chart-load-test.sh:43: chartdir=`dirname $sqldir`
ledgersmb-1.6.9+ds/utils/devel/chart-load-test.sh-44- sqldir="${chartdir/%\/*\/*\/*/}"
##############################################
ledgersmb-1.6.9+ds/utils/devel/chart-load-test.sh-60-pushd $sqldir > /dev/null
ledgersmb-1.6.9+ds/utils/devel/chart-load-test.sh:61:( for i in `find "${chartdir:-.}" -name "${chart:-*.sql}" -path '*/chart/*' -print`; do
ledgersmb-1.6.9+ds/utils/devel/chart-load-test.sh-62- createdb $db
##############################################
ledgersmb-1.6.9+ds/utils/devel/coa-db-to-sql-136-
ledgersmb-1.6.9+ds/utils/devel/coa-db-to-sql:137:print "INSERT INTO defaults (value, setting_key ) SELECT id::text, 'default_country' from country WHERE short_name = '$default_country';";
ledgersmb-1.6.9+ds/utils/devel/coa-db-to-sql-138-
##############################################
ledgersmb-1.6.9+ds/utils/devel/rebuild_pot.sh-5-date_now=`date --utc "+%F %R%z"`
ledgersmb-1.6.9+ds/utils/devel/rebuild_pot.sh:6:version_now=`perl -Ilib -Iold/lib -MLedgerSMB -e 'print \$LedgerSMB::VERSION'`
ledgersmb-1.6.9+ds/utils/devel/rebuild_pot.sh-7-
##############################################
ledgersmb-1.6.9+ds/utils/devel/sync-fork.sh-16-
ledgersmb-1.6.9+ds/utils/devel/sync-fork.sh:17:cd `readlink -f "${Dir}"`
ledgersmb-1.6.9+ds/utils/devel/sync-fork.sh-18-
##############################################
ledgersmb-1.6.9+ds/utils/devel/wc-pot-file.sh-33- L="${L/\[*]/}"; # strip any [_?] field references so they don't skew the count
ledgersmb-1.6.9+ds/utils/devel/wc-pot-file.sh:34: Wc=`wc -w <<<"$L"`;
ledgersmb-1.6.9+ds/utils/devel/wc-pot-file.sh-35- aWc[$(( i++ ))]=$Wc;
##############################################
ledgersmb-1.6.9+ds/utils/diagnostics/diagnose.sh-2-
ledgersmb-1.6.9+ds/utils/diagnostics/diagnose.sh:3:scriptpath=`readlink -f "$0"`
ledgersmb-1.6.9+ds/utils/diagnostics/diagnose.sh-4-clear;
##############################################
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-130- safe_source() { # $1 is filename to include
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh:131: libFile=` readlink -f $1`
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-132- [[ -f $libFile ]] && { [[ -r $libFile ]] && source $libFile; } || {
##############################################
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-149- echo -n "testing '$i' : "
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh:150: [[ -x `which $i` ]] && echo "OK" || { echo "FAIL"; result=false; }
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-151- done
##############################################
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-162- SelectEditor() {
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh:163: [[ -z $Editor ]] && Editor=`which $EDITOR`
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh:164: [[ -z $Editor ]] && Editor=`which $VISUAL`
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-165- [[ -z $Editor ]] && Editor=`which mcedit`
##############################################
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-180- if [[ -n $ConfigFile ]]; then
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh:181: configFile=` readlink -f $ConfigFile`
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-182-
##############################################
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-270- (( fWidth > ( COLUMNS -20 ) )) && (( fWidth = COLUMNS - 20 ));
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh:271: local Txt=`fmt -u -w $fWidth -g $fWidth <<<$3`
ledgersmb-1.6.9+ds/utils/lib/bash-functions.sh-272- printf "$Bl_2\n";
##############################################
ledgersmb-1.6.9+ds/utils/process_queue/process_queue.pl-39- "select class from batch_class where id =
ledgersmb-1.6.9+ds/utils/process_queue/process_queue.pl:40: (select batch_class from pending_job where id = $job_id)"
ledgersmb-1.6.9+ds/utils/process_queue/process_queue.pl-41- );
##############################################
ledgersmb-1.6.9+ds/utils/process_queue/process_queue.pl-56- error_condition = " . $dbh->quote($errstr) . "
ledgersmb-1.6.9+ds/utils/process_queue/process_queue.pl:57: WHERE id = $job_id"
ledgersmb-1.6.9+ds/utils/process_queue/process_queue.pl-58- );
##############################################
ledgersmb-1.6.9+ds/utils/test/Is_LSMB_running.sh-195-sed -i 's|="js-src/|="js/|' $current
ledgersmb-1.6.9+ds/utils/test/Is_LSMB_running.sh:196:DIFF=`diff -u0 $src $current`
ledgersmb-1.6.9+ds/utils/test/Is_LSMB_running.sh:197:CNTadd=`echo -e "$DIFF" | grep -c '^[+][^+].*$'`
ledgersmb-1.6.9+ds/utils/test/Is_LSMB_running.sh:198:CNTdel=`echo -e "$DIFF" | grep -c '^[-][^-].*$'`
ledgersmb-1.6.9+ds/utils/test/Is_LSMB_running.sh-199-if (( CNTadd > MaxDiff )); then DIE $EX_DATAERR "Added too many Lines ($CNTadd) to setup.pl.html${LF}Resolve any issues and run${LF}utils/test/Is_LSMB_running.sh --update" "$DIFF"; fi
##############################################
ledgersmb-1.6.9+ds/xt/05-po-checks.t-22- $entry = "locale/po/$entry";
ledgersmb-1.6.9+ds/xt/05-po-checks.t:23: system("msgfmt -o /dev/null -c '$entry' 2>/dev/null 1>/dev/null");
ledgersmb-1.6.9+ds/xt/05-po-checks.t-24- ok( $? == 0, "'$entry' passes 'msgfmt -c' validation");
##############################################
ledgersmb-1.6.9+ds/xt/06.1-Perl-PO.t-41- my $stderr = capture_stderr {
ledgersmb-1.6.9+ds/xt/06.1-Perl-PO.t:42: system("echo \"$file\" | utils/devel/extract-perl >/dev/null");
ledgersmb-1.6.9+ds/xt/06.1-Perl-PO.t-43- };
##############################################
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-58- my $db = $test->{test_data}->test_db;
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm:59: system("dropdb '$db' 2>/dev/null");
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm:60: system("createdb '$db' -T '$ENV{LSMB_NEW_DB}'");
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-61-}
##############################################
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-78-
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm:79: my $returnstring = `psql '$db' -c "SELECT 1 FROM pg_database WHERE datname='$db'"`;
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-80- my $testval = grep { /^ +1$/ } split /\n/, $returnstring;
##############################################
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-83- $! = undef; # reset if system failed
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm:84: system("psql $db -f $sqlfile");
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-85- ok(! $!, "psql run file succeeded");
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-86-
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm:87: $returnstring = `psql '$db' -c "SELECT COUNT(*), 'TESTRESULT' from account"`;
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-88- if ( $returnstring ) {
##############################################
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-105- my $db = $test->{test_data}->test_db;
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm:106: system("dropdb '$db'");
ledgersmb-1.6.9+ds/xt/41-coaload/TestsFor/COATest.pm-107- $test->next::method; # # optional to call parent test_shutdown
##############################################
ledgersmb-1.6.9+ds/xt/42-account.pg-71--- FROM account_link_description
ledgersmb-1.6.9+ds/xt/42-account.pg:72:-- WHERE description = $1
ledgersmb-1.6.9+ds/xt/42-account.pg-73--- GROUP BY description;
##############################################
ledgersmb-1.6.9+ds/xt/43-schema-upgrades.t-192-check 'test_failure',
ledgersmb-1.6.9+ds/xt/43-schema-upgrades.t:193: query => q{SELECT * FROM defaults WHERE value = '$LedgerSMB::VERSION'},
ledgersmb-1.6.9+ds/xt/43-schema-upgrades.t-194- description => 'test',
##############################################
ledgersmb-1.6.9+ds/xt/89-dropdb.t-28-cmp_ok($db, 'eq', $ENV{LSMB_NEW_DB}, 'Got expected db name out') &&
ledgersmb-1.6.9+ds/xt/89-dropdb.t:29:ok(!system ("dropdb $ENV{LSMB_NEW_DB}"), 'dropped db') &&
ledgersmb-1.6.9+ds/xt/89-dropdb.t-30-ok(close ($DBLOCK), 'Closed db lock file') &&
##############################################
ledgersmb-1.6.9+ds/xt/lib/Pherkin/Extension/ledgersmb_steps/common_steps.pl-207- my $part_props = S->{ext_lsmb}->admin_dbh->selectrow_hashref(
ledgersmb-1.6.9+ds/xt/lib/Pherkin/Extension/ledgersmb_steps/common_steps.pl:208: qq|SELECT * FROM parts WHERE partnumber = ?|, undef, $part);
ledgersmb-1.6.9+ds/xt/lib/Pherkin/Extension/ledgersmb_steps/common_steps.pl-209-
##############################################
ledgersmb-1.6.9+ds/debian/adm/config-lsmb-db-user.sh-29- FROM pg_roles
ledgersmb-1.6.9+ds/debian/adm/config-lsmb-db-user.sh:30: WHERE rolname = '$LSMBDBUSER';
ledgersmb-1.6.9+ds/debian/adm/config-lsmb-db-user.sh-31-