DBA Data[Home] [Help]

VIEW: APPS.AST_IH_OUTCOMES_CAMPAIGNS_VL

Source

View Text - Preformatted

SELECT oc.rowid ,oc.outcome_id ,oc.object_id ,oc.object_version_number ,oc.created_by ,oc.creation_date ,oc.last_updated_by ,oc.last_update_date ,oc.last_update_login ,oc.object_type ,oc.source_code_id ,oc.source_code ,o.outcome_code ,o.short_description ,o.result_required FROM jtf_ih_outcomes_campaigns oc , jtf_ih_outcomes_vl o WHERE oc.outcome_id = o.outcome_id
View Text - HTML Formatted

SELECT OC.ROWID
, OC.OUTCOME_ID
, OC.OBJECT_ID
, OC.OBJECT_VERSION_NUMBER
, OC.CREATED_BY
, OC.CREATION_DATE
, OC.LAST_UPDATED_BY
, OC.LAST_UPDATE_DATE
, OC.LAST_UPDATE_LOGIN
, OC.OBJECT_TYPE
, OC.SOURCE_CODE_ID
, OC.SOURCE_CODE
, O.OUTCOME_CODE
, O.SHORT_DESCRIPTION
, O.RESULT_REQUIRED
FROM JTF_IH_OUTCOMES_CAMPAIGNS OC
, JTF_IH_OUTCOMES_VL O
WHERE OC.OUTCOME_ID = O.OUTCOME_ID