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

VIEW: APPS.XDP_PROC_BODY_VL

Object Details
Object Name: XDP_PROC_BODY_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXDP.XDP_PROC_BODY_VL
Subobject Name:
Status: VALID

View Type

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


This View shows all the User defined Procedures in SFM


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The Internal Database Row ID of the Procedure Body Record.
PROC_NAME VARCHAR2 (80) Yes User Defined Procedure Internal Name
PROC_BODY CLOB (4000) Yes Procedure Body
PROC_TYPE VARCHAR2 (40) Yes Procedure Type
PROTECTED_FLAG VARCHAR2 (1) Yes Flag to indicate if the Procedure is a Seeded Procedure.
CREATION_DATE DATE

Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
DISPLAY_NAME VARCHAR2 (80) Yes Display Name for the Procedure
DESCRIPTION VARCHAR2 (2000)
Description
PROC_SPEC VARCHAR2 (1996) Yes Procedure Specification
Query Text

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


SELECT ROW_ID
,      PROC_NAME
,      PROC_BODY
,      PROC_TYPE
,      PROTECTED_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISPLAY_NAME
,      DESCRIPTION
,      PROC_SPEC
FROM APPS.XDP_PROC_BODY_VL;

Dependencies

[top of page]

APPS.XDP_PROC_BODY_VL references the following:

SchemaAPPS
SynonymXDP_PROC_BODY
SynonymXDP_PROC_BODY_TL
APPS.XDP_PROC_BODY_VL is referenced by following:

SchemaAPPS
Package BodyXDPCORE_ERROR - show dependent code
Package BodyXDPCORE_FA - show dependent code