[Home] [Help]
| Product: | PSP - Labor Distribution |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
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