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

VIEW: APPS.AMS_APPROVAL_DETAILS_V

Object Details
Object Name: AMS_APPROVAL_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_APPROVAL_DETAILS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
START_DATE_ACTIVE DATE

Start date of the rule
END_DATE_ACTIVE DATE

End date of the rule
APPROVAL_DETAIL_ID NUMBER

Unique ID
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes. A way to implement Optimistic Locking.
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

Operating Unit Identifier
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 idicates whether this frecord 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
NAME VARCHAR2 (240)
Name of the rule
DESCRIPTION VARCHAR2 (4000)
Descrption of the rule
USER_COUNTRY_CODE VARCHAR2 (30)
This field contains the country code of the User who logs in
BUSINESS_UNIT_NAME VARCHAR2 (240)
Name of the Business Unit
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
SETUP_NAME VARCHAR2 (120)
Name of the Setup Type
APPROVAL_TYPE_MEANING VARCHAR2 (80)
Meaning of Approval Type
APPROVAL_PRIORITY_MEANING VARCHAR2 (80)
Meaning of Approval Priority
APPROVAL_OBJECT_MEANING VARCHAR2 (80)
Object name
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
,      NAME
,      DESCRIPTION
,      USER_COUNTRY_CODE
,      BUSINESS_UNIT_NAME
,      ORGANIZATION_NAME
,      SETUP_NAME
,      APPROVAL_TYPE_MEANING
,      APPROVAL_PRIORITY_MEANING
,      APPROVAL_OBJECT_MEANING
FROM APPS.AMS_APPROVAL_DETAILS_V;

Dependencies

[top of page]

APPS.AMS_APPROVAL_DETAILS_V references the following:

SchemaAPPS
ViewAMS_APPROVAL_DETAILS_VL
ViewAMS_CUSTOM_SETUPS_VL
ViewAMS_LOOKUPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
ViewOZF_REASON_CODES_VL
APPS.AMS_APPROVAL_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyAMS_APPROVAL_DETAILS_PVT - show dependent code