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_ITYP_PKGS_V

Product:	IGS - Student System (Obsolete)
Description:	Store the package items included in an information type
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT KITEMS.ROW_ID ROW_ID
, KITEMS.DELIVERABLE_KIT_ITEM_ID
, INFOTYPE.PACKAGE_ITEM_ID INFO_TYPE_ID
, KITEMS.KIT_NAME INFORMATION_TYPE
, DELIV_KIT.DESCRIPTION INFORMATION_TYPE_DESC
, DELIV_KIT.KIT_FLAG INFORMATION_TYPE_KIT_FLAG
, PKGITM.PACKAGE_ITEM_ID
, KITEMS.KIT_PART_NAME PACKAGE_ITEM
, DELIV.DESCRIPTION PACKAGE_ITEM_DESC
, DELIV.KIT_FLAG PACKAGE_ITEM_KIT_FLAG
, KITEMS.OBJECT_VERSION_NUMBER
, KITEMS.CREATED_BY
, KITEMS.CREATION_DATE
, KITEMS.LAST_UPDATED_BY
, KITEMS.LAST_UPDATE_DATE
, KITEMS.LAST_UPDATE_LOGIN
FROM IGR_I_PKG_ITEM INFOTYPE
, IGR_I_PKG_ITEM PKGITM
, AMS_P_DELIV_KIT_ITEMS_V KITEMS
, AMS_P_DELIVERABLES_V DELIV
, AMS_P_DELIVERABLES_V DELIV_KIT
WHERE INFOTYPE.PACKAGE_ITEM_ID = KITEMS.DELIVERABLE_KIT_ID
AND PKGITM.PACKAGE_ITEM_ID = KITEMS.DELIVERABLE_KIT_PART_ID
AND INFOTYPE.PACKAGE_ITEM_ID = DELIV_KIT.DELIVERABLE_ID
AND PKGITM.PACKAGE_ITEM_ID = DELIV.DELIVERABLE_ID

Columns

Name
ROW_ID
DELIVERABLE_KIT_ITEM_ID
INFO_TYPE_ID
INFORMATION_TYPE
INFORMATION_TYPE_DESC
INFORMATION_TYPE_KIT_FLAG
PACKAGE_ITEM_ID
PACKAGE_ITEM
PACKAGE_ITEM_DESC
PACKAGE_ITEM_KIT_FLAG
OBJECT_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN