JV_BUS_SRCH(SQL View) |
Index Back |
---|---|
J.V. Business Unit SearchTable |
Select a.Business_unit, b.Descr From PS_BUS_UNIT_TBL_AM a, ps_bus_unit_tbl_fs b Where a.business_unit = b.business_unit and a.jv_unit_sw = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_JV_BUS_NONVW |
|
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |