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: PJI.PJI_FM_PROJ_BATCH_MAP#

Object Details

Object Name:	PJI_FM_PROJ_BATCH_MAP#
Object Type:	VIEW
Owner:	PJI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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)
PARALLEL_BACKLOG_WORKER_ID	NUMBER	(15)
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# references the following:

PJI: PJI_FM_PROJ_BATCH_MAP

PJI.PJI_FM_PROJ_BATCH_MAP# is referenced by following:

APPS: PJI_FM_PROJ_BATCH_MAP