Here is the structure of two Smart Materials tables that contain PMC/PCD information. You can use it when you are creating SQL code.
m_pds_pcd
pmc_id NUMBER(12) NOT NULL
spec_item_id NUMBER(12) NOT NULL
short_code VARCHAR2(10)
rkl VARCHAR2(16) NOT NULL
commodity_id NUMBER(12) NOT NULL
zydex VARCHAR2(7) NOT NULL
unit VARCHAR2(10)
opt VARCHAR2(10) NOT NULL
dn1_from VARCHAR2(12) NOT NULL
dn1_to VARCHAR2(12) NOT NULL
endprp1 VARCHAR2(4)
rating1 VARCHAR2(6)
sch1 VARCHAR2(8)
ts1 VARCHAR2(4)
dn2_from VARCHAR2(12) NOT NULL
dn2_to VARCHAR2(12) NOT NULL
endprp2 VARCHAR2(4)
rating2 VARCHAR2(6)
sch2 VARCHAR2(8)
ts2 VARCHAR2(4)
model VARCHAR2(6)
geostd VARCHAR2(6)
modif VARCHAR2(5)
matgrd VARCHAR2(4)
max_temp VARCHAR2(6)
fabcat VARCHAR2(4)
weightcode VARCHAR2(3)
endprpgrp1 VARCHAR2(4)
endprpgrp2 VARCHAR2(4)
instrument_no VARCHAR2(20)
standard_note_a VARCHAR2(20)
standard_note_b VARCHAR2(20)
physical_data_id VARCHAR2(20)
pds_sort_code VARCHAR2(20)
ident NUMBER(12) NOT NULL
group_id NUMBER(12) NOT NULL
part_id NUMBER(12) NOT NULL
input_1 VARCHAR2(10) NOT NULL
input_2 VARCHAR2(10) NOT NULL
input_3 VARCHAR2(10)
input_4 VARCHAR2(10)
free1 VARCHAR2(60)
free2 VARCHAR2(60)
free3 VARCHAR2(60)
free4 VARCHAR2(60)
free5 VARCHAR2(60)
free6 VARCHAR2(60)
free7 VARCHAR2(60)
free8 VARCHAR2(60)
free9 VARCHAR2(60)
free10 VARCHAR2(60)
proj_id VARCHAR2(10) NOT NULL
usr_id VARCHAR2(10) NOT NULL
lmod DATE NOT NULL
int_rev NUMBER(6) NOT NULL
m_pds_pmc
pmc_id NUMBER(12) NOT NULL
header_id NUMBER(12) NOT NULL
datum DATE NOT NULL
kind NUMBER NOT NULL
pt VARCHAR2(15)
dn VARCHAR2(15)
branch VARCHAR2(15)
tap VARCHAR2(15)
gasket VARCHAR2(15)
fluid VARCHAR2(15)
wall VARCHAR2(15)
revision NUMBER(2)
mater_of_construction VARCHAR2(20)
corrosion_allowed NUMBER(14,4)
material_description NUMBER(6)
thickness_equotation VARCHAR2(15)
vent_drain_macro VARCHAR2(15)
standard_note_a VARCHAR2(15)
standard_note_b VARCHAR2(15)
bend_deflection_table VARCHAR2(15)
pipe_length_table VARCHAR2(15)
cl148 VARCHAR2(6)
free1 VARCHAR2(15)
free2 VARCHAR2(15)
free3 VARCHAR2(15)
free4 VARCHAR2(15)
free5 VARCHAR2(15)
free6 VARCHAR2(15)
free7 VARCHAR2(15)
free8 VARCHAR2(15)
free9 VARCHAR2(15)
free10 VARCHAR2(15)
proj_id VARCHAR2(10) NOT NULL
usr_id VARCHAR2(10) NOT NULL
lmod DATE NOT NULL
int_rev NUMBER(6) NOT NULL
sp_id NUMBER(12) NOT NULL
shortage VARCHAR2(50)