FND Design Data [Home] [Help]

View: FND_ATTACHMENT_BLK_ENTITIES_VL

Product: FND - Application Object Library
Description: View of FND_ATTACHMENT_BLK_ENTITIES, FND_ATTACHMENT_BLOCKS, and FND_DOCUMENT_ENTITIES
Implementation/DBA Data: ViewAPPS.FND_ATTACHMENT_BLK_ENTITIES_VL
View Text

SELECT ABE.ROWID
, ABE.ATTACHMENT_BLK_ENTITY_ID
, ABE.ATTACHMENT_BLK_ID
, ABE.DATA_OBJECT_CODE
, DEV.USER_ENTITY_NAME
, ABE.DISPLAY_METHOD
, ABE.INCLUDE_IN_INDICATOR_FLAG
, ABE.INDICATOR_IN_VIEW_FLAG
, ABE.QUERY_PERMISSION_TYPE
, ABE.INSERT_PERMISSION_TYPE
, ABE.UPDATE_PERMISSION_TYPE
, ABE.DELETE_PERMISSION_TYPE
, ABE.CREATION_DATE
, ABE.CREATED_BY
, ABE.LAST_UPDATE_DATE
, ABE.LAST_UPDATED_BY
, ABE.LAST_UPDATE_LOGIN
, ABE.PK1_FIELD
, ABE.PK2_FIELD
, ABE.PK3_FIELD
, ABE.PK4_FIELD
, ABE.PK5_FIELD
, ABE.CONDITION_FIELD
, ABE.CONDITION_OPERATOR
, ABE.CONDITION_VALUE1
, ABE.CONDITION_VALUE2
, ABE.SQL_STATEMENT
FROM FND_ATTACHMENT_BLK_ENTITIES ABE
, FND_DOCUMENT_ENTITIES_VL DEV
WHERE ABE.DATA_OBJECT_CODE = DEV.DATA_OBJECT_CODE

Columns

Name
ROW_ID
ATTACHMENT_BLK_ENTITY_ID
ATTACHMENT_BLK_ID
DATA_OBJECT_CODE
USER_ENTITY_NAME
DISPLAY_METHOD
INCLUDE_IN_INDICATOR_FLAG
INDICATOR_IN_VIEW_FLAG
QUERY_PERMISSION_TYPE
INSERT_PERMISSION_TYPE
UPDATE_PERMISSION_TYPE
DELETE_PERMISSION_TYPE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PK1_FIELD
PK2_FIELD
PK3_FIELD
PK4_FIELD
PK5_FIELD
CONDITION_FIELD
CONDITION_OPERATOR
CONDITION_VALUE1
CONDITION_VALUE2
SQL_STATEMENT