[Home] [Help] [Dependency Information]
Object Name: | PJI_PJI_PROJ_BATCH_MAP |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_PJI_PROJ_BATCH_MAP |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 0 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | (15) | ||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT WORKER_ID
, 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
FROM PJI.PJI_PJI_PROJ_BATCH_MAP;
PJI.PJI_PJI_PROJ_BATCH_MAP does not reference any database object
PJI.PJI_PJI_PROJ_BATCH_MAP is referenced by following:
|
|
|