OPRIDBUSINESS_UNITPrompt Table: SP_BU_PM_NONVW
VENDOR_IDPrompt Table:
%EDITTABLE4
Set Control Field: BUSINESS_UNIT
SPR_VNDR_ANALYZ(SQL View) |
Index Back |
|---|---|
Role User's Supplier ListUsed for SRM Dashboard |
| SELECT DISTINCT A.OPRID ,A.BUSINESS_UNIT , W.VENDOR_ID , D.SP_SUPPLIER_NAME FROM PS_SPF_WORDERREC W , PS_SPR_SUPPLR_DIM D , PS_SPR_ANALYZ_SRCH A , PS_SPF_INVOICE_DTL I WHERE D.BUSINESS_UNIT = W.BUSINESS_UNIT AND A.BUSINESS_UNIT = W.BUSINESS_UNIT AND D.VENDOR_ID = W.VENDOR_ID AND I.BUSINESS_UNIT = W.BUSINESS_UNIT AND I.WORK_ORDER_ID = W.WORK_ORDER_ID AND I.INV_LINE_STATUS <> '8' AND (A.OPRID = W.WO_CLIID OR A.OPRID IN( SELECT C.OPRID FROM PS_SPF_IN_APR_XREF A1 , PS_EOAW_STEPINST B , PS_EOAW_USERINST C WHERE A1.EOAWDEFN_ID = B.EOAWDEFN_ID AND A1.EOAWPRCS_ID = B.EOAWPRCS_ID AND A1.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND B.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE AND A1.BUSINESS_UNIT = I.BUSINESS_UNIT AND A1.INVOICE_ID = I.INVOICE_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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
%EDITTABLE4
|
| 4 | SP_SUPPLIER_NAME | Character(40) | VARCHAR2(40) NOT NULL | Supplier Name |