SP_LEDGPC_NONVW

(SQL View)
 Index Back

BU Ledger Group Non-secure vw

Non-secure view for PC_LED_GRP_VW.

SELECT A.BUSINESS_UNIT , A.LEDGER_GROUP , A.LEDGER_TYPE , B.DESCR FROM PS_BU_LED_GRP_TBL A , PS_LED_GRP_TBL B , PS_SET_CNTRL_REC C , PS_FIN_OPEN_MIN_VW D , PS_FIN_OPEN_MAX_VW E WHERE A.LEDGER_GROUP = B.LEDGER_GROUP AND B.SETID = C.SETID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'LED_GRP_TBL' AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND ((A.LEDGER_TYPE <> 'K' AND D.LEDGER_GROUP = A.LEDGER_GROUP AND E.LEDGER_GROUP = A.LEDGER_GROUP) OR (A.LEDGER_TYPE = 'K' AND D.LEDGER_GROUP = A.ASSOCIATED_LED_GRP AND E.LEDGER_GROUP = A.ASSOCIATED_LED_GRP))

  • Related Language Record: SP_LEDGPC_NONLV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    3 LEDGER_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
    D=Detail Ledger
    K=Commitment Control Ledger
    S=Summary Ledger
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description