RECV_AM_TAG_VW(SQL View) |
Index Back |
---|---|
Receive Asset Tag view |
SELECT A.BUSINESS_UNIT , A.TAG_NUMBER FROM PS_ASSET A , PS_BUS_UNIT_TBL_AM B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.ALLOW_DUP_TAGS_SW = 'N' AND A.TAG_NUMBER <> ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
2 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |