MIN_REQUSTER_VW

(SQL View)
 Index Back

Active Requestor Table


SELECT A.REQUESTOR_ID ,B.OPRDEFNDESC , A.REQ_STATUS , A.SHIPTO_SETID , A.SHIPTO_ID , A.LOCATION_SETID , A.LOCATION , A.ORIGIN_PO_SETID , A.ORIGIN , A.DEPTID_SETID , A.CATALOG_SETID , A.CATALOG_ID , A.PHONE , A.FAX , A.USE_ASSGN_CAT_ONLY , A.CURRENCY_CD , A.CONSOLIDATE_FLG , A.PRICE_CAN_CHANGE , A.DEFAULT_IN_BU , A.BUSINESS_UNIT_GL , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF16_AN_SBR, A) , A.PROJECT_ID , A.BUSINESS_UNIT_PC , A.ACTIVITY_ID , A.ANALYSIS_TYPE , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.OVERRIDE_SUB_FLAG FROM PS_REQUESTOR_TBL A ,PSOPRDEFN B WHERE A.REQUESTOR_ID = B.OPRID AND A.ACTIVE_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
3 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled

Default Value: O

4 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

5 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIP_SHIPSET_VW

6 LOCATION_SETID Character(5) VARCHAR2(5) NOT NULL Location Set ID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOC_LOCSET_VW

8 ORIGIN_PO_SETID Character(5) VARCHAR2(5) NOT NULL PO Origin Setid

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

9 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

Prompt Table: ORGN_ORGNSET_VW

10 DEPTID_SETID Character(5) VARCHAR2(5) NOT NULL Department SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

11 CATALOG_SETID Character(5) VARCHAR2(5) NOT NULL Catalog Setid

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

12 CATALOG_ID Character(18) VARCHAR2(18) NOT NULL Catalog ID
13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
14 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
15 USE_ASSGN_CAT_ONLY Character(1) VARCHAR2(1) NOT NULL Use Only Assigned Catalogs

Y/N Table Edit

Default Value: N

16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

17 CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidate with other Reqs
N=No
Y=Yes
18 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
N=No
Y=Yes

Y/N Table Edit

19 DEFAULT_IN_BU Character(1) VARCHAR2(1) NOT NULL Defaults Inventory BU

Y/N Table Edit

Default Value: N

20 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BUPRCR_NONVW

21 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT
Set Control Field: BUSINESS_UNIT_GL

22 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT
Set Control Field: BUSINESS_UNIT_GL

23 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
24 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

25 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

26 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

27 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

28 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

29 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

30 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

31 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

32 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

33 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

34 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

35 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

36 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJID_BUGL_VW

37 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
38 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
39 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
40 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
41 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
42 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
43 OVERRIDE_SUB_FLAG Character(1) VARCHAR2(1) NOT NULL Override Auto Item Substitute
N=N
Y=Y

Y/N Table Edit

Default Value: N