AM_HGRID_RPT_VW(SQL View) |
Index Back |
|---|---|
Asset Hierarchy Move ReportAsset Hierarchy Move Report View |
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.FINANCIAL_ASSET_SW , B.CUSTODIAN , B.EMPLID , B.DEPTID , C.LOCATION ,C.AREA_ID FROM PS_ASSET A , PS_ASSET_CUSTODIAN B , PS_ASSET_LOCATION C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND A.ASSET_ID = C.ASSET_ID AND B.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_ASSET_CUSTODIAN Z WHERE Z.BUSINESS_UNIT = A.BUSINESS_UNIT AND Z.ASSET_ID = A.ASSET_ID AND Z.EFFDT <= %CurrentDateIn) AND B.EFFSEQ = ( SELECT MAX(G.EFFSEQ) FROM PS_ASSET_CUSTODIAN G WHERE G.BUSINESS_UNIT = A.BUSINESS_UNIT AND G.ASSET_ID = A.ASSET_ID AND G.EFFDT = B.EFFDT) AND C.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_ASSET_LOCATION X WHERE X.BUSINESS_UNIT = A.BUSINESS_UNIT AND X.ASSET_ID = A.ASSET_ID AND X.EFFDT <= %CurrentDateIn) AND C.EFFSEQ = ( SELECT MAX(Y.EFFSEQ) FROM PS_ASSET_LOCATION Y WHERE Y.BUSINESS_UNIT = A.BUSINESS_UNIT AND Y.ASSET_ID = A.ASSET_ID AND Y.EFFDT = C.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | FINANCIAL_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap Y=Capitalize |
| 4 | CUSTODIAN | Character(30) | VARCHAR2(30) NOT NULL | Custodian |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 7 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 8 | AREA_ID | Character(10) | VARCHAR2(10) NOT NULL | Area ID |