CA_AP_SRCH_LVW

(SQL View)
 Index Back

Preview Revenue Lang View

Language view for contracts Preview Revenue page.

SELECT DISTINCT D.BUSINESS_UNIT , A.CONTRACT_NUM ,A.ACCT_PLAN_ID ,A.CONTRACT_LINE_NUM ,A.EVENT_NUM ,A.DST_SEQ_NUM ,A.DST_USE ,A.DST_ID ,C.LANGUAGE_CD ,C.DESCR FROM PS_CA_AP_SCHEDULE A , PS_CA_AP_EVENT B , PS_CA_DETAIL_LANG C , PS_CA_CONTR_HDR D WHERE A.CONTRACT_NUM = B.CONTRACT_NUM AND A.CONTRACT_NUM = D.CONTRACT_NUM AND A.ACCT_PLAN_ID = B.ACCT_PLAN_ID AND A.EVENT_NUM = B.EVENT_NUM AND A.CONTRACT_NUM = C.CONTRACT_NUM AND A.CONTRACT_LINE_NUM = C.CONTRACT_LINE_NUM AND (B.AP_EVENT_STATUS = 'NEW' OR B.AP_EVENT_STATUS = 'RDY') AND D.CA_RQST_SRC <> 'OND'

  • Related Language Record for CA_AP_SRCH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CNTR_SRCH_VW

    3 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan
    4 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    5 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number
    6 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
    7 DST_USE Character(3) VARCHAR2(3) NOT NULL Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress
    8 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description