SETIDPRODUCT_IDPRIORITY_NBRMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD
Prompt Table: CDT_PROD_UOM
CDT_PALT_VW(SQL View) |
Index Back |
|---|
| SELECT P.SETID , P.PRODUCT_ID , P.PRIORITY_NBR , P.PRODUCT_ID_ALT , PU.UNIT_OF_MEASURE , D.BUSINESS_UNIT , %Round(%DecDiv(D.QTY_AVAILABLE, CONV.CONVERSION_RATE), 4) , P.QTY_PER , CONV.CONVERSION_RATE FROM PS_INV_ITEM_UOM CONV , PS_PROD_ITEM PI , PS_PROD_UOM PU , PS_SET_CNTRL_REC SC , PS_BU_ITEMS_INV D , PS_PROD_ALT P WHERE SC.RECNAME = 'PROD_ITEM' AND SC.SETCNTRLVALUE = D.BUSINESS_UNIT AND P.SETID = SC.SETID AND D.INV_ITEM_ID = PI.INV_ITEM_ID AND PI.SETID = P.SETID AND PI.PRODUCT_ID = P.PRODUCT_ID_ALT AND PU.SETID = P.SETID AND PU.PRODUCT_ID = P.PRODUCT_ID AND CONV.SETID = PI.SETID AND CONV.UNIT_OF_MEASURE = PU.UNIT_OF_MEASURE AND CONV.INV_ITEM_ID = PI.INV_ITEM_ID AND P.START_DT <= %CurrentDateIn AND P.END_DT >= %CurrentDateIn |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | PRIORITY_NBR |
Number(3,0) | SMALLINT NOT NULL | Priority |
| 4 | PRODUCT_ID_ALT | Character(18) | VARCHAR2(18) NOT NULL | Alternate Product ID |
| 5 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD Prompt Table: CDT_PROD_UOM |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | QTY_AVAILABLE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Available |
| 8 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 9 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |