1. Tables and Views for Common Features
  2. FND_DOC_SCOPES_VL

FND_DOC_SCOPES_VL

Details

  • Schema: ATTACHMENTS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

FND_DOC_SCOPE_ID

SCOPE_NAME

DOCUMENT_ENTITY_ID

CATEGORY_ID

MODULE_ID

CREATION_DATE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

Query

SQL_Statement

SELECT

b.fnd_doc_scope_id,

b.scope_name,

b.document_entity_id,

b.category_id,

b.module_id,

b.creation_date,

b.created_by,

b.last_updated_by,

b.last_update_date,

b.last_update_login,

b.object_version_number,

t.name,

t.description

FROM

fnd_doc_scopes_tl t,

fnd_doc_scopes_b b

WHERE

b.fnd_doc_scope_id = t.fnd_doc_scope_id

AND t.language = USERENV('LANG')