SOURCE_BUS_UNITINTERUNIT_IDINTERUNIT_LINEINV_ITEM_IDINV_LOT_IDINV_IURV_LOT_VW(SQL View) |
Index Back |
|---|---|
IURV Lot Prompt ViewInterunit Receiving Lot Prompt View |
| SELECT DISTINCT S.BUSINESS_UNIT , S.INTERUNIT_ID , S.INTERUNIT_LINE , S.INV_ITEM_ID , D.INV_LOT_ID FROM PS_IN_DEMAND S , PS_DEMAND_PHYS_INV D WHERE S.IN_FULFILL_STATE BETWEEN '60' AND '70' AND S.INTERUNIT_FLG = 'Y' AND S.INTERUNIT_STAT = 'I' AND %Join(COMMON_KEYS, IN_DEMAND S, DEMAND_PHYS_INV D) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 2 | INTERUNIT_ID |
Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 3 | INTERUNIT_LINE |
Number(5,0) | INTEGER NOT NULL | InterUnit Order Line |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | INV_LOT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Lot ID |