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: ViewGR.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:

SchemaAPPS
ViewGR_PHYSICAL_PROPERTY_XML
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.GR_ITEMS_XML is not referenced by any database object