Product: | OKC - Contracts Core |
---|---|
Description: | VL view on OKC_REP_RELATIONSHIP_B and OKC_REP_RELATIONSHIP_TL tables. |
Implementation/DBA Data: | APPS.OKC_REP_RELATIONSHIPS_VL |
SELECT RELB.ROWID
, RELB.RELATIONSHIP_ROLE1_ID
, RELTL.RELATIONSHIP_ROLE1_NAME
, RELB.RELATIONSHIP_ROLE2_ID
, RELTL.RELATIONSHIP_ROLE2_NAME
, RELTL.DESCRIPTION
, RELB.DIRECTION
, RELB.DISABLED_FLAG
, RELB.OBJECT_VERSION_NUMBER
, RELB.CREATED_BY
, RELB.CREATION_DATE
, RELB.LAST_UPDATED_BY
, RELB.LAST_UPDATE_DATE
, RELB.LAST_UPDATE_LOGIN
FROM OKC_REP_RELATIONSHIPS_B RELB
, OKC_REP_RELATIONSHIPS_TL RELTL
WHERE RELB.RELATIONSHIP_ROLE1_ID = RELTL.RELATIONSHIP_ROLE1_ID
AND RELTL.LANGUAGE = USERENV('LANG')