[Home] [Help] [Dependency Information]
Object Name: | IC_PURG_PRM# |
---|---|
Object Type: | VIEW |
Owner: | GMI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRITERIA_NO | VARCHAR2 | (32) | Yes | |
VERSION_NO | NUMBER | (10) | Yes | |
CRITERIA_ID | NUMBER | (10) | Yes | |
TABLE_NAME | VARCHAR2 | (32) | ||
OBJECT_CODE | VARCHAR2 | (8) | Yes | |
RUN_DATE | DATE | |||
ORGNCODE_FROM | VARCHAR2 | (4) | ||
ORGNCODE_THRU | VARCHAR2 | (4) | ||
DOCTYPE_FROM | VARCHAR2 | (4) | ||
DOCTYPE_THRU | VARCHAR2 | (4) | ||
ORGNDOC_FROM | VARCHAR2 | (4) | ||
DOCNO_FROM | VARCHAR2 | (32) | ||
ORGNDOC_THRU | VARCHAR2 | (4) | ||
DOCNO_THRU | VARCHAR2 | (32) | ||
DOCDELTA_TODAY | NUMBER | (5) | ||
DOCDATE_FROM | DATE | |||
DOCDELTA_THRU | NUMBER | (5) | ||
DOCDATE_THRU | DATE | |||
ITEMNO_FROM | VARCHAR2 | (32) | ||
ITEMNO_THRU | VARCHAR2 | (32) | ||
LOT_IND | NUMBER | (5) | Yes | |
WHSE_FROM | VARCHAR2 | (4) | ||
WHSE_THRU | VARCHAR2 | (4) | ||
INV_CLASS | VARCHAR2 | (8) | ||
TRANSDATE_FROM | DATE | |||
TRANSDELTA_TODAY | NUMBER | (5) | ||
TRANSDATE_THRU | DATE | |||
TRANSDELTA_THRU | NUMBER | (5) | ||
BACKUP_TYPE | NUMBER | (5) | ||
PROCESS_IND | NUMBER | (5) | ||
CRITERIA_COMMENT | VARCHAR2 | (70) | ||
MOVED_ROWCOUNT | NUMBER | (10) | ||
DELETED_ROWCOUNT | NUMBER | (10) | ||
ZERO_ROWCOUNT | NUMBER | (10) | ||
NEGBAL_ROWCOUNT | NUMBER | (10) | ||
IN_USE | NUMBER | (10) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
DELETE_MARK | NUMBER | (5) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
INV_CATEGORY_ID | NUMBER | |||
PURGE_PRECISION | NUMBER | (2) |
Cut, paste (and edit) the following text to query this object:
SELECT CRITERIA_NO
, VERSION_NO
, CRITERIA_ID
, TABLE_NAME
, OBJECT_CODE
, RUN_DATE
, ORGNCODE_FROM
, ORGNCODE_THRU
, DOCTYPE_FROM
, DOCTYPE_THRU
, ORGNDOC_FROM
, DOCNO_FROM
, ORGNDOC_THRU
, DOCNO_THRU
, DOCDELTA_TODAY
, DOCDATE_FROM
, DOCDELTA_THRU
, DOCDATE_THRU
, ITEMNO_FROM
, ITEMNO_THRU
, LOT_IND
, WHSE_FROM
, WHSE_THRU
, INV_CLASS
, TRANSDATE_FROM
, TRANSDELTA_TODAY
, TRANSDATE_THRU
, TRANSDELTA_THRU
, BACKUP_TYPE
, PROCESS_IND
, CRITERIA_COMMENT
, MOVED_ROWCOUNT
, DELETED_ROWCOUNT
, ZERO_ROWCOUNT
, NEGBAL_ROWCOUNT
, IN_USE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, DELETE_MARK
, LAST_UPDATE_LOGIN
, INV_CATEGORY_ID
, PURGE_PRECISION
FROM GMI.IC_PURG_PRM#;
|
|
|