INSTR_FX_VW

(SQL View)
 Index Back

FX Swapping Instruments

List the fx instruments available during the swapping process

SELECT DISTINCT H.SETID ,H.INSTRUMENT_TYPE ,H.INSTRMNT_TEMPLATE ,MAX(H.DESCR60) FROM PS_INSTR_HEADER_TR H ,PS_INSTR_DETAIL_TR D WHERE D.SETID = H.SETID AND D.INSTRUMENT_TYPE = H.INSTRUMENT_TYPE AND D.INSTRMNT_TEMPLATE = H.INSTRMNT_TEMPLATE AND H.INSTRMNT_TEMPLATE = ' ' GROUP BY H.SETID, H.INSTRUMENT_TYPE, H.INSTRMNT_TEMPLATE HAVING COUNT(*) = 1 AND MAX(INSTRMNT_BASE_TYPE) = '03'

  • Related Language Record: INSTR_FX_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type
    3 INSTRMNT_TEMPLATE Character(10) VARCHAR2(10) NOT NULL A unique key identifier associated with an instrument that describes a separate template version of a pre
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description