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: IGR_I_PKGITM_ASSIGN_V

Product:	IGS - Student System (Obsolete)
Description:	Form view for IGR_I_PKGITM_ASSIGN table
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PIA. ROWID ROW_ID
, PIA.PKG_ITEM_ASSIGN_ID
, PIA.PRODUCT_CATEGORY_ID
, DECODE(GREATEST(LENGTH(DENORM.CONCAT_CAT_PARENTAGE)
, 2000)
, 2000
, DENORM.CONCAT_CAT_PARENTAGE
, SUBSTR(DENORM.CONCAT_CAT_PARENTAGE
, LENGTH(DENORM.CONCAT_CAT_PARENTAGE)-1999
, 2000)) CONCATENATED_PRODUCT_CAT_DESC
, DENORM.CATEGORY_DESC PRODUCT_CATEGORY_DESC
, PIA.PRODUCT_CATEGORY_SET_ID
, PIA.PACKAGE_ITEM_ID
, PKGITM.DELIVERABLE_NAME PACKAGE_ITEM
, PKGITM.DESCRIPTION PKG_ITEM_DESC
, PIA.ENABLED_FLAG
, PIA.CREATED_BY
, PIA.CREATION_DATE
, PIA.LAST_UPDATED_BY
, PIA.LAST_UPDATE_DATE
, PIA.LAST_UPDATE_LOGIN
FROM IGR_I_PKGITM_ASSIGN PIA
, AMS_P_DELIVERABLES_V PKGITM
, ENI_PROD_DEN_HRCHY_PARENTS_V DENORM
WHERE PIA.PACKAGE_ITEM_ID = PKGITM.DELIVERABLE_ID
AND PIA.PRODUCT_CATEGORY_ID = DENORM.CATEGORY_ID

Columns

Name
ROW_ID
PKG_ITEM_ASSIGN_ID
PRODUCT_CATEGORY_ID
CONCATENATED_PRODUCT_CAT_DESC
PRODUCT_CATEGORY_DESC
PRODUCT_CATEGORY_SET_ID
PACKAGE_ITEM_ID
PACKAGE_ITEM
PKG_ITEM_DESC
ENABLED_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN