DBA Data[Home] [Help]

VIEW: APPS.CS_MULTI_ORG_RULES_V

Source

View Text - Preformatted

SELECT a.multi_org_rule_code, a.multi_org_rule_order, a.last_update_date, a.last_updated_by, a.creation_date, a.created_by, a.last_update_login, b.meaning FROM CS_MULTI_ORG_RULES a, CS_LOOKUPS b WHERE b.lookup_code = a.multi_org_rule_code AND lookup_type = 'CS_MULTI_ORG_RULE'
View Text - HTML Formatted

SELECT A.MULTI_ORG_RULE_CODE
, A.MULTI_ORG_RULE_ORDER
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, B.MEANING
FROM CS_MULTI_ORG_RULES A
, CS_LOOKUPS B
WHERE B.LOOKUP_CODE = A.MULTI_ORG_RULE_CODE
AND LOOKUP_TYPE = 'CS_MULTI_ORG_RULE'