SELECT
a.fieldname,
a.version,
a.fieldtype,
a.length,
a.decimalpos,
a.format,
a.formatlength,
a.image_fmt,
a.formatfamily,
a.dispfmtname,
a.defcntryyr,
a.imemode,
a.kblayout,
a.objectownerid,
to_char(CAST((a.lastupddttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
a.lastupdoprid,
a.fldnotused,
a.auxflagmask,
a.descrlong,
b.recname,
b.fieldname,
b.fieldnum,
b.defrecname,
b.deffieldname,
b.curctlfieldname,
b.edittable,
b.useedit,
b.useedit2,
b.subrecord,
b.subrecver,
b.setcntrlfld,
b.defguicontrol,
b.label_id,
to_char(CAST((b.lastupddttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
b.lastupdoprid,
b.timezoneuse,
b.timezonefieldname,
b.reltmdtfieldname,
b.currctluse,
c.recname,
c.fieldcount,
c.indexcount,
c.ddlcount,
c.version,
c.auditrecname,
c.recuse,
c.rectype,
c.setcntrlfld,
c.rellangrecname,
c.optdelrecname,
c.recdescr,
c.parentrecname,
c.qrysecrecname,
c.sqltablename,
c.buildseqno,
c.opttrigflag,
c.objectownerid,
to_char(CAST((c.lastupddttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
c.lastupdoprid,
c.systemidfieldname,
c.timestampfieldname,
c.auxflagmask,
c.descrlong,
d.pnlname,
d.pnlfldid,
d.fieldnum,
d.pnlfieldname,
d.fieldtype,
d.editsize,
d.dsplformat,
d.fieldleft,
d.fieldtop,
d.fieldright,
d.fieldbottom,
d.editlblleft,
d.editlbltop,
d.editlblright,
d.editlblbottom,
d.dsplfill,
d.lbltype,
d.lblloc,
d.lblpadsize,
d.usedefaultlabel,
d.label_id,
d.lbltext,
d.fielduse,
d.fieldusetmp,
d.deferproc,
d.occurslevel,
d.recname,
d.fieldname,
d.onvalue,
d.offvalue,
d.assocfieldnum,
d.occurscount1,
d.occursoffset1,
d.occurscount2,
d.occursoffset2,
d.occurscount3,
d.occursoffset3,
d.subpnlname,
d.subpnlver,
d.fieldstyle,
d.labelstyle,
d.fieldsizetype,
d.labelsizetype,
d.prcstype,
d.prcsname,
d.promptfield,
d.formatfamily,
d.dispfmtname,
d.popupmenu,
d.treectrlid,
d.treectrltype,
d.multirectree,
d.nodecount,
d.grdcolumncount,
d.grdshowcolhdg,
d.grdshowrowhdg,
d.grdoddrowstyle,
d.grdevenrowstyle,
d.grdactivetabstyle,
d.grdinactivetabstyl,
d.grdnavbarstyle,
d.grdlabelstyle,
d.grdlblmsgset,
d.grdlblmsgnum,
d.grdlblalign,
d.grdacttype,
d.grdallowcolsort,
d.tabenable,
d.pbdisplaytype,
d.opennewwindow,
d.urldynamic,
d.url_id,
d.gotoportalname,
d.gotonodename,
d.gotomenuname,
d.gotopnlgrpname,
d.gotomktname,
d.gotopnlname,
d.gotopnlaction,
d.srchbypnldata,
d.scrollaction,
d.toolaction,
d.contname,
d.contnameover,
d.contnamedisable,
d.ptlblimgcollapse,
d.ptlblimgexpand,
d.ptadjhiddenfields,
d.ptcollapsedataarea,
d.ptdfltviewexpanded,
d.pthidefields,
d.showcolhiderows,
d.ptlebexpandfield,
d.showtabcntlbtn,
d.selindicatortype,
d.secureinvisible,
d.enableasanchor,
d.urlencodedbyapp,
e.pnlname,
e.pnlfldid,
e.fieldnum,
e.pnlfieldname,
e.fieldtype,
e.editsize,
e.dsplformat,
e.fieldleft,
e.fieldtop,
e.fieldright,
e.fieldbottom,
e.editlblleft,
e.editlbltop,
e.editlblright,
e.editlblbottom,
e.dsplfill,
e.lbltype,
e.lblloc,
e.lblpadsize,
e.usedefaultlabel,
e.label_id,
e.lbltext,
e.fielduse,
e.fieldusetmp,
e.deferproc,
e.occurslevel,
e.recname,
e.fieldname,
e.onvalue,
e.offvalue,
e.assocfieldnum,
e.occurscount1,
e.occursoffset1,
e.occurscount2,
e.occursoffset2,
e.occurscount3,
e.occursoffset3,
e.subpnlname,
e.subpnlver,
e.fieldstyle,
e.labelstyle,
e.fieldsizetype,
e.labelsizetype,
e.prcstype,
e.prcsname,
e.promptfield,
e.formatfamily,
e.dispfmtname,
e.popupmenu,
e.treectrlid,
e.treectrltype,
e.multirectree,
e.nodecount,
e.grdcolumncount,
e.grdshowcolhdg,
e.grdshowrowhdg,
e.grdoddrowstyle,
e.grdevenrowstyle,
e.grdactivetabstyle,
e.grdinactivetabstyl,
e.grdnavbarstyle,
e.grdlabelstyle,
e.grdlblmsgset,
e.grdlblmsgnum,
e.grdlblalign,
e.grdacttype,
e.grdallowcolsort,
e.tabenable,
e.pbdisplaytype,
e.opennewwindow,
e.urldynamic,
e.url_id,
e.gotoportalname,
e.gotonodename,
e.gotomenuname,
e.gotopnlgrpname,
e.gotomktname,
e.gotopnlname,
e.gotopnlaction,
e.srchbypnldata,
e.scrollaction,
e.toolaction,
e.contname,
e.contnameover,
e.contnamedisable,
e.ptlblimgcollapse,
e.ptlblimgexpand,
e.ptadjhiddenfields,
e.ptcollapsedataarea,
e.ptdfltviewexpanded,
e.pthidefields,
e.showcolhiderows,
e.ptlebexpandfield,
e.showtabcntlbtn,
e.selindicatortype,
e.secureinvisible,
e.enableasanchor,
e.urlencodedbyapp,
f.pnlname,
f.version,
f.pnltype,
f.fieldcount,
f.maxpnlfldid,
f.gridhorz,
f.gridvert,
f.helpcontextnum,
f.paneltop,
f.panelleft,
f.panelright,
f.panelbottom,
f.pnlstyle,
f.stylesheetname,
f.ffstylesheetname,
f.pnluse,
f.deferproc,
f.descr,
f.popupmenu,
f.license_code,
to_char(CAST((f.lastupddttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
f.lastupdoprid,
f.objectownerid,
f.ffstyledesktop,
f.ffstylephone,
f.ffstyletablet,
f.pnlusetemp,
f.ffstylemedium,
f.ffstyleexlarge,
f.descrlong,
g.pnlname,
g.version,
g.pnltype,
g.fieldcount,
g.maxpnlfldid,
g.gridhorz,
g.gridvert,
g.helpcontextnum,
g.paneltop,
g.panelleft,
g.panelright,
g.panelbottom,
g.pnlstyle,
g.stylesheetname,
g.ffstylesheetname,
g.pnluse,
g.deferproc,
g.descr,
g.popupmenu,
g.license_code,
to_char(CAST((g.lastupddttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
g.lastupdoprid,
g.objectownerid,
g.ffstyledesktop,
g.ffstylephone,
g.ffstyletablet,
g.pnlusetemp,
g.ffstylemedium,
g.ffstyleexlarge,
g.descrlong,
h.pnlgrpname,
h.market,
h.pnlname,
h.subitemnum,
h.itemname,
h.itemlabel,
h.foldertablabel,
h.hidden,
i.pnlgrpname,
i.market,
i.pnlname,
i.subitemnum,
i.itemname,
i.itemlabel,
i.foldertablabel,
i.hidden,
j.pnlgrpname,
j.market,
j.version,
j.actions,
j.descr,
j.addsrchrecname,
j.searchrecname,
j.searchpnlname,
j.loadloc,
j.saveloc,
j.disablesave,
j.objectownerid,
to_char(CAST((j.lastupddttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
j.lastupdoprid,
j.primaryaction,
j.dfltaction,
j.dfltsrchtype,
j.deferproc,
j.expentryproc,
j.reqsecuressl,
j.inclnavigation,
j.forcesearch,
j.allowactmodesel,
j.pnlnavflags,
j.tbarbtns,
j.showtbar,
j.addlinkmsgset,
j.addlinkmsgnum,
j.srchlinkmsgset,
j.srchlinkmsgnum,
j.srchtextmsgset,
j.srchtextmsgnum,
j.wsrpcompliant,
j.fluidmode,
j.layoutmode,
j.incfooter,
j.incside,
j.incheader,
j.incsearch,
j.smallffopt,
j.comp_type,
j.pnlgrpuse,
j.descrlong,
l.menuname,
l.barname,
l.itemname,
l.itemnum,
l.itemtype,
l.pnlgrpname,
l.market,
l.barlabel,
l.itemlabel,
l.xfercount,
l.searchrecname,
m.menuname,
m.barname,
m.itemname,
m.itemnum,
m.itemtype,
m.pnlgrpname,
m.market,
m.barlabel,
m.itemlabel,
m.xfercount,
m.searchrecname,
n.menuname,
n.version,
n.menugroup,
n.installed,
n.grouporder,
n.menuorder,
n.groupsep,
n.menusep,
n.menulabel,
n.menutype,
n.descr,
n.objectownerid,
to_char(CAST((n.lastupddttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
n.lastupdoprid,
n.descrlong,
o.menuname,
o.version,
o.menugroup,
o.installed,
o.grouporder,
o.menuorder,
o.groupsep,
o.menusep,
o.menulabel,
o.menutype,
o.descr,
o.objectownerid,
to_char(CAST((o.lastupddttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
o.lastupdoprid,
o.descrlong,
p.portal_name,
p.portal_reftype,
p.portal_objname,
p.portal_urltext,
q.portal_name,
q.portal_reftype,
q.portal_objname,
q.portal_uri_seg1,
q.portal_uri_seg2,
q.portal_urltext
FROM
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
psdbfield a
LEFT OUTER JOIN psrecfield b ON a.fieldname = b.fieldname
)
LEFT OUTER JOIN psrecdefn c ON b.recname = c.recname
)
LEFT OUTER JOIN pspnlfield d ON b.recname = d.recname AND b.fieldname = d.fieldname
)
LEFT OUTER JOIN pspnldefn f ON d.pnlname = f.pnlname
)
LEFT OUTER JOIN pspnlgroup h ON f.pnlname = h.pnlname
)
LEFT OUTER JOIN pspnlgrpdefn j ON h.pnlgrpnamJt = j.market
)
LEFT OUTER JOIN psmenuitem l ON j.pnlgrpname = l.pnlgrpname AND j.market = l.market
)
LEFT OUTER JOIN psmenudefn n ON l.menuname = n.menuname
)
LEFT OUTER JOIN psprsmdefn p ON p.portal_uri_seg2 = j.pnlgrpname
)
LEFT OUTER JOIN pspnlfield e ON a.fieldname = e.fieldname
)
LEFT OUTER JOIN pspnldefn g ON e.pnlname = g.pnlname
)
LEFT OUTER JOIN pspnlgroup i ON g.pnlname = i.pnlname
)
LEFT OUTER JOIN pspnlgrpdefn k ON i.pnlgrpname = k.pnlgrpname AND i.market = k.market
)
LEFT OUTER JOIN psmenuitem m ON k.pnlgrpname = m.pnlgrpname AND k.market = m.market
)
LEFT OUTER JOIN psmenudefn o ON m.menuname = o.menuname
)
LEFT OUTER JOIN psprsmdefn q ON q.portal_uri_seg2 = k.pnlgrpname
)
No comments:
Post a Comment