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_PHYSICAL_PROPERTY_XML

Object Details

Object Name:	GR_PHYSICAL_PROPERTY_XML
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GR.GR_PHYSICAL_PROPERTY_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	(15)	Yes	Identifying the Organization ID.
ITEMID	NUMBER	(15)	Yes	Identifying the Inventory Item ID.
CONSUMERUSE	VARCHAR2	(240)		Identifying the Physical Property ConsumerUse for the Inventory Item.
PRODUCTUSE	VARCHAR2	(240)		Identifying the Physical Property ProductUse for the Inventory Item.
TRADESECRETNUMBER	VARCHAR2	(240)		Identifying the Physical Property TradeSecretNumber for the Inventory Item.
CARCENGENICITY	VARCHAR2	(240)		Identifying the Physical Property Carcengenicity for the Inventory Item.
AUTOIGNITIONTEMP1UNIT	VARCHAR2	(240)
AUTOIGNITIONTEMP1	VARCHAR2	(40)
LOWERFLAMELIMIT	VARCHAR2	(40)		Identifying the Physical Property LowerFlameLimit for the Inventory Item.
UPPERFLAMELIMIT	VARCHAR2	(40)		Identifying the Physical Property UpperFlameLimit for the Inventory Item.
FLASHPOINT1METHODUSED	VARCHAR2	(240)		Identifying the Physical Property flashPoint1MethodUsed for the Inventory Item.
FLASHPOINT1TEMPUNIT	VARCHAR2	(240)		Identifying the Physical Property flashPoint1TempUnit for the Inventory Item.
FLASHPOINT1	VARCHAR2	(40)		Identifying the Physical Property FlashPoint1 for the Inventory Item.
FLASHPOINT2	VARCHAR2	(40)		Identifying the Physical Property FlashPoint2 for the Inventory Item.
BOILINGPOINT1TEMPERATUREUNIT	VARCHAR2	(240)		Identifying the Physical Property boilingPoint1TemperatureUnit for the Inventory Item.
BOILINGPOINT2	VARCHAR2	(40)		Identifying the Physical Property BoilingPoint2 for the Inventory Item.
BOILINGPOINT1	VARCHAR2	(40)		Identifying the Physical Property BoilingPoint1 for the Inventory Item.
COLOR	VARCHAR2	(240)		Identifying the Physical Property color for the Inventory Item.
EVAPORATIONRATE1QUALIFER	VARCHAR2	(1)		Identifying the Physical Property evaporationRate1Qualifer for the Inventory Item.
EVAPORATIONRATE1	VARCHAR2	(40)		Identifying the Physical Property EvaporationRate1 for the Inventory Item.
FREEZINGPOINT1	VARCHAR2	(40)		Identifying the Physical Property FreezingPoint1 for the Inventory Item.
FREEZINGPOINT1UNIT	VARCHAR2	(240)		Identifying the Physical Property freezingPoint1Unit for the Inventory Item.
IMMISCIBLEINWATER	VARCHAR2	(240)		Identifying the Physical Property ImmiscibleInWater for the Inventory Item.
MELTINGPOINT1	VARCHAR2	(40)		Identifying the Physical Property MeltingPoint1 for the Inventory Item.
MELTINGPOINT1TEMPUNIT	VARCHAR2	(240)		Identifying the Physical Property meltingPoint1TempUnit for the Inventory Item.
MOISTUREABSORBING	VARCHAR2	(240)		Identifying the Physical Property MoistureAbsorbing for the Inventory Item.
MOLECULARWEIGHT	VARCHAR2	(40)		Identifying the Physical Property MolecularWeight for the Inventory Item.
MUTAGENICITY	VARCHAR2	(240)		Identifying the Physical Property Mutagenicity for the Inventory Item.
ODOR	VARCHAR2	(240)		Identifying the Physical Property Odor for the Inventory Item.
PH2	VARCHAR2	(40)		Identifying the Physical Property pH2 for the Inventory Item.
PH1	VARCHAR2	(40)		Identifying the Physical Property pH1 for the Inventory Item.
SKINIRRITANT	VARCHAR2	(240)		Identifying the Physical Property SkinIrritant for the Inventory Item.
SOLUBILITYINETHANOL	VARCHAR2	(240)		Identifying the Physical Property SolubilityInEthanol for the Inventory Item.
SOLUBILITYINFATS	VARCHAR2	(240)		Identifying the Physical Property SolubilityInFats for the Inventory Item.
SOLUBILITYINGLYCEROL	VARCHAR2	(240)		Identifying the Physical Property SolubilityInGlycerol for the Inventory Item.
OTHERSOLUBILITY	VARCHAR2	(240)		Identifying the Physical Property OtherSolubility for the Inventory Item.
SOLUBILITYINWATER	VARCHAR2	(240)		Identifying the Physical Property SolubilityInWater for the Inventory Item.
SPECIFICGRAVITY1	VARCHAR2	(40)		Identifying the Physical Property SpecificGravity1 for the Inventory Item.
VAPORDENSITYUNIT	VARCHAR2	(240)		Identifying the Physical Property vaporDensityUnit for the Inventory Item.
VAPORDENSITY	VARCHAR2	(40)		Identifying the Physical Property VaporDensity for the Inventory Item.
VAPORPRESSURE1TEMPUNIT	VARCHAR2	(240)		Identifying the Physical Property vaporPressure1TempUnit for the Inventory Item.
VAPORPRESSURE1TEMP	VARCHAR2	(40)		Identifying the Physical Property VaporPressure1Temp for the Inventory Item.
VAPORPRESSURE1	VARCHAR2	(40)		Identifying the Physical Property VaporPressure1 for the Inventory Item.
VOC	VARCHAR2	(240)		Identifying the Physical Property VOC for the Inventory Item.
VOLATILEWEIGHT	VARCHAR2	(40)		Identifying the Physical Property VolatileWeight for the Inventory Item.
VOLATILEVOLUME	VARCHAR2	(40)		Identifying the Physical Property volatileVolume for the Inventory Item.
DECOMPOSITIONTEMP1UNIT	VARCHAR2	(240)		Identifying the Physical Property decompositionTemp1Unit for the Inventory Item.
DECOMPOSITIONTEMP1	VARCHAR2	(40)		Identifying the Physical Property HazardousPolymerization for the Inventory Item.
HAZARDOUSPOLYMERIZATION	VARCHAR2	(240)
STRONGOXIDIZER	VARCHAR2	(240)		Identifying the Physical Property StrongOxidizer for the Inventory Item.
TRADESECRETEXPIREDATE	VARCHAR2	(9)		Identifying the Physical Property TradeSecretExpireDate for the Inventory Item.
TRADESECRETREGISTRATION	VARCHAR2	(240)		Identifying the Physical Property TradeSecretRegistration for the Inventory Item.
UNNUMBER	VARCHAR2	(40)		Identifying the Physical Property UNNumber for the Inventory Item.
CLASSIFICATIONTYPE	VARCHAR2	(240)		Identifying the Physical Property classificationType for the Inventory Item.
UNSUBSIDIARYRISK	VARCHAR2	(40)		Identifying the Physical Property UnSubsidiaryRisk for the Inventory Item.
TRANSPORTREGULATIONPACKGROUP	VARCHAR2	(240)		Identifying the Physical Property TransportRegulationPackGroup for the Inventory Item.
EMERGENCYRESPNUMBER	VARCHAR2	(240)		Identifying the Physical Property EmergencyRespNumber for the Inventory Item.
EMERGENCYSTORAGECODE	VARCHAR2	(240)		Identifying the Physical Property EmergencyStorageCode for the Inventory Item.
KEMMLERNO	VARCHAR2	(240)		Identifying the Physical Property KemmlerNo for the Inventory Item.
IMDGCLASS	VARCHAR2	(40)		Identifying the Physical Property IMDGClass for the Inventory Item.
MARINEPOLLUTANT	VARCHAR2	(240)		Identifying the Physical Property MarinePollutant for the Inventory Item.
ADRRIDNUMBER	VARCHAR2	(240)
ADRITEMCODE	VARCHAR2	(240)
ADNRWATERWAY	VARCHAR2	(240)
HAZCHEMCODE	VARCHAR2	(240)		Identifying the Physical Property HazchemCode for the Inventory Item.
CHEMTRECNUMBER	VARCHAR2	(240)		Identifying the Physical Property ChemtrecNumber for the Inventory Item.
CANUTECNUMBER	VARCHAR2	(240)		Identifying the Physical Property CANUTECNumber for the Inventory Item.
EPAREGISTRATIONNUMBER	VARCHAR2	(240)		Identifying the Physical Property EPARegistrationNumber for the Inventory Item.
SUPPLIERNUMBER	VARCHAR2	(40)		Identifying the Physical Property SupplierNumber for the Inventory Item.
SUPPLIERREVISIONDATE	VARCHAR2	(9)		Identifying the Physical Property SupplierRevisionDate for the Inventory Item.
SUPPLIERDATEPREPARED	VARCHAR2	(9)		Identifying the Physical Property SupplierDatePrepared for the Inventory Item.

Query Text

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


SELECT ORGNID
,      ITEMID
,      CONSUMERUSE
,      PRODUCTUSE
,      TRADESECRETNUMBER
,      CARCENGENICITY
,      AUTOIGNITIONTEMP1UNIT
,      AUTOIGNITIONTEMP1
,      LOWERFLAMELIMIT
,      UPPERFLAMELIMIT
,      FLASHPOINT1METHODUSED
,      FLASHPOINT1TEMPUNIT
,      FLASHPOINT1
,      FLASHPOINT2
,      BOILINGPOINT1TEMPERATUREUNIT
,      BOILINGPOINT2
,      BOILINGPOINT1
,      COLOR
,      EVAPORATIONRATE1QUALIFER
,      EVAPORATIONRATE1
,      FREEZINGPOINT1
,      FREEZINGPOINT1UNIT
,      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
,      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_PHYSICAL_PROPERTY_XML;

Dependencies

[top of page]

APPS.GR_PHYSICAL_PROPERTY_XML references the following:

APPS: GR_INV_ITEM_PROPERTIES; GR_PROPERTIES_B; GR_PROPERTY_VALUES_TL; GR_XML_PROPERTIES_MAP

APPS.GR_PHYSICAL_PROPERTY_XML is referenced by following:

APPS: GR_ITEMS_XML