BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AM_NONVW
ASSET_IDDefault Value: NEXT
ASSET_ALL_VW1(SQL View) |
Index Back |
|---|---|
Asset General Information. |
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , C.LOCATION FROM PS_ASSET A , PS_ASSET_LOCATION C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.ASSET_ID = C.ASSET_ID 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) |
| # | 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_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Default Value: NEXT |
| 3 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |