VIEW: APPS.IGR_I_PKGITM_ASSIGN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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