VIEW: APPS.GR_ITEMS_XML

Source

View Text - Preformatted

SELECT g.organization_Id OrgnId, g.inventory_item_id ItemId, g.concatenated_segments ProductName , g.description ProductDescription , g.cas_number ProductIdentifier, 'CAS No.' productIdentifierType, b.ConsumerUse ConsumerUse, b.ProductUse ProductUse, b.TradeSecretNumber TradeSecretNumber, b.Carcengenicity Carcengenicity, b.autoignitionTemp1Unit autoignitionTemp1Unit, b.AutoignitionTemp1 AutoignitionTemp1, NVL2(b.AutoignitionTemp1, '=' ,b.AutoignitionTemp1 ) AutoignitionTemp1Qualifier, b.LowerFlameLimit LowerFlameLimit, b.UpperFlameLimit UpperFlameLimit, b.flashPoint1MethodUsed flashPoint1MethodUsed, b.flashPoint1TempUnit flashPoint1TempUnit, b.FlashPoint1 FlashPoint1, b.FlashPoint2 FlashPoint2, NVL2(b.FlashPoint1 ,'=' ,b.FlashPoint1 ) FlashPoint1Qualifier, b.boilingPoint1TemperatureUnit boilingPoint1TemperatureUnit, b.BoilingPoint2 BoilingPoint2, b.BoilingPoint1 BoilingPoint1, NVL2(b.BoilingPoint1, '=' ,b.BoilingPoint1 ) BoilingPoint1Qualifier, b.Color Color, NVL2 (b.evaporationrate1, '=', b.evaporationrate1) evaporationRate1Qualifer, b.EvaporationRate1 EvaporationRate1, b.FreezingPoint1 FreezingPoint1, b.freezingPoint1Unit freezingPoint1Unit, NVL2(b.FreezingPoint1 ,'=' ,b.FreezingPoint1 ) FreezingPoint1Qualifier, b.ImmiscibleInWater ImmiscibleInWater, b.MeltingPoint1 MeltingPoint1, b.meltingPoint1TempUnit meltingPoint1TempUnit, b.MoistureAbsorbing MoistureAbsorbing, b.MolecularWeight MolecularWeight, b.Mutagenicity Mutagenicity, b.Odor Odor, b.pH2 pH2, b.pH1 pH1, b.SkinIrritant SkinIrritant, b.SolubilityInEthanol SolubilityInEthanol, b.SolubilityInFats SolubilityInFats, b.SolubilityInGlycerol SolubilityInGlycerol, b.OtherSolubility OtherSolubility, b.SolubilityInWater SolubilityInWater, b.SpecificGravity1 SpecificGravity1, b.vaporDensityUnit vaporDensityUnit, b.VaporDensity VaporDensity, b.vaporPressure1TempUnit vaporPressure1TempUnit, b.VaporPressure1Temp VaporPressure1Temp, b.VaporPressure1 VaporPressure1, b.VOC VOC, b.VolatileWeight VolatileWeight, b.volatileVolume volatileVolume, b.decompositionTemp1Unit decompositionTemp1Unit, b.DecompositionTemp1 DecompositionTemp1, NVL2(b.DecompositionTemp1 ,'=' ,b.DecompositionTemp1 ) DecompositionTemp1Qualifier, b.HazardousPolymerization HazardousPolymerization, b.StrongOxidizer StrongOxidizer, b.TradeSecretExpireDate TradeSecretExpireDate, b.TradeSecretRegistration TradeSecretRegistration, b.UNNumber UNNumber, b.classificationType classificationType, b.UnSubsidiaryRisk UnSubsidiaryRisk, b.TransportRegulationPackGroup TransportRegulationPackGroup, b.EmergencyRespNumber EmergencyRespNumber, b.EmergencyStorageCode EmergencyStorageCode, b.KemmlerNo KemmlerNo, b.IMDGClass IMDGClass, b.MarinePollutant MarinePollutant, b.ADRRIDNumber ADRRIDNumber, b.ADRItemCode ADRItemCode, b.ADNRWaterway ADNRWaterway, b.HazchemCode HazchemCode, b.ChemtrecNumber ChemtrecNumber, b.CANUTECNumber CANUTECNumber, b.EPARegistrationNumber EPARegistrationNumber, b.SupplierNumber SupplierNumber, b.SupplierRevisionDate SupplierRevisionDate, b.SupplierDatePrepared SupplierDatePrepared FROM mtl_system_items_kfv g, gr_physical_property_xml b WHERE g.organization_id = b.orgnid (+) AND g.inventory_item_id = b.itemid (+)

View Text - HTML Formatted

SELECT G.ORGANIZATION_ID ORGNID
, G.INVENTORY_ITEM_ID ITEMID
, G.CONCATENATED_SEGMENTS PRODUCTNAME
, G.DESCRIPTION PRODUCTDESCRIPTION
, G.CAS_NUMBER PRODUCTIDENTIFIER
, 'CAS NO.' PRODUCTIDENTIFIERTYPE
, B.CONSUMERUSE CONSUMERUSE
, B.PRODUCTUSE PRODUCTUSE
, B.TRADESECRETNUMBER TRADESECRETNUMBER
, B.CARCENGENICITY CARCENGENICITY
, B.AUTOIGNITIONTEMP1UNIT AUTOIGNITIONTEMP1UNIT
, B.AUTOIGNITIONTEMP1 AUTOIGNITIONTEMP1
, NVL2(B.AUTOIGNITIONTEMP1
, '='
, B.AUTOIGNITIONTEMP1 ) AUTOIGNITIONTEMP1QUALIFIER
, B.LOWERFLAMELIMIT LOWERFLAMELIMIT
, B.UPPERFLAMELIMIT UPPERFLAMELIMIT
, B.FLASHPOINT1METHODUSED FLASHPOINT1METHODUSED
, B.FLASHPOINT1TEMPUNIT FLASHPOINT1TEMPUNIT
, B.FLASHPOINT1 FLASHPOINT1
, B.FLASHPOINT2 FLASHPOINT2
, NVL2(B.FLASHPOINT1
, '='
, B.FLASHPOINT1 ) FLASHPOINT1QUALIFIER
, B.BOILINGPOINT1TEMPERATUREUNIT BOILINGPOINT1TEMPERATUREUNIT
, B.BOILINGPOINT2 BOILINGPOINT2
, B.BOILINGPOINT1 BOILINGPOINT1
, NVL2(B.BOILINGPOINT1
, '='
, B.BOILINGPOINT1 ) BOILINGPOINT1QUALIFIER
, B.COLOR COLOR
, NVL2 (B.EVAPORATIONRATE1
, '='
, B.EVAPORATIONRATE1) EVAPORATIONRATE1QUALIFER
, B.EVAPORATIONRATE1 EVAPORATIONRATE1
, B.FREEZINGPOINT1 FREEZINGPOINT1
, B.FREEZINGPOINT1UNIT FREEZINGPOINT1UNIT
, NVL2(B.FREEZINGPOINT1
, '='
, B.FREEZINGPOINT1 ) FREEZINGPOINT1QUALIFIER
, B.IMMISCIBLEINWATER IMMISCIBLEINWATER
, B.MELTINGPOINT1 MELTINGPOINT1
, B.MELTINGPOINT1TEMPUNIT MELTINGPOINT1TEMPUNIT
, B.MOISTUREABSORBING MOISTUREABSORBING
, B.MOLECULARWEIGHT MOLECULARWEIGHT
, B.MUTAGENICITY MUTAGENICITY
, B.ODOR ODOR
, B.PH2 PH2
, B.PH1 PH1
, B.SKINIRRITANT SKINIRRITANT
, B.SOLUBILITYINETHANOL SOLUBILITYINETHANOL
, B.SOLUBILITYINFATS SOLUBILITYINFATS
, B.SOLUBILITYINGLYCEROL SOLUBILITYINGLYCEROL
, B.OTHERSOLUBILITY OTHERSOLUBILITY
, B.SOLUBILITYINWATER SOLUBILITYINWATER
, B.SPECIFICGRAVITY1 SPECIFICGRAVITY1
, B.VAPORDENSITYUNIT VAPORDENSITYUNIT
, B.VAPORDENSITY VAPORDENSITY
, B.VAPORPRESSURE1TEMPUNIT VAPORPRESSURE1TEMPUNIT
, B.VAPORPRESSURE1TEMP VAPORPRESSURE1TEMP
, B.VAPORPRESSURE1 VAPORPRESSURE1
, B.VOC VOC
, B.VOLATILEWEIGHT VOLATILEWEIGHT
, B.VOLATILEVOLUME VOLATILEVOLUME
, B.DECOMPOSITIONTEMP1UNIT DECOMPOSITIONTEMP1UNIT
, B.DECOMPOSITIONTEMP1 DECOMPOSITIONTEMP1
, NVL2(B.DECOMPOSITIONTEMP1
, '='
, B.DECOMPOSITIONTEMP1 ) DECOMPOSITIONTEMP1QUALIFIER
, B.HAZARDOUSPOLYMERIZATION HAZARDOUSPOLYMERIZATION
, B.STRONGOXIDIZER STRONGOXIDIZER
, B.TRADESECRETEXPIREDATE TRADESECRETEXPIREDATE
, B.TRADESECRETREGISTRATION TRADESECRETREGISTRATION
, B.UNNUMBER UNNUMBER
, B.CLASSIFICATIONTYPE CLASSIFICATIONTYPE
, B.UNSUBSIDIARYRISK UNSUBSIDIARYRISK
, B.TRANSPORTREGULATIONPACKGROUP TRANSPORTREGULATIONPACKGROUP
, B.EMERGENCYRESPNUMBER EMERGENCYRESPNUMBER
, B.EMERGENCYSTORAGECODE EMERGENCYSTORAGECODE
, B.KEMMLERNO KEMMLERNO
, B.IMDGCLASS IMDGCLASS
, B.MARINEPOLLUTANT MARINEPOLLUTANT
, B.ADRRIDNUMBER ADRRIDNUMBER
, B.ADRITEMCODE ADRITEMCODE
, B.ADNRWATERWAY ADNRWATERWAY
, B.HAZCHEMCODE HAZCHEMCODE
, B.CHEMTRECNUMBER CHEMTRECNUMBER
, B.CANUTECNUMBER CANUTECNUMBER
, B.EPAREGISTRATIONNUMBER EPAREGISTRATIONNUMBER
, B.SUPPLIERNUMBER SUPPLIERNUMBER
, B.SUPPLIERREVISIONDATE SUPPLIERREVISIONDATE
, B.SUPPLIERDATEPREPARED SUPPLIERDATEPREPARED
FROM MTL_SYSTEM_ITEMS_KFV G
, GR_PHYSICAL_PROPERTY_XML B
WHERE G.ORGANIZATION_ID = B.ORGNID (+)
AND G.INVENTORY_ITEM_ID = B.ITEMID (+)