Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Reduction of Package Items by Inquiry Unit Set |
Implementation/DBA Data: | Not implemented in this database |
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.INQ_PROG_ID
, PRG.CODE PROGRAM
, PRG.DESCRIPTION PRG_DESC
, REDUCT.INQ_USET_ID
, USET.CODE UNIT_SET
, USET.DESCRIPTION USET_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
, AS_INTEREST_CODES_VL PRG
, AS_INTEREST_CODES_VL USET
, IGS_RC_I_ENT_STATS RIES
WHERE REDUCT.REDUCTION_TYPE = 'UNIT_SET'
AND REDUCT.PACKAGE_ITEM_ID = PKGITM.DELIVERABLE_ID
AND PRG.INTEREST_TYPE_ID = ENT.INTEREST_TYPE_ID
AND PRG.INTEREST_CODE_ID = REDUCT.INQ_PROG_ID
AND USET.INTEREST_TYPE_ID = ENT.INTEREST_TYPE_ID
AND USET.PARENT_INTEREST_CODE_ID = PRG.INTEREST_CODE_ID
AND USET.INTEREST_CODE_ID = REDUCT.INQ_USET_ID
AND REDUCT.INQ_ENTRY_STAT_ID = RIES.INQ_ENTRY_STAT_ID
AND RIES.INTEREST_TYPE_ID = ENT.INTEREST_TYPE_ID