|
|
|
Junior Member
 
Group: Forum Members
Last Login: Today @ 12:27:03 AM
Posts: 24,
Visits: 100
|
|
INSERT INTO ${ETLVMDB}.TMP_T245235B
(
ACCT_ID,
CALL_USAGE_CHRGS,
SRVC_AND_EQUIP_CHRGS,
OTHR_CHRGS,
DT_ID
)
SELECT
TB.ACCT_ID,
(ZEROIFNULL(WRLN_BILL_CT_NET_AM) + ZEROIFNULL(WRLN_BILL_CT_GST_AM)) ,
(ZEROIFNULL(WRLN_BILL_RC_NET_AM) + ZEROIFNULL(WRLN_BILL_RC_GST_AM)) ,
(ZEROIFNULL(WRLN_BILL_NRC_GST_AM)+ ZEROIFNULL(WRLN_BILL_NRC_NET_AM)),
ABSD.DT_ID
FROM
${ETLVMDB}.TMP_T245215 TB
INNER JOIN
${VMDB}.AGG_BILL_SUBTN_DT ABSD
ON
TB.ACCT_ID = ABSD.ACCT_ID;
|
|
|
|