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_FM_PROJ_BATCH_MAP

Object Details

Object Name:	PJI_FM_PROJ_BATCH_MAP
Object Type:	TABLE
Owner:	PJI
FND Design Data:	PJI.PJI_FM_PROJ_BATCH_MAP
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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJI_FM_PROJ_BATCH_MAP_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PROJECT_ID
PJI_FM_PROJ_BATCH_MAP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID PROJECT_ID
PJI_FM_PROJ_BATCH_MAP_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PLAN_EXTRACTION_STATUS
PJI_FM_PROJ_BATCH_MAP_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BACKLOG_EXTRACTION_STATUS

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER	(15)
ROW_COUNT	NUMBER
START_DATE	DATE
END_DATE	DATE
PJI_PROJECT_STATUS	VARCHAR2	(1)
BATCH_ID	NUMBER	(15)
EXTRACTION_TYPE	VARCHAR2	(1)
EXTRACTION_STATUS	VARCHAR2	(30)
PROJECT_TYPE	VARCHAR2	(20)
PROJECT_ORG_ID	NUMBER	(15)
PROJECT_ORGANIZATION_ID	NUMBER	(15)
AR_CASH_APPLIED	NUMBER
AR_AMOUNT_DUE_REMAINING	NUMBER
AR_AMOUNT_OVERDUE_REMAINING	NUMBER
PLAN_EXTRACTION_STATUS	VARCHAR2	(1)
COST_BUDGET_C_VERSION	NUMBER
COST_BUDGET_CO_VERSION	NUMBER
REVENUE_BUDGET_C_VERSION	NUMBER
REVENUE_BUDGET_CO_VERSION	NUMBER
COST_FORECAST_C_VERSION	NUMBER
REVENUE_FORECAST_C_VERSION	NUMBER
COST_BUDGET_N_VERSION	NUMBER
COST_BUDGET_NO_VERSION	NUMBER
REVENUE_BUDGET_N_VERSION	NUMBER
REVENUE_BUDGET_NO_VERSION	NUMBER
COST_FORECAST_N_VERSION	NUMBER
REVENUE_FORECAST_N_VERSION	NUMBER
POU_UNAPPRV_INVOICE_AMOUNT	NUMBER
PRJ_UNAPPRV_INVOICE_AMOUNT	NUMBER
UNAPPRV_INVOICE_COUNT	NUMBER
POU_APPRV_INVOICE_AMOUNT	NUMBER
PRJ_APPRV_INVOICE_AMOUNT	NUMBER
APPRV_INVOICE_COUNT	NUMBER
ACTIVITY_MIN_GL_DATE	DATE
ACTIVITY_MIN_PA_DATE	DATE
OLD_CLOSED_DATE	DATE
NEW_CLOSED_DATE	DATE
FUNDING_MIN_DATE	DATE
NEW_PROJECT_ORGANIZATION_ID	NUMBER	(15)
BACKLOG_EXTRACTION_STATUS	VARCHAR2	(1)	Used for parallel backlog calculation
PARALLEL_BACKLOG_WORKER_ID	NUMBER	(15)	Used for parallel backlog calculation
PROJECT_TYPE_CLASS	VARCHAR2	(1)
WORKER_ID	NUMBER	(15)

Query Text

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


SELECT PROJECT_ID
,      ROW_COUNT
,      START_DATE
,      END_DATE
,      PJI_PROJECT_STATUS
,      BATCH_ID
,      EXTRACTION_TYPE
,      EXTRACTION_STATUS
,      PROJECT_TYPE
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      AR_CASH_APPLIED
,      AR_AMOUNT_DUE_REMAINING
,      AR_AMOUNT_OVERDUE_REMAINING
,      PLAN_EXTRACTION_STATUS
,      COST_BUDGET_C_VERSION
,      COST_BUDGET_CO_VERSION
,      REVENUE_BUDGET_C_VERSION
,      REVENUE_BUDGET_CO_VERSION
,      COST_FORECAST_C_VERSION
,      REVENUE_FORECAST_C_VERSION
,      COST_BUDGET_N_VERSION
,      COST_BUDGET_NO_VERSION
,      REVENUE_BUDGET_N_VERSION
,      REVENUE_BUDGET_NO_VERSION
,      COST_FORECAST_N_VERSION
,      REVENUE_FORECAST_N_VERSION
,      POU_UNAPPRV_INVOICE_AMOUNT
,      PRJ_UNAPPRV_INVOICE_AMOUNT
,      UNAPPRV_INVOICE_COUNT
,      POU_APPRV_INVOICE_AMOUNT
,      PRJ_APPRV_INVOICE_AMOUNT
,      APPRV_INVOICE_COUNT
,      ACTIVITY_MIN_GL_DATE
,      ACTIVITY_MIN_PA_DATE
,      OLD_CLOSED_DATE
,      NEW_CLOSED_DATE
,      FUNDING_MIN_DATE
,      NEW_PROJECT_ORGANIZATION_ID
,      BACKLOG_EXTRACTION_STATUS
,      PARALLEL_BACKLOG_WORKER_ID
,      PROJECT_TYPE_CLASS
,      WORKER_ID
FROM PJI.PJI_FM_PROJ_BATCH_MAP;

Dependencies

[top of page]

PJI.PJI_FM_PROJ_BATCH_MAP does not reference any database object

PJI.PJI_FM_PROJ_BATCH_MAP is referenced by following:

PJI: PJI_FM_PROJ_BATCH_MAP#