Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | Contains the rows for the phrase conflicts |
Implementation/DBA Data: | APPS.GR_PHRASE_CONFLICTS_V |
SELECT PC.ROWID ROW_ID
, PC.PHRASE_CODE
, PT1.PHRASE_TEXT
, PC.PHRASE_CODE_ALSO_INVOLVED
, PT2.PHRASE_TEXT
, PC.PHRASE_CODE_SOLUTION
, PT3.PHRASE_TEXT
, PC.CREATED_BY
, PC.CREATION_DATE
, PC.LAST_UPDATED_BY
, PC.LAST_UPDATE_DATE
, PC.LAST_UPDATE_LOGIN
FROM GR_PHRASE_CONFLICTS PC
, GR_PHRASES_VL PT1
, GR_PHRASES_VL PT2
, GR_PHRASES_VL PT3
WHERE PC.PHRASE_CODE = PT1.PHRASE_CODE
AND PC.PHRASE_CODE_ALSO_INVOLVED = PT2.PHRASE_CODE
AND PC.PHRASE_CODE_SOLUTION = PT3.PHRASE_CODE (+)