BUSINESS_UNITMFG_ITM_IDPO_RECWB_MFG_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT L.BUSINESS_UNIT ,L.MFG_ITM_ID FROM PS_RECV_HDR H , PS_RECV_LN_SHIP L WHERE H.BUSINESS_UNIT=L.BUSINESS_UNIT AND H.RECEIVER_ID=L.RECEIVER_ID AND L.MFG_ITM_ID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | MFG_ITM_ID |
Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |