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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMS_APPROVAL_DETAILS_VL

Object Details

Object Name:	AMS_APPROVAL_DETAILS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_APPROVAL_DETAILS_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view returns information about Approval rules

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique Id generated by the system
START_DATE_ACTIVE	DATE			Rule Start date
END_DATE_ACTIVE	DATE			Rule end date
APPROVAL_DETAIL_ID	NUMBER		Yes	Unique ID
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Unique number used for locking purposes
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
BUSINESS_GROUP_ID	NUMBER			Business Group Id
BUSINESS_UNIT_ID	NUMBER			Identifier of the Business Unit this Approval Rule belongs to
ORGANIZATION_ID	NUMBER			This field ties in with the Inventory Item ID.
CUSTOM_SETUP_ID	NUMBER			This field identifies the setup type for the Object
APPROVAL_OBJECT	VARCHAR2	(30)		This field identifies the Approval rule for an Object
APPROVAL_OBJECT_TYPE	VARCHAR2	(30)		This field identifies the Object Type for an Approval Rule
APPROVAL_TYPE	VARCHAR2	(30)		This field identifies the Approval rule's type
APPROVAL_PRIORITY	VARCHAR2	(30)		This field provide the information about approval rules priority
APPROVAL_LIMIT_TO	NUMBER			This filed hold s the value of the Maximum amount for that approval rule
APPROVAL_LIMIT_FROM	NUMBER			This filed hold s the value of the minimum amount for that approval rule
SEEDED_FLAG	VARCHAR2	(1)		This flag indicates whether this record is seeded.
ACTIVE_FLAG	VARCHAR2	(1)		Used for soft-deletes. The Delete will make this flag as 'N'. The Select statement will pull only those rows for which this flag is 'Y'
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
USER_COUNTRY_CODE	VARCHAR2	(30)		This field contains the country code of the User who logs in
NAME	VARCHAR2	(240)	Yes	Name of the Approval rule
DESCRIPTION	VARCHAR2	(4000)		Description of the Approval Rule

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      APPROVAL_DETAIL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      BUSINESS_GROUP_ID
,      BUSINESS_UNIT_ID
,      ORGANIZATION_ID
,      CUSTOM_SETUP_ID
,      APPROVAL_OBJECT
,      APPROVAL_OBJECT_TYPE
,      APPROVAL_TYPE
,      APPROVAL_PRIORITY
,      APPROVAL_LIMIT_TO
,      APPROVAL_LIMIT_FROM
,      SEEDED_FLAG
,      ACTIVE_FLAG
,      CURRENCY_CODE
,      USER_COUNTRY_CODE
,      NAME
,      DESCRIPTION
FROM APPS.AMS_APPROVAL_DETAILS_VL;

Dependencies

[top of page]

APPS.AMS_APPROVAL_DETAILS_VL references the following:

APPS: AMS_APPROVAL_DETAILS; AMS_APPROVAL_DETAILS_TL

APPS.AMS_APPROVAL_DETAILS_VL is referenced by following:

APPS: AMS_APPROVAL_DETAILS_PVT - show dependent code; AMS_APPROVAL_DETAILS_V; AMS_APPROVAL_PVT - show dependent code; AMS_GEN_APPROVAL_PVT - show dependent code