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


TABLE: PJI.PJI_PRG_BATCH_LOG

Object Details
Object Name: PJI_PRG_BATCH_LOG
Object Type: TABLE
Owner: PJI
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RUN_DATE_KEY VARCHAR2 (50)
RUN_DATE DATE

REQUEST_ID NUMBER

BATCH_NAME VARCHAR2 (30)
WBS_TOTAL NUMBER

PRG_TOTAL NUMBER

DELTA_TOTAL NUMBER

TOTAL_COUNT NUMBER

PROJECT_COUNT NUMBER

CUSTOM1 VARCHAR2 (30)
CUSTOM2 VARCHAR2 (30)
CUSTOM3 VARCHAR2 (30)
Query Text

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


SELECT RUN_DATE_KEY
,      RUN_DATE
,      REQUEST_ID
,      BATCH_NAME
,      WBS_TOTAL
,      PRG_TOTAL
,      DELTA_TOTAL
,      TOTAL_COUNT
,      PROJECT_COUNT
,      CUSTOM1
,      CUSTOM2
,      CUSTOM3
FROM PJI.PJI_PRG_BATCH_LOG;

Dependencies

[top of page]

PJI.PJI_PRG_BATCH_LOG does not reference any database object

PJI.PJI_PRG_BATCH_LOG is referenced by following:

SchemaPJI
ViewPJI_PRG_BATCH_LOG#