RY_RPT_IR_LVW

(SQL View)
 Index Back

Dialog View

Dialog View Record (related language record) - OLM - for interactive reporting

SELECT A.BUSINESS_UNIT , A.DIALOG_ID , B.LANGUAGE_CD , B.RY_DIALOG_NAME , B.DESCR254 FROM PS_RY_DIALOG A , PS_RY_DLG_VW_LNG B WHERE A.DIALOG_ID = B.DIALOG_ID AND A.RY_DIALOG_STATUS IN ('A', 'P', 'S', 'I','Z')

  • Related Language Record for RY_RPT_IR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254