|
SELECT F.OPRID , F.INQUIRY , A.BUSINESS_UNIT , B.LEDGER_GROUP , A.ACCOUNT , A.DEPTID , %subrec(CF9A_AK_SBR, A) , %subrec(CFCC2_AK_SBR, A) , A.STATISTICS_CODE , J.BUDGET_PERIOD , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 FROM PS_LEDGER_KK A , PS_LED_GRP_LED_TBL B , PS_SET_CNTRL_REC C , PS_SET_CNTRL_REC D , PS_SET_CNTRL_REC E , PS_KK_INQ_LDTS_TMP F , PS_KK_INQ_LD_CRIT G , PS_CAL_BPS_TBL J , PS_SET_CNTRL_REC K WHERE A.LEDGER = B.LEDGER AND B.SETID = E.SETID AND E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'LED_GRP_TBL' AND A.CURRENCY_CD > ' ' AND A.CURRENCY_CD = A.BASE_CURRENCY AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'KK_BD_TYPE_VW' AND D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'GL_ACCT_ALL_VW' AND F.LEDGER_GROUP = B.LEDGER_GROUP AND F.SELECT_ROW_FLAG = 'Y' AND G.OPRID = F.OPRID AND G.INQUIRY = F.INQUIRY AND G.KK_INQ_CAL_TYPE = 'I' AND G.BUSINESS_UNIT = A.BUSINESS_UNIT AND J.CALENDAR_ID = F.CALENDAR_ID AND K.SETCNTRLVALUE = A.BUSINESS_UNIT AND K.RECNAME = 'CAL_BPS_TBL' AND J.SETID = K.SETID AND A.BUDGET_PERIOD BETWEEN J.BP_FROM AND J.BP_TO AND ( (F.BP_FROM = ' ' AND F.BP_TO = ' ') OR (F.BP_FROM <> ' ' AND F.BP_TO <> ' ' AND F.BP_FROM <> F.BP_TO AND J.BUDGET_PERIOD BETWEEN F.BP_FROM AND F.BP_TO) OR (F.BP_FROM = ' ' AND F.BP_TO <> ' ' AND J.BUDGET_PERIOD <= F.BP_TO) OR (F.BP_FROM <> ' ' AND F.BP_TO = ' ' AND J.BUDGET_PERIOD >= F.BP_FROM) OR (F.BP_FROM = F.BP_TO AND F.BP_FROM <> ' ' AND J.BUDGET_PERIOD = F.BP_FROM) ) AND ( F.INCLUDE_CLOSE_PER = 'Y' OR (F.INCLUDE_CLOSE_PER = 'N' AND A.ACCOUNTING_PERIOD <> 999 AND A.KK_BUDG_TRANS_TYPE <> '4' ) ) AND A.ACCOUNT NOT IN ( SELECT H.ACCOUNT FROM PS_KK_BD_OFFSET H WHERE H.SETID1 = C.SETID AND H.LEDGER_GROUP = B.LEDGER_GROUP AND H.SETID = D.SETID) AND A.ACCOUNT NOT IN ( SELECT I.ACCOUNT FROM PS_KK_TRX_OFFSET I WHERE I.SETID1 = C.SETID AND I.LEDGER_GROUP = B.LEDGER_GROUP AND I.SETID = D.SETID)
|
OPRID