[Home] [Help]
[Dependency Information]
| Object Name: | PJI_PRG_BATCH_LOG |
|---|---|
| Object Type: | TABLE |
| Owner: | PJI |
| Subobject Name: | |
| Status: | VALID |
| Tablespace: | APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| 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) |
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;
PJI.PJI_PRG_BATCH_LOG does not reference any database object
PJI.PJI_PRG_BATCH_LOG is referenced by following:
PJI
PJI_PRG_BATCH_LOG#
|
|
|
|