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

VIEW: APPS.PABV_PROJECTS

Object Details
Object Name: PABV_PROJECTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PABV_PROJECTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about the highest units of work defined in Oracle Projects where funding can be allocated, and where revenue and invoice items are generated and maintained.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes
PROJECT_STATUS VARCHAR2 (80) Yes
PROJECT_NAME VARCHAR2 (30) Yes
PROJECT_NUMBER VARCHAR2 (25) Yes
DESCRIPTION VARCHAR2 (250)

START_DATE DATE


COMPLETION_DATE DATE


CLOSED_DATE DATE


_LA:WF_STATUS CHAR (52)
_LA:PM_PRODUCT CHAR (54)
PM_PROJECT_REFERENCE VARCHAR2 (25)
_LA:PUBLIC_SECTOR_FLAG CHAR (49)
DISTRIBUTION_RULE VARCHAR2 (20)
DISTRIBUTION_RULE_MEANING VARCHAR2 (80)
_DF CHAR (32)
_LA:TEMPLATE_FLAG CHAR (44)
CARRYING_OUT_ORGANIZATION_ID NUMBER (15) Yes
PROJECT_TYPE VARCHAR2 (20) Yes
ORG_ID NUMBER (15)

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
Query Text

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


SELECT PROJECT_ID
,      PROJECT_STATUS
,      PROJECT_NAME
,      PROJECT_NUMBER
,      DESCRIPTION
,      START_DATE
,      COMPLETION_DATE
,      CLOSED_DATE
,      _LA:WF_STATUS
,      _LA:PM_PRODUCT
,      PM_PROJECT_REFERENCE
,      _LA:PUBLIC_SECTOR_FLAG
,      DISTRIBUTION_RULE
,      DISTRIBUTION_RULE_MEANING
,      _DF
,      _LA:TEMPLATE_FLAG
,      CARRYING_OUT_ORGANIZATION_ID
,      PROJECT_TYPE
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.PABV_PROJECTS;

Dependencies

[top of page]

APPS.PABV_PROJECTS references the following:

SchemaAPPS
SynonymPA_DISTRIBUTION_RULES
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_STATUSES

APPS.PABV_PROJECTS is not referenced by any database object