Sunday, February 3, 2019

Main Page XML

<?xml version = '1.0' encoding = 'UTF-8'?>
<page xmlns:jrad="http://xmlns.oracle.com/jrad" xmlns:oa="http://xmlns.oracle.com/oa" xmlns:ui="http://xmlns.oracle.com/uix/ui" version="10.1.3_1312" xml:lang="en-US" xmlns:user="http://xmlns.oracle.com/jrad/user" xmlns="http://xmlns.oracle.com/jrad" file-version="$Header$">
   <content>
      <oa:pageLayout id="PageLayoutRN" amDefName="xxfin.oracle.apps.pos.deptreqsumm.server.xxdeptreqsummAM" windowTitle="Payment Batch Details" title="Payment Batch Details" controllerClass="xxfin.oracle.apps.pos.deptreqsumm.webui.xxdeptreqsummCO">
         <ui:corporateBranding>
            <oa:image id="corporateBrandingImage" source="/OA_MEDIA/FNDSSCORP.gif"/>
         </ui:corporateBranding>
         <ui:contents>
            <oa:rowLayout id="RowLayoutRN" width="50%">
               <ui:contents>
                  <oa:spacer id="item1" width="260"/>
                  <oa:messageLovInput id="PaymentBatchParam" prompt="Payment Batch" queryable="true" sortState="ascending" externalListOfValues="/xxfin/oracle/apps/pos/deptreqsumm/lov/webui/xxpaymentbatchlovRN" selectiveSearchCriteria="true" columns="30" required="yes">
                     <lovMappings>
                        <lovMap id="lovMap1" lovItem="CheckrunName" resultTo="PaymentBatchParam" criteriaFrom="PaymentBatchParam"/>
                        <lovMap id="lovMap2" lovItem="CheckrunId" resultTo="PaymentBatchId" criteriaFrom="PaymentBatchId"/>
                     </lovMappings>
                  </oa:messageLovInput>
                  <oa:submitButton id="SearchButton" text="Search" prompt="Search"/>
               </ui:contents>
            </oa:rowLayout>
            <oa:rowLayout id="region1">
               <ui:contents>
                  <oa:spacer id="item134" width="260"/>
                  <oa:tip id="item133" text="Plese provide the value for Input Parameter Payment Batch" comment="Plese provide the value for Input Parameter Payment Batch"/>
               </ui:contents>
            </oa:rowLayout>
            <oa:spacer id="Spacer" height="10" width="100"/>
            <oa:hideShowHeader id="SuppSummRN" text="Supplier Summary" disclosed="true">
               <ui:contents>
                  <oa:advancedTable id="xxsuppsummVO" viewName="xxsuppsummVO" width="75%" tableBanding="rowBanding" bandingInterval="1">
                     <ui:contents>
                        <oa:column id="SupplierNameCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="SupplierNameHdr" prompt="Supplier Name" sortState="yes"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="SupplierName" viewAttr="SupplierName"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="SupplierNumberCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="SupplierNumberHdr" prompt="Supplier Number" sortState="yes"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="SupplierNumber" viewAttr="SupplierNumber"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="TotalPaymentsCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="TotalPaymentsHdr" prompt="Total Payment" sortState="yes"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="TotalPayments" viewAttr="TotalPayments" dataType="NUMBER"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="NoOfPaymentsCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="NoOfPaymentsHdr" prompt="No.of Payments" sortState="yes"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="NoOfPayments" viewAttr="NoOfPayments"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="NoOfInvoicesCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="NoOfInvoicesHdr" prompt="No.of Invoices" sortState="yes"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="NoOfInvoices" viewAttr="NoOfInvoices"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="NoOfPosCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="NoOfPosHdr" prompt="No.of POs" sortState="yes"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="NoOfPos" viewAttr="NoOfPos"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="NoOfPrsCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="NoOfPrsHdr" prompt="No.of PRs" sortState="yes"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="NoOfPrs" viewAttr="NoOfPrs"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PaymentBatchCol" rendered="false">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PaymentBatchHdr" rendered="false"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageTextInput id="PaymentBatch" viewAttr="PaymentBatch" rendered="false"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PaymentBatchIdCol" rendered="false">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PaymentBatchIdHdr" rendered="false"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageTextInput id="PaymentBatchId" viewAttr="PaymentBatchId" rendered="false"/>
                           </ui:contents>
                        </oa:column>
                     </ui:contents>
                     <ui:tableSelection>
                        <oa:singleSelection id="SuppSingleSelection" serverUnvalidated="true" viewAttr="SuppSelectFlag">
                           <ui:primaryClientAction>
                              <ui:firePartialAction event="supplierSelect"/>
                           </ui:primaryClientAction>
                        </oa:singleSelection>
                     </ui:tableSelection>
                  </oa:advancedTable>
               </ui:contents>
            </oa:hideShowHeader>
            <oa:hideShowHeader id="SuppPaymentsRN" text="Payments" disclosed="true">
               <ui:contents>
                  <oa:advancedTable id="xxsupppaymentsVO" viewName="xxsupppaymentsVO" width="100%" tableBanding="rowBanding" bandingInterval="1">
                     <ui:contents>
                        <oa:column id="PaymentReferenceCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PaymentReferenceHdr" prompt="Payment Reference"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PaymentReference" viewAttr="PaymentReference" prompt="Payment Reference"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PaymentDateCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PaymentDateHdr" prompt="Payment Date"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PaymentDate" viewAttr="PaymentDate" dataType="DATE"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="GlDateCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="GlDateHdr" prompt="GL Date"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="GlDate" viewAttr="GlDate" dataType="DATE"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PaymentAmountCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PaymentAmountHdr" prompt="Payment Amount"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PaymentAmount" viewAttr="PaymentAmount" dataType="NUMBER"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PaymentCurrencyCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PaymentCurrencyHdr" prompt="Payment Currency"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PaymentCurrency" viewAttr="PaymentCurrency"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="BankAccountCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="BankAccountHdr" prompt="Bank Account"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="BankAccount" viewAttr="BankAccount"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="AccountCurrencyCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="AccountCurrencyHdr" prompt="Account Currency"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="AccountCurrency" viewAttr="AccountCurrency"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="ExchangeRateCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="ExchangeRateHdr" prompt="Exchange Rate"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="ExchangeRate" viewAttr="ExchangeRate"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="RemitToAccountCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="RemitToAccountHdr" prompt="Remit To Account"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="RemitToAccount" viewAttr="RemitToAccount"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PaymentAttachment" columnDataFormat="objectNameFormat">
                           <ui:columnHeader>
                              <oa:sortableHeader id="sortableHeader211" prompt="Payment Attachments"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:attachmentImage id="PayAtt" searchRegionRendered="false" prompt="Attachments">
                                 <oa:entityMappings>
                                    <oa:entityMap id="entityMap111" insertAllowed="false" updateAllowed="false" deleteAllowed="false" entityId="AP_CHECKS" showAll="true">
                                       <oa:primaryKeys>
                                          <oa:primaryKey id="primaryKey111" viewAttr="CheckId"/>
                                       </oa:primaryKeys>
                                       <oa:categoryMappings>
                                          <oa:categoryMap id="categoryMap111" categoryName="Payables"/>
                                          <oa:categoryMap id="categoryMap211" categoryName="Buyer"/>
                                          <oa:categoryMap id="categoryMap601" categoryName="Approver"/>
                                          <oa:categoryMap id="categoryMap602" categoryName="REQ Internal"/>
                                          <oa:categoryMap id="categoryMap603" categoryName="RFQ Internal"/>
                                          <oa:categoryMap id="categoryMap604" categoryName="FromSupplier"/>
                                          <oa:categoryMap id="categoryMap605" categoryName="Vendor"/>
                                          <oa:categoryMap id="categoryMap606" categoryName="Quote Internal"/>
                                          <oa:categoryMap id="categoryMap607" categoryName="Receiver"/>
                                          <oa:categoryMap id="categoryMap608" categoryName="Item Internal"/>
                                       </oa:categoryMappings>
                                    </oa:entityMap>
                                 </oa:entityMappings>
                              </oa:attachmentImage>
                           </ui:contents>
                        </oa:column>
                     </ui:contents>
                     <ui:tableSelection>
                        <oa:singleSelection id="PaySingleSelection" viewAttr="PaySelectFlag">
                           <ui:primaryClientAction>
                              <ui:firePartialAction event="paymentSelect"/>
                           </ui:primaryClientAction>
                        </oa:singleSelection>
                     </ui:tableSelection>
                  </oa:advancedTable>
               </ui:contents>
            </oa:hideShowHeader>
            <oa:hideShowHeader id="SuppInvoicesRN" text="Invoices" disclosed="true">
               <ui:contents>
                  <oa:advancedTable id="xxsuppinvVO" viewName="xxsupplierinvoicesVO" width="100%" tableBanding="rowBanding">
                     <ui:contents>
                        <oa:column id="InvoiceNoCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="InvoiceNoHdr" prompt="Invoice No"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="InvoiceNo" viewAttr="InvoiceNo"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="InvoiceDateCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="InvoiceDateHdr" prompt="Invoice Date"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="InvoiceDate" viewAttr="InvoiceDate"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="InvGlDateCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="InvGlDateHdr" prompt="GL Date"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="InvGlDate" viewAttr="GlDate"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="InvoiceCurrencyCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="InvoiceCurrencyHdr" prompt="Invoice Currency"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="InvoiceCurrency" viewAttr="InvoiceCurrency"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="InvoiceAmountCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="InvoiceAmountHdr" prompt="Invoice Amount"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="InvoiceAmount" viewAttr="InvoiceAmount"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="TaxAmountCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="TaxAmountHdr" prompt="Tax Amount"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="TaxAmount" viewAttr="TaxAmount"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="TotalInvoiceAmountCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="TotalInvoiceAmountHdr" prompt="Invoice Total Amount"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="TotalInvoiceAmount" viewAttr="TotalInvoiceAmount"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="InvNoOfPosCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="InvNoOfPosHdr" prompt="No.of Pos"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="InvNoOfPos" viewAttr="NoOfPos"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="InvAttachments" columnDataFormat="objectNameFormat">
                           <ui:columnHeader>
                              <oa:sortableHeader id="sortableHeader21" prompt="Invoice Attachments"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:attachmentImage id="InvAtt" searchRegionRendered="false" prompt="Attachments1">
                                 <oa:entityMappings>
                                    <oa:entityMap id="entityMap11" insertAllowed="false" updateAllowed="false" deleteAllowed="false" entityId="AP_INVOICES" showAll="true">
                                       <oa:primaryKeys>
                                          <oa:primaryKey id="primaryKey11" viewAttr="InvoiceId"/>
                                       </oa:primaryKeys>
                                       <oa:categoryMappings>
                                          <oa:categoryMap id="categoryMap11" categoryName="FromSupplier"/>
                                          <oa:categoryMap id="categoryMap21" categoryName="MISC"/>
                                          <oa:categoryMap id="categoryMap60" categoryName="Payables"/>
                                       </oa:categoryMappings>
                                    </oa:entityMap>
                                 </oa:entityMappings>
                              </oa:attachmentImage>
                           </ui:contents>
                        </oa:column>
                     </ui:contents>
                     <ui:tableSelection>
                        <oa:singleSelection id="InvSingleSelection" viewAttr="InvSelectFlag">
                           <ui:primaryClientAction>
                              <ui:firePartialAction event="invoiceSelect"/>
                           </ui:primaryClientAction>
                        </oa:singleSelection>
                     </ui:tableSelection>
                  </oa:advancedTable>
               </ui:contents>
            </oa:hideShowHeader>
            <oa:hideShowHeader id="SuppInvPosRN" text="Purchase Orders" disclosed="true">
               <ui:contents>
                  <oa:advancedTable id="xxsuppinvposVO" width="100%" viewName="xxsuppinvposVO" tableBanding="rowBanding">
                     <ui:contents>
                        <oa:column id="PonumCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PonumHdr" prompt="PONum"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="Ponum" viewAttr="Ponum"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PoDateCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PoDateHdr" prompt="PO Date"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PoDate" dataType="DATE" viewAttr="PoDate"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PoCurrencyCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PoCurrencyHdr" prompt="PO Currency"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PoCurrency" viewAttr="PoCurrency"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PoTotalCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PoTotalHdr" prompt="PO Total"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PoTotal" viewAttr="PoTotal"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PoLineNumCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PoLineNumHdr" prompt="PO Line Num"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PoLineNum" viewAttr="PoLineNum"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="ItemDescriptionCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="sortableHeader1" prompt="Item Description"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="ItemDescription" viewAttr="ItemDescription"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="QtyCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="QtyHdr" prompt="Qty"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="Qty" viewAttr="Qty"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PriceCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PriceHdr" prompt="Price"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="Price" viewAttr="Price"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="LineAmoountCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="LineAmoountHdr" prompt="Line Amoount"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="LineAmoount" viewAttr="LineAmoount"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="POAttachments" columnDataFormat="objectNameFormat">
                           <ui:columnHeader>
                              <oa:sortableHeader id="sortableHeader2" prompt="PO Attachments"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:attachmentImage id="POAtt" searchRegionRendered="false">
                                 <oa:entityMappings>
                                    <oa:entityMap id="entityMap1" insertAllowed="false" updateAllowed="false" deleteAllowed="false" entityId="PO_HEADERS" showAll="true">
                                       <oa:primaryKeys>
                                          <oa:primaryKey id="primaryKey1" viewAttr="PoHeaderId"/>
                                       </oa:primaryKeys>
                                       <oa:categoryMappings>
                                          <oa:categoryMap id="categoryMap1" categoryName="Vendor"/>
                                          <oa:categoryMap id="categoryMap2" categoryName="Approver"/>
                                          <oa:categoryMap id="categoryMap5" categoryName="Buyer"/>
                                       </oa:categoryMappings>
                                    </oa:entityMap>
                                 </oa:entityMappings>
                              </oa:attachmentImage>
                           </ui:contents>
                        </oa:column>
                     </ui:contents>
                     <ui:tableSelection>
                        <oa:singleSelection id="PoSingleSelection" viewAttr="PoSelectFlag">
                           <ui:primaryClientAction>
                              <ui:firePartialAction event="poSelect">
                                 <ui:parameters>
                                    <ui:parameter key="tes1" value="${oa.xxsuppsummVO.SupplierId}"/>
                                 </ui:parameters>
                              </ui:firePartialAction>
                           </ui:primaryClientAction>
                        </oa:singleSelection>
                     </ui:tableSelection>
                  </oa:advancedTable>
               </ui:contents>
            </oa:hideShowHeader>
            <oa:hideShowHeader id="SuppInvPoPrsRN" text="Purchase Requisitions" disclosed="true">
               <ui:contents>
                  <oa:advancedTable id="xxsuppinvpoprsVO" width="100%" viewName="xxsuppinvpoprVO" tableBanding="rowBanding">
                     <ui:contents>
                        <oa:column id="PrNumberCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PrNumberHdr" prompt="PR Number"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PrNumber" viewAttr="PrNumber"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PrDateCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="PrDateHdr" prompt="PR Date"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="PrDate" viewAttr="PrDate" dataType="DATE"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="RequesterCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="RequesterHdr" prompt="Requester"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="Requester" viewAttr="Requester"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="BuyerCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="BuyerHdr" prompt="Buyer"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="Buyer" viewAttr="Buyer"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="JfNumberCol">
                           <ui:columnHeader>
                              <oa:sortableHeader id="JfNumberHdr" prompt="JF Number"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:messageStyledText id="JfNumber" viewAttr="JfNumber"/>
                           </ui:contents>
                        </oa:column>
                        <oa:column id="PRAttachment" columnDataFormat="objectNameFormat">
                           <ui:columnHeader>
                              <oa:sortableHeader id="sortableHeader22" prompt="PR Attachments"/>
                           </ui:columnHeader>
                           <ui:contents>
                              <oa:attachmentImage id="PRAtt1" searchRegionRendered="false">
                                 <oa:entityMappings>
                                    <oa:entityMap id="entityMap12" insertAllowed="false" updateAllowed="false" deleteAllowed="false" entityId="REQ_HEADERS" showAll="true">
                                       <oa:primaryKeys>
                                          <oa:primaryKey id="primaryKey12" viewAttr="RequisitionHeaderId"/>
                                       </oa:primaryKeys>
                                       <oa:categoryMappings>
                                          <oa:categoryMap id="categoryMap12" categoryName="Vendor"/>
                                          <oa:categoryMap id="categoryMap22" categoryName="Approver"/>
                                          <oa:categoryMap id="categoryMap51" categoryName="Buyer"/>
                                          <oa:categoryMap id="categoryMap52" categoryName="REQ Internal"/>
                                          <oa:categoryMap id="categoryMap53" categoryName="Quote Internal"/>
                                          <oa:categoryMap id="categoryMap54" categoryName="PO Internal"/>
                                          <oa:categoryMap id="categoryMap55" categoryName="Payables"/>
                                          <oa:categoryMap id="categoryMap56" categoryName="MISC"/>
                                          <oa:categoryMap id="categoryMap57" categoryName="RCV Internal"/>
                                          <oa:categoryMap id="categoryMap58" categoryName="Receiver"/>
                                          <oa:categoryMap id="categoryMap59" categoryName="REQ Internal"/>
                                       </oa:categoryMappings>
                                    </oa:entityMap>
                                 </oa:entityMappings>
                              </oa:attachmentImage>
                           </ui:contents>
                        </oa:column>
                     </ui:contents>
                  </oa:advancedTable>
               </ui:contents>
            </oa:hideShowHeader>
         </ui:contents>
      </oa:pageLayout>
   </content>
</page>

SQL Query to find Customer, Customer Account and Customer Sites Information

/****************************************************************************** *PURPOSE: Query to Customer, Customer Account and Customer...