RE_OPEXADT_SRCH

(SQL View)
Index Back

Opex Audit Search View

View for the Search Record

SELECT L.BUSINESS_UNIT , A.FROM_DATE , A.TO_DATE , L.LS_NBR , A.PRINCIPAL_ID , A.LS_KEY , A.OPEXAUDIT_ID , B.REVISION_NBR , L.LEASE_OBLG , L.LEASE_NAME , P.PROPERTY_NM , A.OPEXAUDIT_STS , A.AUDIT_STATUS FROM PS_RE_LS L LEFT OUTER JOIN PS_RE_PROPERTY P ON (P.PROPERTY_ID = L.PRIM_PROPERTY_ID) , PS_RE_OPEXAUDIT A ,PS_RE_OPEXADT_REV B WHERE L.LS_KEY = A.LS_KEY AND B.REVISION_NBR = ( SELECT MAX(C.REVISION_NBR) FROM PS_RE_OPEXADT_REV C WHERE A.OPEXAUDIT_ID = C.OPEXAUDIT_ID)

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

    Default Value: RE_OPR_BU.BUSINESS_UNIT

    Prompt Table: SP_BU_RE_NONVW

    2 FROM_DATE Date(10) DATE NOT NULL From Date
    3 TO_DATE Date(10) DATE NOT NULL To Date
    4 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number

    Prompt Table: RE_LS_AEH_VW

    5 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Lessor/Lessee

    Prompt Table: %EDITTABLE

    6 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
    7 OPEXAUDIT_ID Number(15,0) DECIMAL(15) NOT NULL Primary Key for Operating Expense Audit (Auto Generated Number)
    8 REVISION_NBR Number(3,0) SMALLINT NOT NULL Sales Report Revision Number - Number (3)
    9 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
    1=Payables
    2=Receivables
    10 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name
    11 PROPERTY_NM Character(50) VARCHAR2(50) NOT NULL Used to store an Asset Property Name
    12 OPEXAUDIT_STS Character(1) VARCHAR2(1) NOT NULL Operating Expense Audit Status
    1=Pending
    2=Processed
    3=Pending Approval
    13 AUDIT_STATUS Character(10) VARCHAR2(10) NOT NULL Operating Expense Audit Status Field