eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.GR_ITEMS_XML

Object Details

Object Name:	GR_ITEMS_XML
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GR.GR_ITEMS_XML
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGNID	NUMBER		Yes
ITEMID	NUMBER		Yes
PRODUCTNAME	VARCHAR2	(40)		Identifying the Regulatory Item Code.
PRODUCTDESCRIPTION	VARCHAR2	(240)		Identifying the Regulatory Item Description.
PRODUCTIDENTIFIER	VARCHAR2	(30)		Identifying the CAS Number for a Regulatory Item.
PRODUCTIDENTIFIERTYPE	CHAR	(7)		Identifying the CAS Number Type for a Regulatory Item.
CONSUMERUSE	VARCHAR2	(240)		Identifying the Physical Property ConsumerUse for the Regulatory Item.
PRODUCTUSE	VARCHAR2	(240)		Identifying the Physical Property ProductUse for the Regulatory Item.
TRADESECRETNUMBER	VARCHAR2	(240)		Identifying the Physical Property TradeSecretNumber for the Regulatory Item.
CARCENGENICITY	VARCHAR2	(240)		Identifying the Physical Property Carcengenicity for the Regulatory Item.
AUTOIGNITIONTEMP1UNIT	VARCHAR2	(240)
AUTOIGNITIONTEMP1	VARCHAR2	(40)
AUTOIGNITIONTEMP1QUALIFIER	VARCHAR2	(40)
LOWERFLAMELIMIT	VARCHAR2	(40)		Identifying the Physical Property LowerFlameLimit for the Regulatory Item.
UPPERFLAMELIMIT	VARCHAR2	(40)		Identifying the Physical Property UpperFlameLimit for the Regulatory Item.
FLASHPOINT1METHODUSED	VARCHAR2	(240)		Identifying the Physical Property flashPoint1MethodUsed for the Regulatory Item.
FLASHPOINT1TEMPUNIT	VARCHAR2	(240)		Identifying the Physical Property flashPoint1TempUnit for the Regulatory Item.
FLASHPOINT1	VARCHAR2	(40)		Identifying the Physical Property FlashPoint1 for the Regulatory Item.
FLASHPOINT2	VARCHAR2	(40)		Identifying the Physical Property FlashPoint2 for the Regulatory Item.
FLASHPOINT1QUALIFIER	VARCHAR2	(40)		Identifying the Physical Property FlashPoint1Qualifier for the Regulatory Item.
BOILINGPOINT1TEMPERATUREUNIT	VARCHAR2	(240)		Identifying the Physical Property boilingPoint1TemperatureUnit for the Regulatory Item.
BOILINGPOINT2	VARCHAR2	(40)		Identifying the Physical Property BoilingPoint2 for the Regulatory Item.
BOILINGPOINT1	VARCHAR2	(40)		Identifying the Physical Property BoilingPoint1 for the Regulatory Item.
BOILINGPOINT1QUALIFIER	VARCHAR2	(40)		Identifying the Physical Property BoilingPoint1Qualifier for the Regulatory Item.
COLOR	VARCHAR2	(240)		Identifying the Physical Property color for the Regulatory Item.
EVAPORATIONRATE1QUALIFER	VARCHAR2	(40)		Identifying the Physical Property evaporationRate1Qualifer for the Regulatory Item.
EVAPORATIONRATE1	VARCHAR2	(40)		Identifying the Physical Property EvaporationRate1 for the Regulatory Item.
FREEZINGPOINT1	VARCHAR2	(40)		Identifying the Physical Property FreezingPoint1 for the Regulatory Item.
FREEZINGPOINT1UNIT	VARCHAR2	(240)		Identifying the Physical Property freezingPoint1Unit for the Regulatory Item.
FREEZINGPOINT1QUALIFIER	VARCHAR2	(40)
IMMISCIBLEINWATER	VARCHAR2	(240)		Identifying the Physical Property ImmiscibleInWater for the Regulatory Item.
MELTINGPOINT1	VARCHAR2	(40)		Identifying the Physical Property MeltingPoint1 for the Regulatory Item.
MELTINGPOINT1TEMPUNIT	VARCHAR2	(240)		Identifying the Physical Property meltingPoint1TempUnit for the Regulatory Item.
MOISTUREABSORBING	VARCHAR2	(240)		Identifying the Physical Property MoistureAbsorbing for the Regulatory Item.
MOLECULARWEIGHT	VARCHAR2	(40)		Identifying the Physical Property MolecularWeight for the Regulatory Item.
MUTAGENICITY	VARCHAR2	(240)		Identifying the Physical Property Mutagenicity for the Regulatory Item.
ODOR	VARCHAR2	(240)		Identifying the Physical Property Odor for the Regulatory Item.
PH2	VARCHAR2	(40)		Identifying the Physical Property pH2 for the Regulatory Item.
PH1	VARCHAR2	(40)		Identifying the Physical Property pH1 for the Regulatory Item.
SKINIRRITANT	VARCHAR2	(240)		Identifying the Physical Property SkinIrritant for the Regulatory Item.
SOLUBILITYINETHANOL	VARCHAR2	(240)		Identifying the Physical Property SolubilityInEthanol for the Regulatory Item.
SOLUBILITYINFATS	VARCHAR2	(240)		Identifying the Physical Property SolubilityInFats for the Regulatory Item.
SOLUBILITYINGLYCEROL	VARCHAR2	(240)		Identifying the Physical Property SolubilityInGlycerol for the Regulatory Item.
OTHERSOLUBILITY	VARCHAR2	(240)		Identifying the Physical Property OtherSolubility for the Regulatory Item.
SOLUBILITYINWATER	VARCHAR2	(240)		Identifying the Physical Property SolubilityInWater for the Regulatory Item.
SPECIFICGRAVITY1	VARCHAR2	(40)		Identifying the Physical Property SpecificGravity1 for the Regulatory Item.
VAPORDENSITYUNIT	VARCHAR2	(240)		Identifying the Physical Property vaporDensityUnit for the Regulatory Item.
VAPORDENSITY	VARCHAR2	(40)		Identifying the Physical Property VaporDensity for the Regulatory Item.
VAPORPRESSURE1TEMPUNIT	VARCHAR2	(240)		Identifying the Physical Property vaporPressure1TempUnit for the Regulatory Item.
VAPORPRESSURE1TEMP	VARCHAR2	(40)		Identifying the Physical Property VaporPressure1Temp for the Regulatory Item.
VAPORPRESSURE1	VARCHAR2	(40)		Identifying the Physical Property VaporPressure1 for the Regulatory Item.
VOC	VARCHAR2	(240)		Identifying the Physical Property VOC for the Regulatory Item.
VOLATILEWEIGHT	VARCHAR2	(40)		Identifying the Physical Property VolatileWeight for the Regulatory Item.
VOLATILEVOLUME	VARCHAR2	(40)		Identifying the Physical Property volatileVolume for the Regulatory Item.
DECOMPOSITIONTEMP1UNIT	VARCHAR2	(240)		Identifying the Physical Property decompositionTemp1Unit for the Regulatory Item.
DECOMPOSITIONTEMP1	VARCHAR2	(40)		Identifying the Physical Property DecompositionTemp1 for the Regulatory Item.
DECOMPOSITIONTEMP1QUALIFIER	VARCHAR2	(40)		Identifying the Physical Property DecompositionTemp1Qualifier for the Regulatory Item.
HAZARDOUSPOLYMERIZATION	VARCHAR2	(240)		Identifying the Physical Property HazardousPolymerization for the Regulatory Item.
STRONGOXIDIZER	VARCHAR2	(240)		Identifying the Physical Property StrongOxidizer for the Regulatory Item.
TRADESECRETEXPIREDATE	VARCHAR2	(9)		Identifying the Physical Property TradeSecretExpireDate for the Regulatory Item.
TRADESECRETREGISTRATION	VARCHAR2	(240)		Identifying the Physical Property TradeSecretRegistration for the Regulatory Item.
UNNUMBER	VARCHAR2	(40)		Identifying the Physical Property UNNumber for the Regulatory Item.
CLASSIFICATIONTYPE	VARCHAR2	(240)		Identifying the Physical Property classificationType for the Regulatory Item.
UNSUBSIDIARYRISK	VARCHAR2	(40)		Identifying the Physical Property UnSubsidiaryRisk for the Regulatory Item.
TRANSPORTREGULATIONPACKGROUP	VARCHAR2	(240)		Identifying the Physical Property TransportRegulationPackGroup for the Regulatory Item.
EMERGENCYRESPNUMBER	VARCHAR2	(240)		Identifying the Physical Property EmergencyRespNumber for the Regulatory Item.
EMERGENCYSTORAGECODE	VARCHAR2	(240)		Identifying the Physical Property EmergencyStorageCode for the Regulatory Item.
KEMMLERNO	VARCHAR2	(240)		Identifying the Physical Property KemmlerNo for the Regulatory Item.
IMDGCLASS	VARCHAR2	(40)		Identifying the Physical Property IMDGClass for the Regulatory Item.
MARINEPOLLUTANT	VARCHAR2	(240)		Identifying the Physical Property MarinePollutant for the Regulatory Item.
ADRRIDNUMBER	VARCHAR2	(240)
ADRITEMCODE	VARCHAR2	(240)
ADNRWATERWAY	VARCHAR2	(240)
HAZCHEMCODE	VARCHAR2	(240)		Identifying the Physical Property HazchemCode for the Regulatory Item.
CHEMTRECNUMBER	VARCHAR2	(240)		Identifying the Physical Property ChemtrecNumber for the Regulatory Item.
CANUTECNUMBER	VARCHAR2	(240)		Identifying the Physical Property CANUTECNumber for the Regulatory Item.
EPAREGISTRATIONNUMBER	VARCHAR2	(240)		Identifying the Physical Property EPARegistrationNumber for the Regulatory Item.
SUPPLIERNUMBER	VARCHAR2	(40)		Identifying the Physical Property SupplierNumber for the Regulatory Item.
SUPPLIERREVISIONDATE	VARCHAR2	(9)		Identifying the Physical Property SupplierRevisionDate for the Regulatory Item.
SUPPLIERDATEPREPARED	VARCHAR2	(9)		Identifying the Physical Property SupplierDatePrepared for the Regulatory Item.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGNID
,      ITEMID
,      PRODUCTNAME
,      PRODUCTDESCRIPTION
,      PRODUCTIDENTIFIER
,      PRODUCTIDENTIFIERTYPE
,      CONSUMERUSE
,      PRODUCTUSE
,      TRADESECRETNUMBER
,      CARCENGENICITY
,      AUTOIGNITIONTEMP1UNIT
,      AUTOIGNITIONTEMP1
,      AUTOIGNITIONTEMP1QUALIFIER
,      LOWERFLAMELIMIT
,      UPPERFLAMELIMIT
,      FLASHPOINT1METHODUSED
,      FLASHPOINT1TEMPUNIT
,      FLASHPOINT1
,      FLASHPOINT2
,      FLASHPOINT1QUALIFIER
,      BOILINGPOINT1TEMPERATUREUNIT
,      BOILINGPOINT2
,      BOILINGPOINT1
,      BOILINGPOINT1QUALIFIER
,      COLOR
,      EVAPORATIONRATE1QUALIFER
,      EVAPORATIONRATE1
,      FREEZINGPOINT1
,      FREEZINGPOINT1UNIT
,      FREEZINGPOINT1QUALIFIER
,      IMMISCIBLEINWATER
,      MELTINGPOINT1
,      MELTINGPOINT1TEMPUNIT
,      MOISTUREABSORBING
,      MOLECULARWEIGHT
,      MUTAGENICITY
,      ODOR
,      PH2
,      PH1
,      SKINIRRITANT
,      SOLUBILITYINETHANOL
,      SOLUBILITYINFATS
,      SOLUBILITYINGLYCEROL
,      OTHERSOLUBILITY
,      SOLUBILITYINWATER
,      SPECIFICGRAVITY1
,      VAPORDENSITYUNIT
,      VAPORDENSITY
,      VAPORPRESSURE1TEMPUNIT
,      VAPORPRESSURE1TEMP
,      VAPORPRESSURE1
,      VOC
,      VOLATILEWEIGHT
,      VOLATILEVOLUME
,      DECOMPOSITIONTEMP1UNIT
,      DECOMPOSITIONTEMP1
,      DECOMPOSITIONTEMP1QUALIFIER
,      HAZARDOUSPOLYMERIZATION
,      STRONGOXIDIZER
,      TRADESECRETEXPIREDATE
,      TRADESECRETREGISTRATION
,      UNNUMBER
,      CLASSIFICATIONTYPE
,      UNSUBSIDIARYRISK
,      TRANSPORTREGULATIONPACKGROUP
,      EMERGENCYRESPNUMBER
,      EMERGENCYSTORAGECODE
,      KEMMLERNO
,      IMDGCLASS
,      MARINEPOLLUTANT
,      ADRRIDNUMBER
,      ADRITEMCODE
,      ADNRWATERWAY
,      HAZCHEMCODE
,      CHEMTRECNUMBER
,      CANUTECNUMBER
,      EPAREGISTRATIONNUMBER
,      SUPPLIERNUMBER
,      SUPPLIERREVISIONDATE
,      SUPPLIERDATEPREPARED
FROM APPS.GR_ITEMS_XML;

Dependencies

[top of page]

APPS.GR_ITEMS_XML references the following:

APPS: GR_PHYSICAL_PROPERTY_XML; MTL_SYSTEM_ITEMS_KFV

APPS.GR_ITEMS_XML is not referenced by any database object