1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
SELECT OPERA_ACCTNG_POST_KF.TTY_NO, OPERA_ACCTNG_POST_KF.TTY_NAM, OPERA_ACCTNG_POST_KF.START_PD, OPERA_PD.END_PD, OPERA_ACCTNG_POST_KF.ACCTNG_YR_END_DAY, OPERA_ACCTNG_POST_KF.SECT_POS, OPERA_ACCTNG_POST_KF.CMP_ID, OPERA_ACCTNG_POST_KF.FINAN_YR_ID, IIf([OPERA_ACCTNG_POST_KF].[FINAN_MNTH]<=3,1,IIf([OPERA_ACCTNG_POST_KF].[FINAN_MNTH]<=6,2,IIf([OPERA_ACCTNG_POST_KF].[FINAN_MNTH]<=9,3,4))) AS FINAN_QRT_ID, OPERA_ACCTNG_POST_KF.GLBL_AU_ID, OPERA_ACCTNG_POST_KF.GLBL_AU_CODE, GCODE_BUSI_CLAS_LAST.LNAM AS BUSI_CLAS_LNAM, OPERA_ACCTNG_POST_KF.ACCTNG_NO, OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE, OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_ID, OPERA_ACCTNG_POST_KF.RELEA_DAT, OPERA_ACCTNG_POST_KF.ORIGN_ID, OPERA_ACCTNG_POST_KF.ORIG_CCY_ID, OPERA_ACCTNG_POST_KF.RATE_MNTH, OPERA_ACCTNG_POST_KF.BUSI_TYP_ID, GCODE_BUSI_TYP_LAST.LNAM AS BUSI_TYP_LNAM, OPERA_ACCTNG_POST_KF.FI_POST_DAT, OPERA_ACCTNG_POST_KF.ACCTNG_YR_ID, OPERA_ACCTNG_POST_KF.ACCTNG_PD_ID, GCODE_ACCTNG_PD_LAST.REPORT_ACCTNG_PD_ID, OPERA_ACCTNG_POST_KF.BOK_ID, GCODE_BOK_LAST.CODE AS BOK_CODE, GCODE_BOK_LAST.LNAM AS BOK_LNAM, OPERA_ACCTNG_POST_KF.ORIG_AMNT, OPERA_ACCTNG_POST_KF.KYFIG_ID, OPERA_ACCTNG_POST_KF.KYFIG_CODE, GCODE_KYFIG_LAST.AGRG_LEVL AS KYFIG_AGRG_LEVL, GCODE_KYFIG_LAST.SYS_ID AS KYFIG_SYS_ID, GCODE_KYFIG_LAST.SYS_CODE AS KYFIG_SYS_CODE, GCODE_AREA_LAST.LNAM AS AREA_LNAM, OPERA_ACCTNG_POST_KF.ESTM_CODE, GCODE_FAS_TYP_LAST.CODE AS FAS_TYP_CODE, OPERA_ACCTNG_POST_KF.SAP_ACCTNG_CEDT_UIN AS SAP_CNTRCT_PARTN_UIN, OPERA_SECT.CCY_ID AS CCY_UPL_ID, GCODE_TTY_STATUS_LAST.CODE AS TTY_STATUS_CODE, OPERA_ACCTNG_POST_KF.TAD_RSPN AS TAD_ORG_POS_CODE, OPERA_ACCTNG_POST_KF.UW_RSPN AS UW_ORG_POS_CODE, OPERA_ACCTNG_POST_KF.ORG_UNIT_CODE_RSPN AS REPORT_LINE_CODE, OPERA_ACCTNG_POST_KF.TTY_DIREC_CODE, GCODE_ACCTNG_PD_LAST.ACTIV_VF, GCODE_CMP_LAST.LOCL_CCY_ID, GCODE_FE_TMPLT_LAST.LNAM AS ESTM_TMPLT_CODE
FROM GCODE_FE_TMPLT_LAST INNER JOIN
(OPERA_SECT_HD INNER JOIN (GCODE_CMP_LAST INNER JOIN
(GCODE_FAS_TYP_LAST INNER JOIN (OPERA_SECT INNER JOIN ((GCODE_TTY_STATUS_LAST INNER JOIN
(GCODE_AREA_LAST INNER JOIN
(GCODE_BOK_LAST INNER JOIN (GCODE_ACCTNG_PD_LAST INNER JOIN
(GCODE_BUSI_CLAS_LAST INNER JOIN (OPERA_PD INNER JOIN
(GCODE_KYFIG_LAST INNER JOIN
OPERA_ACCTNG_POST_KF ON GCODE_KYFIG_LAST.ID = OPERA_ACCTNG_POST_KF.KYFIG_ID) ON (OPERA_PD.CLNT_ID = OPERA_ACCTNG_POST_KF.CLNT_ID) AND (OPERA_PD.TTY_NO = OPERA_ACCTNG_POST_KF.TTY_NO) AND (OPERA_PD.START_PD = OPERA_ACCTNG_POST_KF.START_PD)) ON GCODE_BUSI_CLAS_LAST.ID = OPERA_ACCTNG_POST_KF.BUSI_CLAS_ID) ON GCODE_ACCTNG_PD_LAST.ID = OPERA_ACCTNG_POST_KF.ACCTNG_PD_ID) ON GCODE_BOK_LAST.ID = OPERA_ACCTNG_POST_KF.BOK_ID) ON GCODE_AREA_LAST.ID = OPERA_ACCTNG_POST_KF.AREA_ID) ON GCODE_TTY_STATUS_LAST.ID = OPERA_PD.TTY_STATUS_ID)
INNER JOIN GCODE_BUSI_TYP_LAST ON OPERA_ACCTNG_POST_KF.BUSI_TYP_ID = GCODE_BUSI_TYP_LAST.ID) ON (OPERA_SECT.TTY_NO = OPERA_ACCTNG_POST_KF.TTY_NO) AND (OPERA_SECT.START_PD = OPERA_ACCTNG_POST_KF.START_PD)) ON GCODE_FAS_TYP_LAST.ID = OPERA_SECT.FAS_TYP_ID) ON GCODE_CMP_LAST.ID = OPERA_ACCTNG_POST_KF.CMP_ID) ON OPERA_SECT_HD.TTY_NO = OPERA_SECT.TTY_NO) ON GCODE_FE_TMPLT_LAST.ID = OPERA_SECT_HD.FE_TMPLT_ID
WHERE (((OPERA_ACCTNG_POST_KF.CMP_ID)=cmp_code()) AND ((OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='R' Or (OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='P' Or (OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='B_R') AND ((OPERA_ACCTNG_POST_KF.KYFIG_ID)=1066) AND ((GCODE_KYFIG_LAST.SYS_ID)=2) AND ((GCODE_ACCTNG_PD_LAST.ACTIV_VF)<>#1/1/1950#)) OR (((OPERA_ACCTNG_POST_KF.CMP_ID)=cmp_code()) AND ((OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='R' Or (OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='P' Or (OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='B_R') AND ((OPERA_ACCTNG_POST_KF.BOK_ID)<>'510') AND ((GCODE_KYFIG_LAST.AGRG_LEVL)=9) AND ((GCODE_KYFIG_LAST.SYS_ID)=11) AND ((GCODE_ACCTNG_PD_LAST.ACTIV_VF)<>#1/1/1950#)) OR (((OPERA_ACCTNG_POST_KF.CMP_ID)=cmp_code()) AND ((OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='R' Or (OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='P' Or (OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='B_R') AND ((OPERA_ACCTNG_POST_KF.KYFIG_ID)=10081) AND ((GCODE_KYFIG_LAST.SYS_ID)=4) AND ((GCODE_ACCTNG_PD_LAST.ACTIV_VF)<>#1/1/1950#)) OR (((OPERA_ACCTNG_POST_KF.CMP_ID)=cmp_code()) AND ((OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='R' Or (OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='P' Or (OPERA_ACCTNG_POST_KF.ACCTNG_STATUS_CODE)='B_R') AND ((OPERA_ACCTNG_POST_KF.KYFIG_ID)=10087) AND ((GCODE_KYFIG_LAST.SYS_ID)=5) AND ((GCODE_ACCTNG_PD_LAST.ACTIV_VF)<>#1/1/1950#)); |
Partager