BUSINESS_UNITMG_ORIG_COMP_IDSUB_ITM_IDSF_SUB_ITEM_VW(SQL View) |
Index Back |
|---|---|
Item Substitutes ViewEN800-1.0 - Ravi- This view will display all substitute items at BU level for a component in review plan. 09/24/99 CN#EN800-1.0 meg - Added sub_priority_nbr, effdt_from, effdt_to and made them list boxes. Removed field edits. 01/31/01 MEG CN#R-MGENOC-BB6GQ: Added 'Where use_for_manufactur = 'Y' to the viewtext. |
| SELECT DISTINCT BUSINESS_UNIT , INV_ITEM_ID , SUB_ITM_ID , SUB_PRIORITY_NBR , EFFDT_FROM , EFFDT_TO FROM PS_BU_ITEM_SUB WHERE USE_FOR_MANUFACTUR = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | MG_ORIG_COMP_ID |
Character(18) | VARCHAR2(18) NOT NULL | original component ID |
| 3 | SUB_ITM_ID |
Character(18) | VARCHAR2(18) NOT NULL | 11/30/99 RML Added label "Substitute" |
| 4 | SUB_PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | 03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_sub_pri_nbr. |
| 5 | EFFDT_FROM | Date(10) | DATE | Effective Date From |
| 6 | EFFDT_TO | Date(10) | DATE | Effective Date To |