[Home] [Help]
View: CSF_PLAN_TERRS_V
Product: | CSF - Field Service |
Description: | Base view of form block in CSFSEPLT form. Corresponds to the CSF_PLAN_TERRS table |
Implementation/DBA Data: |
APPS.CSF_PLAN_TERRS_V
|
View Text
SELECT P.ROWID ROW_ID
, P.PLAN_TERR_ID
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, P.OBJECT_VERSION_NUMBER
, P.TERR_ID
, P.GROUP_ID
, T.NAME TERR_NAME
, G.GROUP_NAME
FROM CSF_PLAN_TERRS P
, JTF_TERR_ALL T
, JTF_RS_GROUPS_VL G
WHERE T.TERR_ID = P.TERR_ID
AND G.GROUP_ID = P.GROUP_ID
Columns
Name |
ROW_ID |
PLAN_TERR_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
OBJECT_VERSION_NUMBER |
TERR_ID |
GROUP_ID |
TERR_NAME |
GROUP_NAME |