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

VIEW: APPS.AR_LOOKUP_TYPES

Object Details
Object Name: AR_LOOKUP_TYPES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_LOOKUP_TYPES
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes Quickcode type
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
USER_MAINTAINABLE_FLAG VARCHAR2 (1)
Y or N indicates whether you can make changes to Quickcodes of this type
DESCRIPTION VARCHAR2 (80) Yes Description of the Quickcode
Query Text

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


SELECT LOOKUP_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      USER_MAINTAINABLE_FLAG
,      DESCRIPTION
FROM APPS.AR_LOOKUP_TYPES;

Dependencies

[top of page]

APPS.AR_LOOKUP_TYPES references the following:

SchemaAPPS
SynonymFND_LOOKUP_TYPES
ViewFND_LOOKUP_TYPES_VL
APPS.AR_LOOKUP_TYPES is referenced by following:

SchemaAPPS
ViewAST_PARTY_CLASSIFICATION_V