eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_RC_I_ENT_PKGS_V

Product:	IGS - Student System
Description:	Reduction of Package Items by Entry Status
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT REDUCT. ROWID ROW_ID
, REDUCT.PKG_ITEM_REDUCT_ID
, REDUCT.REDUCTION_TYPE
, REDUCT.ENABLED_FLAG
, REDUCT.INQ_ENTRY_STAT_ID
, ENT.INTEREST_TYPE ENTRY_STATUS
, ENT.DESCRIPTION ENTRY_STATUS_DESC
, REDUCT.PACKAGE_ITEM_ID
, PKGITM.DELIVERABLE_NAME PACKAGE_ITEM
, PKGITM.DESCRIPTION PKG_ITEM_DESC
, REDUCT.CREATED_BY
, REDUCT.CREATION_DATE
, REDUCT.LAST_UPDATED_BY
, REDUCT.LAST_UPDATE_DATE
, REDUCT.LAST_UPDATE_LOGIN
FROM IGS_RC_I_PKG_REDUCT REDUCT
, AMS_P_DELIVERABLES_V PKGITM
, AS_INTEREST_TYPES_VL ENT
, IGS_RC_I_ENT_STATS RIES
WHERE REDUCT.REDUCTION_TYPE = 'ENTRY_STATUS'
AND REDUCT.PACKAGE_ITEM_ID = PKGITM.DELIVERABLE_ID
AND REDUCT.INQ_ENTRY_STAT_ID = RIES.INQ_ENTRY_STAT_ID
AND RIES.INTEREST_TYPE_ID = ENT.INTEREST_TYPE_ID

Columns

Name
ROW_ID
PKG_ITEM_REDUCT_ID
REDUCTION_TYPE
ENABLED_FLAG
INQ_ENTRY_STAT_ID
ENTRY_STATUS
ENTRY_STATUS_DESC
PACKAGE_ITEM_ID
PACKAGE_ITEM
PKG_ITEM_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN