PV_ADM_ITEMS_VW

(SQL View)
 Index Back

SELECT B.PV_GUIDE_ID , A.PV_ADM_MAIN_ITEM , A.PV_ADM_SUB_ITEM1 , A.PV_ADM_SUB_ITEM2 , A.SEQNUM , A.PV_ADM_QUERYSTRING , A.PV_MENUITEM , A.PV_BARNAME , A.BARITEMNAME , A.PANELITEMNAME , A.PV_STEP_NUM , A.PV_ADM_REL_ITEM , A.PV_ADM_REL_SUB_GRP , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.PV_ADM_DESCR , B.ACTIVE_FLG , B.PV_SETUP_DONE_FLAG FROM PS_PV_ADM_ITEM_TBL A , PS_PV_ADM_PROJ_XRF B WHERE A.PV_ADM_MAIN_ITEM = B.PV_ADM_MAIN_ITEM AND A.PV_ADM_SUB_ITEM1 = B.PV_ADM_SUB_ITEM1 AND A.PV_ADM_SUB_ITEM2 = B.PV_ADM_SUB_ITEM2 AND A.PV_ADM_MAIN_ITEM = 'ADM-06' AND A.PV_ADM_SUB_ITEM2 <> 'Item Control'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
2 PV_ADM_MAIN_ITEM Character(30) VARCHAR2(30) NOT NULL Main Item
3 PV_ADM_SUB_ITEM1 Character(50) VARCHAR2(50) NOT NULL
4 PV_ADM_SUB_ITEM2 Character(50) VARCHAR2(50) NOT NULL PV Admin sub item 2
5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

6 PV_ADM_QUERYSTRING Character(254) VARCHAR2(254) NOT NULL Query String
7 PV_MENUITEM Character(30) VARCHAR2(30) NOT NULL Menu Item
DCF=DESIGN_CHARTFIELDS
DGO=DEFINE_GENERAL_OPTIONS
DIC=DEFINE_ITEM_CONTROL_DATA
EAP=ESTABLISH_ASSET_PROCESSING
EBU=ESTABLISH_BUSINESS_UNITS
MIR=MANAGE_INTEGRATION_RULES
MIT=DEFINE_ITEMS
MMS=PV_MARKETSITE
MPC=MANAGE_PROCUREMENT_CARDS
MRO=MAINTAIN_ROLES
MSE=MAINTAIN_SECURITY
MUR=MAINTAIN_USER_PROFILES
MVN=MAINTAIN_SUPPLIERS
POT=PROCESS_OUTBOUND_TRANSACTIONS
PV=PV_MAIN_MENU
SPO=STRUCTURE_PROCUREMENT_OPTIONS
UTI=UTILITIES
WFA=WORKFLOW_ADMINISTRATOR
8 PV_BARNAME Character(30) VARCHAR2(30) NOT NULL Bar Name
ADM=PV_ADMIN
EXF=EXPRESS_FORMS
INQ=INQUIRE
MKS=PV_MARKETSITE
PCD=PCARD
PRC=PROCESS
PRO=PV_PROCESSES
REC=RECEIVING
SET=SETUP
UAD=USE_A-D
UAI=USE_A-I
UAM=USE_A-M
UEP=USE_E-P
UJR=USE_J-R
UNZ=USE_N_Z
URZ=USE_R-Z
USE=USE
USZ=USE_S-Z
VSS=VENDOR_SS
WLT=WORKLIST
9 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
10 PANELITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
11 PV_STEP_NUM Character(10) VARCHAR2(10) NOT NULL Step Number
12 PV_ADM_REL_ITEM Character(30) VARCHAR2(30) NOT NULL Related Main Menu Item
13 PV_ADM_REL_SUB_GRP Character(50) VARCHAR2(50) NOT NULL Related Sub Item Group
14 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
15 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
16 PV_ADM_DESCR Long Character CLOB Description
17 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active
18 PV_SETUP_DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Setup Done Flag
N=Not Completed
Y=Completed