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

VIEW: APPS.PA_UBR_UER_PROJ_V

Object Details
Object Name: PA_UBR_UER_PROJ_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_UBR_UER_PROJ_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
PROJECT_NUMBER VARCHAR2 (25) Yes
PROJECT_NAME VARCHAR2 (30) Yes
PROJECT_ID NUMBER (15) Yes
PROJECT_TYPE VARCHAR2 (20) Yes
UBR_UER_SUMMARY_ID NUMBER (15) Yes
COST_CENTER VARCHAR2 (25) Yes
GL_PERIOD_NAME VARCHAR2 (15) Yes
SU_GL_PERIOD_NAME VARCHAR2 (15) Yes
UBR_AMOUNT NUMBER


UER_AMOUNT NUMBER


ZERO_BALANCE_FLAG VARCHAR2 (1)

ACCOUNT VARCHAR2 (25) Yes
UBR_UER_CODE VARCHAR2 (15)

GL_PERIOD_START_DATE DATE
Yes
SU_GL_PERIOD_START_DATE DATE
Yes
PROCESS_FLAG VARCHAR2 (1)

REQUEST_ID NUMBER


MULTI_COST_CENTER_FLAG VARCHAR2 (1)

SET_OF_BOOKS_ID NUMBER (15) Yes The set of books id
ORG_ID NUMBER (15)
Operating Unit
Query Text

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


SELECT PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_ID
,      PROJECT_TYPE
,      UBR_UER_SUMMARY_ID
,      COST_CENTER
,      GL_PERIOD_NAME
,      SU_GL_PERIOD_NAME
,      UBR_AMOUNT
,      UER_AMOUNT
,      ZERO_BALANCE_FLAG
,      ACCOUNT
,      UBR_UER_CODE
,      GL_PERIOD_START_DATE
,      SU_GL_PERIOD_START_DATE
,      PROCESS_FLAG
,      REQUEST_ID
,      MULTI_COST_CENTER_FLAG
,      SET_OF_BOOKS_ID
,      ORG_ID
FROM APPS.PA_UBR_UER_PROJ_V;

Dependencies

[top of page]

APPS.PA_UBR_UER_PROJ_V references the following:

SchemaAPPS
SynonymGL_PERIOD_STATUSES
PL/SQL PackagePA_CURRENCY - show dependent code
SynonymPA_IMPLEMENTATIONS_ALL
SynonymPA_PROJECTS
SynonymPA_PROJECT_TYPES_ALL
SynonymPA_UBR_UER_SUMM_ACCT

APPS.PA_UBR_UER_PROJ_V is not referenced by any database object