DBA Data[Home] [Help]

VIEW: APPS.AR_BPA_RULE_ATTRIBUTES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.RULE_ATTRIBUTE_ID, B.RULE_ID, B.ITEM_ID, B.MATCH_CONDITION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.ATTRIBUTE_VALUE from AR_BPA_RULE_ATTRIBUTES_TL T, AR_BPA_RULE_ATTRIBUTES_B B WHERE B.RULE_ATTRIBUTE_ID = T.RULE_ATTRIBUTE_ID and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RULE_ATTRIBUTE_ID
, B.RULE_ID
, B.ITEM_ID
, B.MATCH_CONDITION
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.ATTRIBUTE_VALUE
FROM AR_BPA_RULE_ATTRIBUTES_TL T
, AR_BPA_RULE_ATTRIBUTES_B B
WHERE B.RULE_ATTRIBUTE_ID = T.RULE_ATTRIBUTE_ID
AND T.LANGUAGE = USERENV('LANG')