01.
$query
= <<<SQL
02.
SELECT
03.
A.T\
$BPID
AS CUSTID,
04.
A.T\
$NAMA
AS CUSTDESC,
05.
A.T\
$SEAK
AS CUSTDESC1,
06.
TRIM(B.T\
$LN02
) AS ADDRESS,
07.
B.T\
$LN03
AS LN03,
08.
B.T\
$LN04
AS LN04,
09.
B.T\
$LN05
AS LN05,
10.
SUBSTR
(A.T\
$BPID
,2,2) AS CUSTWHS,
11.
C.T\
$SOTP
,
12.
TRIM(C.T\
$CPLS
) AS PRICEGP,
13.
D.T\
$CRLR
AS CRADITLIM,
14.
SUBSTR
(D.T\
$CPAY
,2,2) AS CREDITERN,
15.
A.T\
$SNDR
AS NEW_CUST
16.
17.
FROM ttccom100100 A
18.
JOIN ttccom130100 B ON A.T\
$CADR
= B.T\
$CADR
19.
JOIN ttccom110100 C ON A.T\
$BPID
= C.T\
$OFBP
20.
JOIN ttccom112100 D ON A.T\
$BPID
= D.T\
$ITBP
21.
22.
WHERE A.T\
$PRST
= 2 AND A.T\
$BPRL
= 2
23.
AND (A.T\
$BPID
BETWEEN
'$business_from'
AND
'$business_to'
)
24.
25.
ORDER BY A.T\
$BPID
ASC
26.
SQL;