VIEW: APPS.JAI_RGM_ITEM_ATTRIB_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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