Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | View for Inventory Item to generate the xml data |
Implementation/DBA Data: | APPS.GR_ITEMS_XML |
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
, B.EVAPORATIONRATE1QUALIFER 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 (+)