eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AMS_OBJECT_RULES_VL

Product:	AMS - Marketing
Description:	This view returns object rules details.
Implementation/DBA Data:	APPS.AMS_OBJECT_RULES_VL

View Text

SELECT B.ROWID ROW_ID
, B.SEEDED_FLAG
, B.OBJECT_RULE_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.APPROVAL_TYPE
, B.SECURITY_GROUP_ID
, B.RULE_USED_BY
, B.RULE_USED_BY_TYPE
, B.RULE_TYPE
, B.API_TYPE
, B.PACKAGE_NAME
, B.PROCEDURE_NAME
, B.CLASS_NAME
, B.METHOD_NAME
, B.QUERY
, B.RELATED_OBJECT
, B.PARAM1
, B.PARAM2
, B.PARAM3
, B.PARAM4
, B.PARAM5
, B.PARAM6
, B.PARAM7
, B.PARAM8
, B.PARAM9
, B.PARAM10
, B.PARAM11
, B.PARAM12
, B.PARAM13
, B.PARAM14
, B.PARAM15
, B.APPLICATION_ID
, T.OBJECT_RULE_NAME
, T.DESCRIPTION
FROM AMS_OBJECT_RULES_TL T
, AMS_OBJECT_RULES_B B
WHERE B.OBJECT_RULE_ID = T.OBJECT_RULE_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
SEEDED_FLAG
OBJECT_RULE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
APPROVAL_TYPE
SECURITY_GROUP_ID
RULE_USED_BY
RULE_USED_BY_TYPE
RULE_TYPE
API_TYPE
PACKAGE_NAME
PROCEDURE_NAME
CLASS_NAME
METHOD_NAME
QUERY
RELATED_OBJECT
PARAM1
PARAM2
PARAM3
PARAM4
PARAM5
PARAM6
PARAM7
PARAM8
PARAM9
PARAM10
PARAM11
PARAM12
PARAM13
PARAM14
PARAM15
APPLICATION_ID
OBJECT_RULE_NAME
DESCRIPTION