RE_OPEXADT_SRCH(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 , 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) |
# | 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 |