BUS_UNIT_SOURCEINTERUNIT_IDINV_RECV_IUT_VW(SQL View) |
Index Back |
|---|---|
Inv Recv interunit view |
| SELECT DISTINCT business_unit , interunit_id , destin_bu FROM PS_IN_DEMAND WHERE interunit_flg = 'Y' AND interunit_stat = 'I' AND in_fulfill_state >= '60' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUS_UNIT_SOURCE |
Character(5) | VARCHAR2(5) NOT NULL | Source Business Unit |
| 2 | INTERUNIT_ID |
Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 3 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |