1. Tables and Views for Common Features
  2. FND_DOC_SCOPE_TO_LAW_VL

FND_DOC_SCOPE_TO_LAW_VL

Details

  • Schema: ATTACHMENTS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

FND_DOC_SCOPE_TO_LAW_ID

FND_DOC_SCOPE_ID

FND_DOC_LAW_ID

ENABLED_STATE

MODULE_ID

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ERROR_MESSAGE

ERROR_ACTION

Query

SQL_Statement

SELECT

b.fnd_doc_scope_to_law_id,

b.fnd_doc_scope_id,

b.fnd_doc_law_id,

b.enabled_state,

b.module_id,

b.creation_date,

b.created_by,

b.last_update_date,

b.last_updated_by,

b.last_update_login,

b.object_version_number,

t.error_message,

t.error_action

FROM

fnd_doc_scope_to_law_tl t,

fnd_doc_scope_to_law_b b

WHERE

b.fnd_doc_scope_to_law_id = t.fnd_doc_scope_to_law_id

AND t.language = USERENV('LANG')