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