UDF_ITM_LOAD_VW(SQL View) |
Index Back |
|---|---|
Item Load View |
| SELECT BU.BUSINESS_UNIT ,'N' ,BU.INV_ITEM_ID ,INV.DESCR ,INV.INV_ITEM_GROUP ,INV.INV_PROD_FAM_CD , INV.UNIT_MEASURE_STD ,INV.SERIAL_CONTROL ,INV.LOT_CONTROL ,BU.STAGED_DATE_FLAG ,INV.CFG_CODE_OPT ,'N' ,BU.ITM_STATUS_CURRENT FROM PS_BU_ITEMS_INV BU ,PS_MASTER_ITEM_TBL INV WHERE BU.INV_ITEM_ID = INV.INV_ITEM_ID |
| # | 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_BUIN_NONVW |
| 2 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_VW |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 5 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL |
Item Group
Prompt Table: INV_ITEM_GROUP |
| 6 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL |
Family
Prompt Table: INV_ITEM_FAM |
| 7 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 8 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 9 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |
| 10 | STAGED_DATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Staged Date Control
N=Staged Date Tracking OFF Y=Staged Date Tracking ON |
| 11 | CFG_CODE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Configuration Code Generation
B=Both N=No Y=Yes |
| 12 | HIDE_PB | Character(1) | VARCHAR2(1) NOT NULL |
Hide Chart
Y/N Table Edit |
| 13 | ITM_STATUS_CURRENT | Character(1) | VARCHAR2(1) NOT NULL |
Item Status Current
1=Active 2=Hold 3=Discontinue 4=Inactive 5=Pending Approval 6=Denied Approval 7=Under Initialization |