BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
INV_ITEM_IDPrompt Table: MG_ITEM_PDO_VW
EN_PDO_ITM_VW(SQL View) |
Index Back |
|---|---|
Items with Production Options09/23/98 SCC CN#EN800-4.0: Items with Production Options |
| select distinct a.business_unit, a.inv_item_id, c.descr60, c.descr, b.ref_routing_item from ps_bu_items_inv b, PS_MASTER_ITEM_TBL c, ps_set_cntrl_rec d, ps_en_pdo_bom_rtg a where a.business_unit = b.business_unit and a.inv_item_id = b.inv_item_id and b.inv_item_id = c.inv_item_id and b.business_unit = d.setcntrlvalue and d.recname = 'MASTER_ITEM_TBL' and c.setid = d.setid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MG_ITEM_PDO_VW |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |