VIEW: APPS.CZ_EXV_ITEM_APC_PROP_VALUES

Source

View Text - Preformatted

SELECT "EXTENSION_ID","ORGANIZATION_ID","INVENTORY_ITEM_ID","REVISION_ID","ITEM_CATALOG_GROUP_ID","ATTR_GROUP_ID","DATA_LEVEL_ID","PK1_VALUE","PK2_VALUE","PK3_VALUE","PK4_VALUE","PK5_VALUE","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","SOURCE_LANG","LANGUAGE","C_EXT_ATTR1","C_EXT_ATTR2","C_EXT_ATTR3","C_EXT_ATTR4","C_EXT_ATTR5","C_EXT_ATTR6","C_EXT_ATTR7","C_EXT_ATTR8","C_EXT_ATTR9","C_EXT_ATTR10","C_EXT_ATTR11","C_EXT_ATTR12","C_EXT_ATTR13","C_EXT_ATTR14","C_EXT_ATTR15","C_EXT_ATTR16","C_EXT_ATTR17","C_EXT_ATTR18","C_EXT_ATTR19","C_EXT_ATTR20","N_EXT_ATTR1","UOM_EXT_ATTR1","N_EXT_ATTR2","UOM_EXT_ATTR2","N_EXT_ATTR3","UOM_EXT_ATTR3","N_EXT_ATTR4","UOM_EXT_ATTR4","N_EXT_ATTR5","UOM_EXT_ATTR5","N_EXT_ATTR6","UOM_EXT_ATTR6","N_EXT_ATTR7","UOM_EXT_ATTR7","N_EXT_ATTR8","UOM_EXT_ATTR8","N_EXT_ATTR9","UOM_EXT_ATTR9","N_EXT_ATTR10","UOM_EXT_ATTR10","D_EXT_ATTR1","D_EXT_ATTR2","D_EXT_ATTR3","D_EXT_ATTR4","D_EXT_ATTR5","C_EXT_ATTR21","C_EXT_ATTR22","C_EXT_ATTR23","C_EXT_ATTR24","C_EXT_ATTR25","C_EXT_ATTR26","C_EXT_ATTR27","C_EXT_ATTR28","C_EXT_ATTR29","C_EXT_ATTR30","C_EXT_ATTR31","C_EXT_ATTR32","C_EXT_ATTR33","C_EXT_ATTR34","C_EXT_ATTR35","C_EXT_ATTR36","C_EXT_ATTR37","C_EXT_ATTR38","C_EXT_ATTR39","C_EXT_ATTR40","N_EXT_ATTR11","UOM_EXT_ATTR11","N_EXT_ATTR12","UOM_EXT_ATTR12","N_EXT_ATTR13","UOM_EXT_ATTR13","N_EXT_ATTR14","UOM_EXT_ATTR14","N_EXT_ATTR15","UOM_EXT_ATTR15","N_EXT_ATTR16","UOM_EXT_ATTR16","N_EXT_ATTR17","UOM_EXT_ATTR17","N_EXT_ATTR18","UOM_EXT_ATTR18","N_EXT_ATTR19","UOM_EXT_ATTR19","N_EXT_ATTR20","UOM_EXT_ATTR20","D_EXT_ATTR6","D_EXT_ATTR7","D_EXT_ATTR8","D_EXT_ATTR9","D_EXT_ATTR10","TL_EXT_ATTR1","TL_EXT_ATTR2","TL_EXT_ATTR3","TL_EXT_ATTR4","TL_EXT_ATTR5","TL_EXT_ATTR6","TL_EXT_ATTR7","TL_EXT_ATTR8","TL_EXT_ATTR9","TL_EXT_ATTR10","TL_EXT_ATTR11","TL_EXT_ATTR12","TL_EXT_ATTR13","TL_EXT_ATTR14","TL_EXT_ATTR15","TL_EXT_ATTR16","TL_EXT_ATTR17","TL_EXT_ATTR18","TL_EXT_ATTR19","TL_EXT_ATTR20","TL_EXT_ATTR21","TL_EXT_ATTR22","TL_EXT_ATTR23","TL_EXT_ATTR24","TL_EXT_ATTR25","TL_EXT_ATTR26","TL_EXT_ATTR27","TL_EXT_ATTR28","TL_EXT_ATTR29","TL_EXT_ATTR30","TL_EXT_ATTR31","TL_EXT_ATTR32","TL_EXT_ATTR33","TL_EXT_ATTR34","TL_EXT_ATTR35","TL_EXT_ATTR36","TL_EXT_ATTR37","TL_EXT_ATTR38","TL_EXT_ATTR39","TL_EXT_ATTR40" FROM EGO_MTL_SY_ITEMS_EXT_VL  c  WHERE EXISTS (SELECT NULL FROM EGO_ATTR_GROUPS_V  attrgrps ,EGO_ATTRS_V  attrs ,EGO_ITMATTR_APPL_USGS_B  usgs ,FND_OBJECTS  objs WHERE attrgrps.attr_group_id=c.attr_group_id  AND objs.OBJ_NAME = 'EGO_ITEM' AND attrgrps.ATTR_GROUP_TYPE = attrs.ATTR_GROUP_TYPE AND attrgrps.ATTR_GROUP_NAME = attrs.ATTR_GROUP_NAME AND attrs.APPLICATION_ID = 431 AND attrgrps.APPLICATION_ID = 431 AND usgs.ATTR_ID = attrs.ATTR_ID AND usgs.ENABLED_FLAG = 'Y' AND usgs.APPLICATION_ID = 708 AND attrgrps.attr_group_type='EGO_ITEMMGMT_GROUP' AND  attrs.ENABLED_FLAG='Y') 

View Text - HTML Formatted

SELECT "EXTENSION_ID"
, "ORGANIZATION_ID"
, "INVENTORY_ITEM_ID"
, "REVISION_ID"
, "ITEM_CATALOG_GROUP_ID"
, "ATTR_GROUP_ID"
, "DATA_LEVEL_ID"
, "PK1_VALUE"
, "PK2_VALUE"
, "PK3_VALUE"
, "PK4_VALUE"
, "PK5_VALUE"
, "CREATED_BY"
, "CREATION_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
, "SOURCE_LANG"
, "LANGUAGE"
, "C_EXT_ATTR1"
, "C_EXT_ATTR2"
, "C_EXT_ATTR3"
, "C_EXT_ATTR4"
, "C_EXT_ATTR5"
, "C_EXT_ATTR6"
, "C_EXT_ATTR7"
, "C_EXT_ATTR8"
, "C_EXT_ATTR9"
, "C_EXT_ATTR10"
, "C_EXT_ATTR11"
, "C_EXT_ATTR12"
, "C_EXT_ATTR13"
, "C_EXT_ATTR14"
, "C_EXT_ATTR15"
, "C_EXT_ATTR16"
, "C_EXT_ATTR17"
, "C_EXT_ATTR18"
, "C_EXT_ATTR19"
, "C_EXT_ATTR20"
, "N_EXT_ATTR1"
, "UOM_EXT_ATTR1"
, "N_EXT_ATTR2"
, "UOM_EXT_ATTR2"
, "N_EXT_ATTR3"
, "UOM_EXT_ATTR3"
, "N_EXT_ATTR4"
, "UOM_EXT_ATTR4"
, "N_EXT_ATTR5"
, "UOM_EXT_ATTR5"
, "N_EXT_ATTR6"
, "UOM_EXT_ATTR6"
, "N_EXT_ATTR7"
, "UOM_EXT_ATTR7"
, "N_EXT_ATTR8"
, "UOM_EXT_ATTR8"
, "N_EXT_ATTR9"
, "UOM_EXT_ATTR9"
, "N_EXT_ATTR10"
, "UOM_EXT_ATTR10"
, "D_EXT_ATTR1"
, "D_EXT_ATTR2"
, "D_EXT_ATTR3"
, "D_EXT_ATTR4"
, "D_EXT_ATTR5"
, "C_EXT_ATTR21"
, "C_EXT_ATTR22"
, "C_EXT_ATTR23"
, "C_EXT_ATTR24"
, "C_EXT_ATTR25"
, "C_EXT_ATTR26"
, "C_EXT_ATTR27"
, "C_EXT_ATTR28"
, "C_EXT_ATTR29"
, "C_EXT_ATTR30"
, "C_EXT_ATTR31"
, "C_EXT_ATTR32"
, "C_EXT_ATTR33"
, "C_EXT_ATTR34"
, "C_EXT_ATTR35"
, "C_EXT_ATTR36"
, "C_EXT_ATTR37"
, "C_EXT_ATTR38"
, "C_EXT_ATTR39"
, "C_EXT_ATTR40"
, "N_EXT_ATTR11"
, "UOM_EXT_ATTR11"
, "N_EXT_ATTR12"
, "UOM_EXT_ATTR12"
, "N_EXT_ATTR13"
, "UOM_EXT_ATTR13"
, "N_EXT_ATTR14"
, "UOM_EXT_ATTR14"
, "N_EXT_ATTR15"
, "UOM_EXT_ATTR15"
, "N_EXT_ATTR16"
, "UOM_EXT_ATTR16"
, "N_EXT_ATTR17"
, "UOM_EXT_ATTR17"
, "N_EXT_ATTR18"
, "UOM_EXT_ATTR18"
, "N_EXT_ATTR19"
, "UOM_EXT_ATTR19"
, "N_EXT_ATTR20"
, "UOM_EXT_ATTR20"
, "D_EXT_ATTR6"
, "D_EXT_ATTR7"
, "D_EXT_ATTR8"
, "D_EXT_ATTR9"
, "D_EXT_ATTR10"
, "TL_EXT_ATTR1"
, "TL_EXT_ATTR2"
, "TL_EXT_ATTR3"
, "TL_EXT_ATTR4"
, "TL_EXT_ATTR5"
, "TL_EXT_ATTR6"
, "TL_EXT_ATTR7"
, "TL_EXT_ATTR8"
, "TL_EXT_ATTR9"
, "TL_EXT_ATTR10"
, "TL_EXT_ATTR11"
, "TL_EXT_ATTR12"
, "TL_EXT_ATTR13"
, "TL_EXT_ATTR14"
, "TL_EXT_ATTR15"
, "TL_EXT_ATTR16"
, "TL_EXT_ATTR17"
, "TL_EXT_ATTR18"
, "TL_EXT_ATTR19"
, "TL_EXT_ATTR20"
, "TL_EXT_ATTR21"
, "TL_EXT_ATTR22"
, "TL_EXT_ATTR23"
, "TL_EXT_ATTR24"
, "TL_EXT_ATTR25"
, "TL_EXT_ATTR26"
, "TL_EXT_ATTR27"
, "TL_EXT_ATTR28"
, "TL_EXT_ATTR29"
, "TL_EXT_ATTR30"
, "TL_EXT_ATTR31"
, "TL_EXT_ATTR32"
, "TL_EXT_ATTR33"
, "TL_EXT_ATTR34"
, "TL_EXT_ATTR35"
, "TL_EXT_ATTR36"
, "TL_EXT_ATTR37"
, "TL_EXT_ATTR38"
, "TL_EXT_ATTR39"
, "TL_EXT_ATTR40"
FROM EGO_MTL_SY_ITEMS_EXT_VL C
WHERE EXISTS (SELECT NULL
FROM EGO_ATTR_GROUPS_V ATTRGRPS
, EGO_ATTRS_V ATTRS
, EGO_ITMATTR_APPL_USGS_B USGS
, FND_OBJECTS OBJS
WHERE ATTRGRPS.ATTR_GROUP_ID=C.ATTR_GROUP_ID
AND OBJS.OBJ_NAME = 'EGO_ITEM'
AND ATTRGRPS.ATTR_GROUP_TYPE = ATTRS.ATTR_GROUP_TYPE
AND ATTRGRPS.ATTR_GROUP_NAME = ATTRS.ATTR_GROUP_NAME
AND ATTRS.APPLICATION_ID = 431
AND ATTRGRPS.APPLICATION_ID = 431
AND USGS.ATTR_ID = ATTRS.ATTR_ID
AND USGS.ENABLED_FLAG = 'Y'
AND USGS.APPLICATION_ID = 708
AND ATTRGRPS.ATTR_GROUP_TYPE='EGO_ITEMMGMT_GROUP'
AND ATTRS.ENABLED_FLAG='Y')