ST_BRNC_VWLNG

(SQL View)
 Index Back

Non-Captive Broker

%RECNAME_EDIT2 prompt view.

SELECT DISTINCT A.STOCK_ID ,A.ST_BROKERAGE_ID ,A.ST_BRANCH_ID ,B.LANGUAGE_CD ,B.DESCR FROM PS_STOCK_BRNCH_DTL A , PS_ST_BRANCH_LANG B WHERE A.ST_BROKERAGE_ID = B.ST_BROKERAGE_ID AND A.ST_BRANCH_ID = B.ST_BRANCH_ID AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_STOCK_BRNCH_DTL AA WHERE AA.STOCK_ID = A.STOCK_ID AND AA.ST_BROKERAGE_ID = A.ST_BROKERAGE_ID AND AA.ST_BRANCH_ID = A.ST_BRANCH_ID AND AA.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_ST_BRKR_BRANCH BB WHERE BB.ST_BROKERAGE_ID = B.ST_BROKERAGE_ID AND BB.ST_BRANCH_ID = B.ST_BRANCH_ID AND BB.EFFDT <= %CurrentDateIn )

  • Related Language Record for ST_BRNC_ADMN_VW ST_BRNC_OPTN_VW ST_BRNC_PRCH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

    Prompt Table: STOCK_TBL

    2 ST_BROKERAGE_ID Character(10) VARCHAR2(10) NOT NULL Brokerage ID
    3 ST_BRANCH_ID Character(10) VARCHAR2(10) NOT NULL Branch Identification
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description