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]

TABLE: PJI.PJI_PJP_PROJ_BATCH_MAP

Object Details

Object Name:	PJI_PJP_PROJ_BATCH_MAP
Object Type:	TABLE
Owner:	PJI
FND Design Data:	PJI.PJI_PJP_PROJ_BATCH_MAP
Subobject Name:
Status:	VALID

This table stores PJP summarization state.

Storage Details

Tablespace:
PCT Free:
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
WORKER_ID	NUMBER	(15)	Yes	Partitioning column
PROJECT_ID	NUMBER	(15)		Identifier of the Project
PJI_PROJECT_STATUS	VARCHAR2	(1)		Project Status
EXTRACTION_TYPE	VARCHAR2	(1)		Summarization extraction type
EXTRACTION_STATUS	VARCHAR2	(30)		Summarization extraction status
PROJECT_TYPE	VARCHAR2	(20)		Project Type
PROJECT_ORG_ID	NUMBER	(15)		Identifier of the Project Operating Unit
PROJECT_ORGANIZATION_ID	NUMBER	(15)		Identifier of the Project Organization
PROJECT_TYPE_CLASS	VARCHAR2	(1)		Project Type Class
PRJ_CURRENCY_CODE	VARCHAR2	(30)		Project Currency Code identifier
PROJECT_ACTIVE_FLAG	VARCHAR2	(1)		Flag to indicate if the project is currently active.
ACT_ERR_MSG	VARCHAR2	(2000)

Query Text

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


SELECT WORKER_ID
,      PROJECT_ID
,      PJI_PROJECT_STATUS
,      EXTRACTION_TYPE
,      EXTRACTION_STATUS
,      PROJECT_TYPE
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_TYPE_CLASS
,      PRJ_CURRENCY_CODE
,      PROJECT_ACTIVE_FLAG
,      ACT_ERR_MSG
FROM PJI.PJI_PJP_PROJ_BATCH_MAP;

Dependencies

[top of page]

PJI.PJI_PJP_PROJ_BATCH_MAP does not reference any database object

PJI.PJI_PJP_PROJ_BATCH_MAP is referenced by following:

APPS: PJI_PJP_PROJ_BATCH_MAP