|
SELECT F.OPRID , F.INQUIRY , A.BUSINESS_UNIT , B.LEDGER_GROUP , A.ACCOUNT , A.DEPTID , %subrec(CF9A_AK_SBR, A) , %subrec(CFCC1_AK_SBR, A) , A.STATISTICS_CODE , J.FISCAL_YEAR , J.ACCOUNTING_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_SUMP_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 = 'S' AND G.BUSINESS_UNIT = A.BUSINESS_UNIT AND J.CALENDAR_ID = F.CALENDAR_ID AND K.SETCNTRLVALUE = A.BUSINESS_UNIT AND K.RECNAME = 'CAL_SUMP_TBL' AND J.SETID = K.SETID AND J.FISCAL_YEAR = A.FISCAL_YEAR AND A.ACCOUNTING_PERIOD BETWEEN J.DETL_PERIOD_FROM AND J.DETL_PERIOD_TO AND (F.INCLUDE_CLOSE_PER = 'Y' OR (F.INCLUDE_CLOSE_PER = 'N' AND A.KK_BUDG_TRANS_TYPE <> '4' )) AND ( (F.FISCAL_YEAR_FROM = 0 AND F.PERIOD_FROM = 0 AND F.FISCAL_YEAR_TO <> 0 AND F.PERIOD_TO <> 0 AND ( (A.FISCAL_YEAR = F.FISCAL_YEAR_TO AND J.ACCOUNTING_PERIOD <= F.PERIOD_TO) OR (A.FISCAL_YEAR < F.FISCAL_YEAR_TO) ) ) OR (F.FISCAL_YEAR_FROM = 0 AND F.PERIOD_FROM = 0 AND F.FISCAL_YEAR_TO = 0 AND F.PERIOD_TO = 0 ) OR (F.FISCAL_YEAR_FROM <> 0 AND F.PERIOD_FROM <> 0 AND F.FISCAL_YEAR_TO <> 0 AND F.PERIOD_TO <> 0 AND F.FISCAL_YEAR_FROM = F.FISCAL_YEAR_TO AND A.FISCAL_YEAR = F.FISCAL_YEAR_FROM AND J.ACCOUNTING_PERIOD BETWEEN F.PERIOD_FROM AND F.PERIOD_TO ) OR (F.FISCAL_YEAR_FROM <> 0 AND F.PERIOD_FROM <> 0 AND F.FISCAL_YEAR_TO <> 0 AND F.PERIOD_TO <> 0 AND F.FISCAL_YEAR_FROM <> F.FISCAL_YEAR_TO AND ( (A.FISCAL_YEAR = F.FISCAL_YEAR_FROM AND J.ACCOUNTING_PERIOD >= F.PERIOD_FROM) OR (A.FISCAL_YEAR = F.FISCAL_YEAR_TO AND J.ACCOUNTING_PERIOD <= F.PERIOD_TO) OR (A.FISCAL_YEAR > F.FISCAL_YEAR_FROM AND A.FISCAL_YEAR < F.FISCAL_YEAR_TO) ) ) ) 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