Use for UPG_KK_RECON. This is basically a clone of SP_KKBULG_NONVW, which was originally used as the prompt table for UPG_RECN_KK_REQ.LEDGER_GROUP, with additional constraint after constraint "AND A.LEDGER_TYPE = 'K'"

SP_KKBULG_RECVW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT ,A.LEDGER_GROUP ,B.DESCR FROM PS_BU_LED_GRP_TBL A , PS_LED_GRP_TBL B WHERE B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'LED_GRP_TBL') AND B.LEDGER_GROUP = A.LEDGER_GROUP AND A.LEDGER_TYPE = 'K' AND A.LEDGER_GROUP NOT IN ('PRMST_EXP', 'PRMST_REV', 'PRACT_EXP', 'PRACT_REV','PRPHS_EXP', 'PRPHS_REV', 'PRSEG_EXP', 'PRSEG_REV')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description