$PBExportHeader$d_cost_center_xref_lookup.srd
$PBExportComments$cm_d7.pbl
release  8 ;
datawindow(units= 0  timer_interval= 0  color= 134217750  processing= 1  HTMLDW=no print.documentname="" print.orientation =  0  print.margin.left =  110  print.margin.right =  110  print.margin.top =  96  print.margin.bottom =  96  print.paper.source =  0  print.paper.size =  0  print.prompt=no print.buttons=no print.preview.buttons=no grid.lines= 0  )
summary(height= 0  color="536870912" )
footer(height= 0  color="536870912" )
detail(height= 4  color="536870912" )
table(column=(type=number updatewhereclause=yes name=level dbname="cost_center_xref.level" )
 column=(type=decimal( 0 ) update=yes updatewhereclause=yes name=cc dbname="cost_center_xref.cost_center_tail" )
 column=(type=char( 40 ) updatewhereclause=yes name=name dbname="cc_name" )
 column=(type=decimal( 0 ) update=yes updatewhereclause=yes key=yes name=link_pk dbname="cost_center_xref.hierarchy_cc_pk" )
 column=(type=decimal( 0 ) update=yes updatewhereclause=yes name=hierarchy_fk dbname="cost_center_xref.cost_center_hierarchy_fk" )
 column=(type=decimal( 0 ) update=yes updatewhereclause=yes name=parent_cc dbname="cost_center_xref.cost_center_head" )
 column=(type=datetime updatewhereclause=yes name=from_date dbname="from_date" )
 column=(type=datetime updatewhereclause=yes name=to_date dbname="to_date" )
 column=(type=char( 1 ) updatewhereclause=yes name=current_b dbname="current_b" initial="Y" )
 column=(type=number updatewhereclause=yes name=itemhandle dbname="itemhandle" )
 retrieve="  SELECT LEVEL,
			COST_CENTER_TAIL, 
			CM_REPORT.GET_DESC('COST_CENTER', COST_CENTER_TAIL, 'L') CC_NAME,
			HIERARCHY_CC_PK,   
         COST_CENTER_HIERARCHY_FK,   
         COST_CENTER_HEAD,
			CM_REPORT.get_eff_date('COST_CENTER', COST_CENTER_TAIL, 'FROM') FROM_DATE,
			CM_REPORT.get_eff_date('COST_CENTER', COST_CENTER_TAIL, 'TO') TO_DATE,
			CM_REPORT.is_cost_center_current(COST_CENTER_TAIL) current_b,
			0 as itemhandle			
    FROM COST_CENTER_XREF
	 WHERE COST_CENTER_HIERARCHY_FK = :ad_hierarchy_pk         
    CONNECT by cost_center_head = prior cost_center_tail AND COST_CENTER_HIERARCHY_FK = prior COST_CENTER_HIERARCHY_FK
    START WITH cost_center_head is null 
" update="COST_CENTER_XREF" updatewhere= 2  updatekeyinplace=yes arguments=(("ad_hierarchy_pk", number)) )
column(band=detail id= 4  alignment="1" tabsequence= 40  border="0" color="33554432" x="2729" y="8" height="76" width="553" format="[general]" html.valueishtml="0"  name=link_pk visible="1" edit.limit= 0  edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode= 3   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id= 5  alignment="1" tabsequence= 30  border="0" color="33554432" x="1792" y="8" height="76" width="928" format="[general]" html.valueishtml="0"  name=hierarchy_fk visible="1" edit.limit= 0  edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode= 0   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id= 6  alignment="1" tabsequence= 10  border="0" color="33554432" x="197" y="8" height="76" width="471" format="[general]" html.valueishtml="0"  name=parent_cc visible="1" edit.limit= 0  edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode= 0   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id= 2  alignment="1" tabsequence= 20  border="0" color="33554432" x="677" y="8" height="76" width="425" format="[general]" html.valueishtml="0"  name=cc visible="1" edit.limit= 0  edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode= 0   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id= 3  alignment="1" tabsequence= 32766  border="0" color="33554432" x="1111" y="8" height="76" width="672" format="[general]" html.valueishtml="0"  name=name visible="1" edit.limit= 0  edit.case=any edit.autoselect=yes edit.imemode= 0   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id= 1  alignment="1" tabsequence= 32766  border="0" color="33554432" x="9" y="8" height="76" width="178" format="[general]" html.valueishtml="0"  name=level visible="1" edit.limit= 0  edit.case=any edit.autoselect=yes edit.imemode= 0   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id= 10  alignment="0" tabsequence= 32766  border="0" color="33554432" x="3291" y="12" height="64" width="1152" format="[general]" html.valueishtml="0"  name=itemhandle visible="1" edit.limit= 0  edit.case=any edit.autoselect=yes edit.imemode= 0   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id= 7  alignment="0" tabsequence= 32766  border="0" color="33554432" x="4453" y="12" height="64" width="293" format="[shortdate] [time]" html.valueishtml="0"  name=from_date visible="1" edit.limit= 0  edit.case=any edit.autoselect=yes edit.imemode= 0   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id= 8  alignment="0" tabsequence= 32766  border="0" color="33554432" x="4754" y="12" height="64" width="279" format="[shortdate] [time]" html.valueishtml="0"  name=to_date visible="1" edit.limit= 0  edit.case=any edit.autoselect=yes edit.imemode= 0   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id= 9  alignment="0" tabsequence= 32766  border="0" color="33554432" x="5042" y="16" height="64" width="297" format="[general]" html.valueishtml="0"  name=current_b visible="1" edit.limit= 0  edit.case=any edit.autoselect=yes edit.imemode= 0   font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" netscapelayers="0" )