|
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 , 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 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 = 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 = 'P' AND G.BUSINESS_UNIT = A.BUSINESS_UNIT AND (( (F.BP_FROM = ' ' AND F.BP_TO = ' ') OR ( F.BP_FROM <> ' ' AND F.BP_TO <> ' ' AND F.BP_FROM <> F.BP_TO AND A.BUDGET_PERIOD BETWEEN F.BP_FROM AND F.BP_TO ) OR ( F.BP_FROM = ' ' AND F.BP_TO <> ' ' AND A.BUDGET_PERIOD <= F.BP_TO ) OR ( F.BP_FROM <> ' ' AND F.BP_TO = ' ' AND A.BUDGET_PERIOD >= F.BP_FROM ) OR ( F.BP_FROM = F.BP_TO AND F.BP_FROM <> ' ' AND A.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 ( F.INCLUDE_ADJ_PER = 'Y' OR (F.INCLUDE_ADJ_PER = 'N' AND A.ACCOUNTING_PERIOD NOT IN ( SELECT M.ACCOUNTING_PERIOD FROM PS_BUL_CNTL_BUD L , PS_FIN_OPEN_ADJ M WHERE M.PSFT_PRODUCT = 'GL' AND L.BUSINESS_UNIT =M.BUSINESS_UNIT AND L.LEDGER_GROUP = M.LEDGER_GROUP AND L.KK_LEDGER_GROUP = B.LEDGER_GROUP AND L.BUSINESS_UNIT = A.BUSINESS_UNIT ) ) ) ) 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