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

VIEW: APPS.PRP_PROP_OBJECTS_V

Object Details
Object Name: PRP_PROP_OBJECTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPRP.PRP_PROP_OBJECTS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER
Yes
OWNER_USER_ID NUMBER
Yes
PARTY_ID NUMBER
Yes
CONTACT_PARTY_ID NUMBER

OBJECT_ID NUMBER
Yes
OBJECT_TYPE VARCHAR2 (30) Yes
OWNER_NAME VARCHAR2 (360)
PROPOSAL_NAME VARCHAR2 (240) Yes
PROPOSAL_DESC VARCHAR2 (2000)
PROPOSAL_STATUS_CODE VARCHAR2 (30) Yes
PROPOSAL_STATUS VARCHAR2 (80) Yes
DUE_DATE DATE

UPDATE_FLAG VARCHAR2 (1)
FILE_ID NUMBER

FILE_FORMAT VARCHAR2 (30)
CITEM_VERSION_ID VARCHAR2 (0)
CONTENT_ITEM_ID VARCHAR2 (0)
PROPOSAL_LANGUAGE VARCHAR2 (4) Yes
Query Text

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


SELECT PROPOSAL_ID
,      OWNER_USER_ID
,      PARTY_ID
,      CONTACT_PARTY_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      OWNER_NAME
,      PROPOSAL_NAME
,      PROPOSAL_DESC
,      PROPOSAL_STATUS_CODE
,      PROPOSAL_STATUS
,      DUE_DATE
,      UPDATE_FLAG
,      FILE_ID
,      FILE_FORMAT
,      CITEM_VERSION_ID
,      CONTENT_ITEM_ID
,      PROPOSAL_LANGUAGE
FROM APPS.PRP_PROP_OBJECTS_V;

Dependencies

[top of page]

APPS.PRP_PROP_OBJECTS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
ViewJTF_RS_RESOURCE_EXTNS_VL
SynonymPRP_PROPOSALS
SynonymPRP_PROPOSAL_ACCESSES
SynonymPRP_PROPOSAL_CTNTVERS
SynonymPRP_PROPOSAL_OBJECTS
SynonymPRP_PROP_CTNTVER_FORMATS
APPS.PRP_PROP_OBJECTS_V is referenced by following:

SchemaAPPS
Package BodyAST_UWQ_OLIST_WORK_ACTION - show dependent code