View: JAI_RGM_ITEM_ATTRIB_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_RGM_ITEM_ATTRIB_V

View Text

SELECT ITATT.ROWID ROW_ID
, RGTMP.TEMPLATE_ID
, RGTMP.TEMPLATE_NAME
, TO_NUMBER(NULL) RGM_ITEM_REGNS_ID
, RGTMP.REGIME_CODE
, TORG.ORGANIZATION_ID
, TIRG.INVENTORY_ITEM_ID
, ITATT.ATTRIBUTE_CODE
, ITATT.ATTRIBUTE_VALUE
, ITATT.CREATION_DATE
, ITATT.CREATED_BY
, ITATT.LAST_UPDATE_DATE
, ITATT.LAST_UPDATED_BY
, ITATT.LAST_UPDATE_LOGIN
FROM JAI_RGM_ITM_TMPL_ATTRS ITATT
, JAI_RGM_ITM_TEMPLATES RGTMP
, JAI_RGM_TMPL_ORG_REGNS TORG
, JAI_RGM_TMPL_ITM_REGNS TIRG
WHERE ITATT.TEMPLATE_ID = RGTMP.TEMPLATE_ID
AND RGTMP.TEMPLATE_ID = TORG.TEMPLATE_ID
AND TORG.TEMPL_ORG_REGNS_ID = TIRG.TEMPL_ORG_REGNS_ID
AND NOT EXISTS (SELECT 1
FROM JAI_RGM_ITM_TMPL_ATTRS ITEM_ATT
, JAI_RGM_ITM_REGNS ITEM_REG
WHERE ITEM_ATT.RGM_ITEM_REGNS_ID = ITEM_REG.RGM_ITEM_REGNS_ID
AND ITEM_ATT.ATTRIBUTE_CODE = ITATT.ATTRIBUTE_CODE
AND ITEM_REG.REGIME_CODE = RGTMP.REGIME_CODE
AND ITEM_REG.ORGANIZATION_ID = TORG.ORGANIZATION_ID
AND ITEM_REG.INVENTORY_ITEM_ID = TIRG.INVENTORY_ITEM_ID
AND ITEM_ATT.TEMPLATE_ID IS NULL ) UNION ALL SELECT ITATT.ROWID ROW_ID
, TO_NUMBER(NULL) TEMPLATE_ID
, TO_CHAR (NULL) TEMPLATE_NAME
, ITATT.RGM_ITEM_REGNS_ID RGM_ITEM_REGNS_ID
, RIRG.REGIME_CODE
, RIRG.ORGANIZATION_ID
, RIRG.INVENTORY_ITEM_ID
, ITATT.ATTRIBUTE_CODE
, ITATT.ATTRIBUTE_VALUE
, ITATT.CREATION_DATE
, ITATT.CREATED_BY
, ITATT.LAST_UPDATE_DATE
, ITATT.LAST_UPDATED_BY
, ITATT.LAST_UPDATE_LOGIN
FROM JAI_RGM_ITM_TMPL_ATTRS ITATT
, JAI_RGM_ITM_REGNS RIRG
WHERE ITATT.RGM_ITEM_REGNS_ID = RIRG.RGM_ITEM_REGNS_ID
AND ITATT.TEMPLATE_ID IS NULL

Columns