QAS_RELATED_RECORDS_OPER

Use this service operation to return a list of related records for all the fields in the requested record.

Request Message: QAS_RELATED_RECORDS_REQ_MSG

Element Name	Description
RECORD_NAME Required element	Complete record name. Required.

Example Request :

This request will return a list of all the related records for QE_EMPLOYEE.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:qas="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_RELATED_RECORDS_REQ_MSG.VERSION_1">
   <soapenv:Header/>
   <soapenv:Body>
      <qas:QAS_RELATED_RECORDS_REQ_MSG>
         <RECORD_NAME>QE_EMPLOYEE</RECORD_NAME>
      </qas:QAS_RELATED_RECORDS_REQ_MSG>
   </soapenv:Body>
</soapenv:Envelope>

Response Message: QAS_RELATED_RECORDS_RESP_MSG

Element Name	Description
FIELD_NAME	Field for which a related record exists.
RELATED_RECORD_NAME	Record name.
RELATED_RECORD_DESCRIPTION	Record description.
INFORMATION_MESSAGE	Returns information about the request. For example if the criterion in the request is incorrect or if no records meet the criteria, a message indicating the error is returned.

Example Response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <qcs:QAS_RELATED_RECORDS_RESP_MSG xmlns:qcs=
       "http://xmlns.oracle.com/Enterprise/Tools/schemas/
        QAS_RELATED_RECORDS_RESP_MSG.VERSION_1">
         <FIELD>
            <FIELD_NAME>QE_JOBCODE</FIELD_NAME>
            <RELATED_RECORD_NAME>QE_JOBCODE_TBL</RELATED_RECORD_NAME>
            <RELATED_RECORD_DESCRIPTION>JobCode Table</RELATED_RECORD_DESCRIPTION>
         </FIELD>
         <FIELD>
            <FIELD_NAME>DEPTID</FIELD_NAME>
            <RELATED_RECORD_NAME>QE_DEPT_TBL</RELATED_RECORD_NAME>
            <RELATED_RECORD_DESCRIPTION>
                QE Data Department Table
             </RELATED_RECORD_DESCRIPTION>
         </FIELD>
      </qcs:QAS_RELATED_RECORDS_RESP_MSG>
   </soapenv:Body>
</soapenv:Envelope>