BUSINESS_UNITDefault Value: RE_OPR_BU.BUSINESS_UNIT
Prompt Table: SP_BU_RE_NONVW
FROM_DATETO_DATELS_NBRPrompt Table: RE_LS_AEH_VW
PRINCIPAL_IDPrompt Table: %EDITTABLE
LANGUAGE_CDRE_OPEX_SRCH_LG(SQL View) |
Index Back |
|---|---|
Opex Audit Search ViewView for the Search Record |
| SELECT L.BUSINESS_UNIT , A.FROM_DATE , A.TO_DATE , L.LS_NBR , A.PRINCIPAL_ID , LG.LANGUAGE_CD , L.LEASE_NAME , LG.PROPERTY_NM FROM PS_RE_LS L , PS_RE_OPEXAUDIT A , PS_RE_PROPERTY P , PS_RE_PROPERTY_LG LG WHERE L.LS_KEY = A.LS_KEY AND P.PROPERTY_ID = L.PRIM_PROPERTY_ID AND LG.PROPERTY_ID = P.PROPERTY_ID |
| # | 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 |
Landlord ID
Prompt Table: %EDITTABLE |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 8 | PROPERTY_NM | Character(50) | VARCHAR2(50) NOT NULL | Used to store an Asset Property Name |