[Home] [Help] [Dependency Information]
Object Name: | PN_VOL_HIST_BATCH_ITF# |
---|---|
Object Type: | VIEW |
Owner: | PN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Yes | |
BATCH_NAME | VARCHAR2 | (30) | Yes | |
MIN_REP_DATE | DATE | Yes | ||
MAX_REP_DATE | DATE | Yes | ||
VOLUME_TYPE | VARCHAR2 | (30) | ||
STATUS | VARCHAR2 | (1) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SALES_STATUS_CODE | VARCHAR2 | (30) | ||
REPORT_TYPE_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, BATCH_NAME
, MIN_REP_DATE
, MAX_REP_DATE
, VOLUME_TYPE
, STATUS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SALES_STATUS_CODE
, REPORT_TYPE_CODE
FROM PN.PN_VOL_HIST_BATCH_ITF#;
|
|
|