BUSINESS_UNITINTERUNIT_IDN=No
Y=Yes
Y/N Table Edit
INV_RCV_OWN2_VW(SQL View) |
Index Back |
|---|---|
Receipt view |
| SELECT DISTINCT inv.business_unit , inv.interunit_id , phys.non_own_flag FROM ps_demand_phys_inv phys , PS_IN_DEMAND inv WHERE phys.business_unit = inv.business_unit AND phys.demand_source = inv.demand_source AND phys.source_bus_unit = inv.source_bus_unit AND phys.order_no = inv.order_no AND phys.order_int_line_no = inv.order_int_line_no AND phys.sched_line_nbr = inv.sched_line_nbr AND phys.demand_line_no = inv.demand_line_no AND phys.inv_item_id = inv.inv_item_id AND Phys.qty_picked > 0 AND inv.in_fulfill_state IN ('60','70') AND inv.interunit_flg = 'Y' AND inv.interunit_stat = 'I' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INTERUNIT_ID |
Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 3 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No Y=Yes Y/N Table Edit |