OPRIDSETIDPrompt Table: SP_SETTD_NONVW
TD_TREE_ID_PRODTD_TREE_EFFDT_PRODPROMO_GROUPPRODUCT_IDPrompt Table: PROD_ITEM
TD_PROM_P_OPRVW(SQL View) |
Index Back |
|---|---|
Products for a promo groupThis is a secured view of products for a promotional group |
| SELECT B.OPRID , B.SETID , B.TD_TREE_ID , B.EFFDT , B.PROMO_GROUP , B.PRODUCT_ID , C.DESCR FROM PS_TD_TREE_NODE_VW B , PS_PROD_ITEM C WHERE B.SETID = C.SETID AND B.PRODUCT_ID = C.PRODUCT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETTD_NONVW |
| 3 | TD_TREE_ID_PROD |
Character(8) | VARCHAR2(8) NOT NULL | Product Tree ID |
| 4 | TD_TREE_EFFDT_PROD |
Date(10) | DATE | Product Effdt |
| 5 | PROMO_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Promotional Group |
| 6 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_ITEM |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |