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
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
|
|
|