VIEW: GMI.IC_PURG_PRM#

Source

View Text - Preformatted

select CRITERIA_NO CRITERIA_NO, VERSION_NO VERSION_NO, CRITERIA_ID CRITERIA_ID, TABLE_NAME TABLE_NAME, OBJECT_CODE OBJECT_CODE, RUN_DATE RUN_DATE, ORGNCODE_FROM ORGNCODE_FROM, ORGNCODE_THRU ORGNCODE_THRU, DOCTYPE_FROM DOCTYPE_FROM, DOCTYPE_THRU DOCTYPE_THRU, ORGNDOC_FROM ORGNDOC_FROM, DOCNO_FROM DOCNO_FROM, ORGNDOC_THRU ORGNDOC_THRU, DOCNO_THRU DOCNO_THRU, DOCDELTA_TODAY DOCDELTA_TODAY, DOCDATE_FROM DOCDATE_FROM, DOCDELTA_THRU DOCDELTA_THRU, DOCDATE_THRU DOCDATE_THRU, ITEMNO_FROM ITEMNO_FROM, ITEMNO_THRU ITEMNO_THRU, LOT_IND LOT_IND, WHSE_FROM WHSE_FROM, WHSE_THRU WHSE_THRU, INV_CLASS INV_CLASS, TRANSDATE_FROM TRANSDATE_FROM, TRANSDELTA_TODAY TRANSDELTA_TODAY, TRANSDATE_THRU TRANSDATE_THRU, TRANSDELTA_THRU TRANSDELTA_THRU, BACKUP_TYPE BACKUP_TYPE, PROCESS_IND PROCESS_IND, CRITERIA_COMMENT CRITERIA_COMMENT, MOVED_ROWCOUNT MOVED_ROWCOUNT, DELETED_ROWCOUNT DELETED_ROWCOUNT, ZERO_ROWCOUNT ZERO_ROWCOUNT, NEGBAL_ROWCOUNT NEGBAL_ROWCOUNT, IN_USE IN_USE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETE_MARK DELETE_MARK, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INV_CATEGORY_ID INV_CATEGORY_ID, PURGE_PRECISION PURGE_PRECISION from "GMI"."IC_PURG_PRM"

View Text - HTML Formatted

SELECT CRITERIA_NO CRITERIA_NO
, VERSION_NO VERSION_NO
, CRITERIA_ID CRITERIA_ID
, TABLE_NAME TABLE_NAME
, OBJECT_CODE OBJECT_CODE
, RUN_DATE RUN_DATE
, ORGNCODE_FROM ORGNCODE_FROM
, ORGNCODE_THRU ORGNCODE_THRU
, DOCTYPE_FROM DOCTYPE_FROM
, DOCTYPE_THRU DOCTYPE_THRU
, ORGNDOC_FROM ORGNDOC_FROM
, DOCNO_FROM DOCNO_FROM
, ORGNDOC_THRU ORGNDOC_THRU
, DOCNO_THRU DOCNO_THRU
, DOCDELTA_TODAY DOCDELTA_TODAY
, DOCDATE_FROM DOCDATE_FROM
, DOCDELTA_THRU DOCDELTA_THRU
, DOCDATE_THRU DOCDATE_THRU
, ITEMNO_FROM ITEMNO_FROM
, ITEMNO_THRU ITEMNO_THRU
, LOT_IND LOT_IND
, WHSE_FROM WHSE_FROM
, WHSE_THRU WHSE_THRU
, INV_CLASS INV_CLASS
, TRANSDATE_FROM TRANSDATE_FROM
, TRANSDELTA_TODAY TRANSDELTA_TODAY
, TRANSDATE_THRU TRANSDATE_THRU
, TRANSDELTA_THRU TRANSDELTA_THRU
, BACKUP_TYPE BACKUP_TYPE
, PROCESS_IND PROCESS_IND
, CRITERIA_COMMENT CRITERIA_COMMENT
, MOVED_ROWCOUNT MOVED_ROWCOUNT
, DELETED_ROWCOUNT DELETED_ROWCOUNT
, ZERO_ROWCOUNT ZERO_ROWCOUNT
, NEGBAL_ROWCOUNT NEGBAL_ROWCOUNT
, IN_USE IN_USE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETE_MARK DELETE_MARK
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INV_CATEGORY_ID INV_CATEGORY_ID
, PURGE_PRECISION PURGE_PRECISION
FROM "GMI"."IC_PURG_PRM"