2 queries found for "Service Type Language"

Retrieve Account's Active SAs linked to SP with Same Service Type

SELECT A.SA_ID, B.SA_TYPE_CD, B.CIS_DIVISION, C. SVC_TYPE_CD, C.DESCR
FROM CI_SA A, CI_SA_TYPE B, CI_SVC_TYPE_L C
WHERE A.ACCT_ID = 'INSERT_ACCOUNT_ID'
AND A.SA_STATUS_FLG = '20'
AND A.CIS_DIVISION = B.CIS_DIVISION 
AND A.SA_TYPE_CD = B.SA_TYPE_CD 
AND B.ALLOW_SP_SW = 'Y'
AND B.SVC_TYPE_CD = C.SVC_TYPE_CD 
AND C.LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'

uploaded by Nuno Rodrigues

Get Bill's Bill Segment Amount

SELECT
  SVCTYPEL.SVC_TYPE_CD, 
  SVCTYPEL.DESCR, 
  SUM(FT.CUR_AMT) AS CUR_AMT_SUM
FROM
  CI_SVC_TYPE SVCTYPE, 
  CI_SVC_TYPE_L SVCTYPEL, 
  CI_SA_TYPE SATY, 
  CI_SA SA, 
  CI_FT FT
WHERE 
  FT.BILL_ID = 'INSERT_BILL_ID'
  AND FT.PARENT_ID = FT.BILL_ID
  AND FT.FT_TYPE_FLG IN ('BS','BX')
  AND FT.FREEZE_SW = 'Y'
  AND FT.SHOW_ON_BILL_SW = 'Y'
  AND FT.SA_ID = SA.SA_ID
  AND SA.CIS_DIVISION = SATY.CIS_DIVISION
  AND SA.SA_TYPE_CD = SATY.SA_TYPE_CD
  AND SATY.SVC_TYPE_CD = SVCTYPE.SVC_TYPE_CD
  AND SVCTYPE.SVC_TYPE_CD = SVCTYPEL.SVC_TYPE_CD
  AND SVCTYPEL.LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
GROUP BY
  SVCTYPEL.SVC_TYPE_CD, 
  SVCTYPEL.DESCR
  

uploaded by Nuno Rodrigues