Name: Miscellaneous Parts
Description: Material Description Label for Miscellaneous Parts
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties:
SQL Query:
select Pcom.CommodityType_LongValue, '[Pressure Rating 1]' As PressureRating,
Mfd.ValveManufacturer_ShortValue, Mfd.ValveModelNumber_ShortValue,
Pcom.GeometricIndustryStandard_ShortValue as GeomIndStandard_ShortValue, Pcom2.Manufacturer_ShortValue,
Pcom.MaterialsGrade_ShortValue,
Mfd.MiscRequisitionClassification_ShortValue as MiscReqClassfn_ShortValue from dbo.JDPipeComponent_CL
Pcom
join dbo.JUAManufacturerData_CL Mfd ON (Pcom.Oid = Mfd.Oid)
join dbo.JDPipeComponent2_CL Pcom2 ON (Pcom.Oid = Pcom2.Oid)
join xmadefrom rmf ON (pcom.oid = rmf.oiddestination)
where rmf.oidorigin = ?
Select ClPco.LONGSTRINGVALUE as CommodityType_LongValue,
'[Pressure Rating 1]' As PressureRating,
ClVMf.SHORTSTRINGVALUE as ValveManufacturer_ShortValue, ClVMN.SHORTSTRINGVALUE as
ValveModelNumber_ShortValue,
ClGIS.SHORTSTRINGVALUE as GeomIndStandard_ShortValue, ClMfd.SHORTSTRINGVALUE As Manufacturer_ShortValue,
ClMGr.SHORTSTRINGVALUE as MaterialsGrade_ShortValue,
ClMRC.SHORTSTRINGVALUE as MiscReqClassfn_ShortValue
from CL_PIPINGCOMMODITYTYPE ClPco
join JDPIPECOMPONENT Pcom on (ClPco.VALUEID = Pcom.COMMODITYTYPE)
join JDPipeComponent2 Pcom2 ON (Pcom.Oid = Pcom2.Oid)
join JUAManufacturerData Mfd ON (Pcom.Oid = Mfd.Oid)
join CL_VALVEMANUFACTURER ClVMf on (ClVMf.VALUEID = Mfd.ValveManufacturer)
join CL_VALVEMODELNUMBER ClVMN on (ClVMN.VALUEID = Mfd.ValveModelNumber)
join CL_GEOMETRICINDUSTRYSTANDARD ClGIS on (ClGIS.VALUEID= pcom.GeometricIndustryStandard)
join CL_MANUFACTURER ClMfd on (ClMfd.VALUEID = Pcom2.Manufacturer)
join CL_MATERIALSGRADE ClMGr on (ClMGr.VALUEID = Pcom.MaterialsGrade)
Left OUTER join CL_MISCREQUISITIONCLASSIFICATI ClMRC on (ClMRC.VALUEID = Mfd.MiscRequisitionClassification)
join xmadefrom rmf ON (pcom.oid = rmf.oiddestination)
where rmf.oidorigin = ?