BUSINESS_UNIT_REQDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_PM_NONVW
REQ_IDDefault Value: NEXT
PV_REQ_PYMT_VW(SQL View) |
Index Back |
|---|---|
ePro PO Views |
| SELECT DISTINCT A.BUSINESS_UNIT , A.REQ_ID FROM PS_REQ_LINE A WHERE EXISTS ( SELECT 'X' FROM PS_PO_LINE_DISTRIB D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.REQ_ID = A.REQ_ID AND D.REQ_LINE_NBR = A.LINE_NBR) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_REQ |
Character(5) | VARCHAR2(5) NOT NULL |
Requesting Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Default Value: NEXT |