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


VIEW: APPS.AP_WEB_SIGNING_LIMITS_V

Object Details
Object Name: AP_WEB_SIGNING_LIMITS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.AP_WEB_SIGNING_LIMITS_V
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


Create views AP_WEB_SIGNING_LIMITS_V


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_ID NUMBER

DISPLAYED_DOCUMENT_TYPE VARCHAR2 (80)
DOCUMENT_TYPE VARCHAR2 (30)
COST_CENTER VARCHAR2 (30)
SIGNING_LIMIT NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
ORG_ID NUMBER (15)
Query Text

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


SELECT ROW_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_ID
,      DISPLAYED_DOCUMENT_TYPE
,      DOCUMENT_TYPE
,      COST_CENTER
,      SIGNING_LIMIT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORG_ID
FROM APPS.AP_WEB_SIGNING_LIMITS_V;

Dependencies

[top of page]

APPS.AP_WEB_SIGNING_LIMITS_V references the following:

SchemaAPPS
ViewAP_LOOKUP_CODES
PL/SQL PackageAP_WEB_DB_HR_INT_PKG - show dependent code
SynonymAP_WEB_SIGNING_LIMITS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_CONT_WORKERS_CURRENT_X
ViewPER_EMPLOYEES_CURRENT_X

APPS.AP_WEB_SIGNING_LIMITS_V is not referenced by any database object