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

VIEW: APPS.FND_IMP_AFFECTEDFILES_VL

Object Details
Object Name: FND_IMP_AFFECTEDFILES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.FND_IMP_AFFECTEDFILES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


FND_IMP_AFFECTEDFILES_VL


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUG_NO NUMBER

BUGNO
SNAPSHOT_ID NUMBER
Yes SNAPSHOT_ID
DEP_APP_SHORT_NAME VARCHAR2 (50)
DEP_APP_SHORT_NAME
DEP_DIRECTORY VARCHAR2 (256)
DEP_DIRECTORY
DEP_FILENAME VARCHAR2 (128)
DEP_FILENAME
PATCHED_APP_SHORT_NAME VARCHAR2 (50)
PATCHED_APP_SHORT_NAME
PATCHED_DIRECTORY VARCHAR2 (160)
PATCHED_DIRECTORY
PATCHED_FILENAME VARCHAR2 (90)
PATCHED_FILENAME
TYPEID VARCHAR2 (11)
TYPEID
ACTION_REQUIRED CHAR (9)
ACTION_REQUIRED
OBJECTS_AFFECTED NUMBER

OBJECTS_AFFECTED
OBJECT_TYPE CHAR (4)
OBJECT_TYPE
PATCH_ID NUMBER

PATCH_ID
Query Text

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


SELECT BUG_NO
,      SNAPSHOT_ID
,      DEP_APP_SHORT_NAME
,      DEP_DIRECTORY
,      DEP_FILENAME
,      PATCHED_APP_SHORT_NAME
,      PATCHED_DIRECTORY
,      PATCHED_FILENAME
,      TYPEID
,      ACTION_REQUIRED
,      OBJECTS_AFFECTED
,      OBJECT_TYPE
,      PATCH_ID
FROM APPS.FND_IMP_AFFECTEDFILES_VL;

Dependencies

[top of page]

APPS.FND_IMP_AFFECTEDFILES_VL references the following:

SchemaAPPS
SynonymFND_IMP_DEPOBJECTS
SynonymFND_IMP_DEPRELATIONS
SynonymFND_IMP_PSMASTER2
APPS.FND_IMP_AFFECTEDFILES_VL is referenced by following:

SchemaAPPS
Package BodyFND_IMP_PKG - show dependent code