Product: | CSF - Field Service |
---|---|
Description: | Base view for the Queries block in the Dispatch Center |
Implementation/DBA Data: | APPS.CSF_DC_QUERIES_VL |
SELECT CDQB.ROWID ROW_ID
, CDQB.QUERY_ID
, CDQB.CREATED_BY
, CDQB.CREATION_DATE
, CDQB.LAST_UPDATED_BY
, CDQB.LAST_UPDATE_DATE
, CDQB.LAST_UPDATE_LOGIN
, CDQB.OBJECT_VERSION_NUMBER
, CDQT.NAME
, CDQT.DESCRIPTION
, CDQB.WHERE_CLAUSE
, CDQB.USER_ID
, CDQB.SEEDED_FLAG
, CDQB.START_DATE_ACTIVE
, CDQB.END_DATE_ACTIVE
FROM CSF_DC_QUERIES_B CDQB
, CSF_DC_QUERIES_TL CDQT
WHERE CDQB.QUERY_ID = CDQT.QUERY_ID
AND CDQT.LANGUAGE = USERENV('LANG')