BUSINESS_UNITDefault Value: QS_APP_BU.BUSINESS_UNIT
QS_APP_CONTEXTDefault Value: QS_APP_BU.QS_APP_CONTEXT
INV_ITEM_IDQS_QCP_INV_VW(SQL View) |
Index Back |
|---|---|
Inventory IDs used in QCPlansrre 05/30/00 ST Added lang vw qs_qcp_inv_lvw |
| SELECT DISTINCT a.BUSINESS_UNIT , a.QS_APP_CONTEXT , a.INV_ITEM_ID , b.DESCR FROM PS_QS_STREAM_ROOT a ,PS_MASTER_ITEM_TBL b , PS_SET_CNTRL_REC c WHERE (c.RECNAME = 'QS_MST_ITEM_VW' AND b.INV_ITEM_ID = a.INV_ITEM_ID AND c.SETCNTRLVALUE = a.BUSINESS_UNIT AND b.SETID = c.SETID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: QS_APP_BU.BUSINESS_UNIT |
| 2 | QS_APP_CONTEXT |
Character(18) | VARCHAR2(18) NOT NULL |
QC application context identifier
Default Value: QS_APP_BU.QS_APP_CONTEXT |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |