EOEP_PL_SRCH_VW

(SQL View)
 Index Back

Price List Search View

This view is used for the customized search page and doesn't return any rows. It is used just as a derived record but it was created so that it could possibly be used in a grid later.

SELECT SETID , PRICE_LIST_ID , CURRENCY_CD , DESCR , 'SO' , ' ' , ' ' , ' ' , ' ' FROM %Table(EOEP_PRCLST_HDR) WHERE 1 = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 PRICE_LIST_ID Character(10) VARCHAR2(10) NOT NULL Price List ID

Prompt Table: EOEP_PRLSTID_VW

3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

Prompt Table: CURRENCY_CD_TBL

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

Prompt Table: EOEP_APPCDPL_VW

6 EOEP_SRCH_COND01 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
7 EOEP_SRCH_COND02 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
8 EOEP_SRCH_COND03 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
9 EOEP_SRCH_COND04 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in