JPM_PROMPT_VW

(SQL View)
 Index Back

Dynamic Prompt View Processing

Used by JPM_PROMPT_DVW to provide a valid default SQLText when Tools adds the Where-clause for resolving the related display.

SELECT ' ' ,' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JPM_PROMPT_VALUE Character(30) VARCHAR2(30) NOT NULL Code
2 JPM_PROMPT_DESCR Character(100) VARCHAR2(100) NOT NULL Description