[Home] [Help]
View: PSPFV_AUTOPOP_LOOKUP_PARAMETER
Product: | PSP - Labor Distribution |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PP. LOOKUP_ID
, PP.PARAMETER_CLASS
, PP.PARAMETER
, PP.DATATYPE
, PP.DYN_SQL_STMT
, PP.BIND_VAR
, PP.VALIDATION_TYPE
, PP.PARAM_VALUE_SET
, PP. BUSINESS_GROUP_ID
, HOU.NAME BUSINESS_GRP_NAME
, PP.SET_OF_BOOKS_ID
, GL.NAME SET_OF_BOOKS_NAME
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
, PP.CREATED_BY
, PP.CREATION_DATE
FROM PSP_AUTO_LOOKUPS PP
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE PP.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID
AND PP.BUSINESS_GROUP_ID=HOU.ORGANIZATION_ID WITH READ ONLY
Columns
Name |
LOOKUP_ID |
PARAMETER_CLASS |
PARAMETER |
DATATYPE |
DYN_SQL_STMT |
BIND_VAR |
VALIDATION_TYPE |
PARAM_VALUE_SET |
BUSINESS_GROUP_ID |
SET_OF_BOOKS_ID |
BUSINESS_GRP_NAME |
LAST_UPDATE_DATE |
SET_OF_BOOKS_NAME |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |