eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PJM_PROJECT_SEIBAN_V

Object Details

Object Name:	PJM_PROJECT_SEIBAN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJM.PJM_PROJECT_SEIBAN_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

PJM_PROJECT_SEIBAN_V returns all seiban numbers.
This view corresponds to the Seiban Summary (multi-row) and Seiban Information (single-row) web inquiry regions.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies a seiban
PROJECT_NUMBER	VARCHAR2	(25)	Yes	User-entered number that uniquely identifies a seiban
PROJECT_NAME	VARCHAR2	(30)	Yes	User-entered seiban name
OPERATING_UNIT	NUMBER			Operating unit unique identifier that owns the seiban
OPERATING_UNIT_NAME	VARCHAR2	(240)		Operating unit name

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      OPERATING_UNIT
,      OPERATING_UNIT_NAME
FROM APPS.PJM_PROJECT_SEIBAN_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_SEIBAN_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; PJM_SEIBAN_NUMBERS

APPS.PJM_PROJECT_SEIBAN_V is not referenced by any database object