The Requisition Cross References report can be used to view the cross references between a requisition and the inquiries and agreements that were created based on this requisition.
-
This is an interactive report.
-
Click and select the column where you want to search, type the search criterion in the Search box, and click Go to apply the search.
-
To change the number of displayed rows, select a value from the Rows list.
-
Additionally, you can customize the report to meet your requirements, save the report, and download the result in csv or html format (see Use Actions menu).
Click a requisition number to open the Requisitions page, where the line items of the selected requisition appear. For more information, see Requisitions.
On the Requisitions page, always the highest supplement (revision) of the inquiry or purchase requisition is displayed.
Click the icon in the Show Details column to view the reference data of the selected requisition at the bottom of the page. The associated agreements and inquiries appear.
You can click an agreement number to open the PO Headers and Line Items page, where the line items of the selected agreement appear. For more information, see Agreements and Line Items.
Data Sources
The table below shows the Smart Materials screen(s) where the data is entered that is displayed in this report. Additionally, this table shows the synchronization table and the CIPs used by the report, and the name of the log file created by the sync job or the report.
Screen |
R.30.01 Maintain Requisitions P.30.11 Inquiries P.50.07 Maintain Agreements |
Table |
n/a (no synchronization, direct query) |
CIP |
n/a (no CIP) |
Log File |
n/a |
The following table shows all values displayed in the report, with the related Smart Materials screen and field where the value is displayed, the database table and column where the value is stored, and CIPs, functions, or procedures that are used to retrieve the value. Optionally, additional comment on the value is entered in the last column.
Value |
Screen |
Field |
Database Column |
Other Source/Comment |
---|---|---|---|---|
Project |
R.30.11 |
m_reqs.proj_id |
||
Engineering Requisition |
R.30.11 |
Engineering Requisition |
m_reqs.r_code |
|
Suppl |
R.30.11 |
Suppl |
m_reqs.r_supp |
|
Origin |
R.30.11 |
Origin |
m_reqs.origin_id |
|
Status |
R.30.11 |
Status |
m_reqs.rst_id (-> m_req_status.rst_code) |
|
SR Rev |
R.30.11 |
SR Rev |
m_reqs.sr_revision |
|
MR Rev |
R.30.11 |
MR Rev |
m_reqs.mr_revision |
|
Release Context |
R.30.11 |
Release Context |
m_reqs.release_context |
|
Approved By |
R.30.11 |
Approved By |
m_reqs.approved_by |
|
Approval Date |
R.30.11 |
Approved Date |
m_reqs.approved_date |
|
Released Line Items |
R.30.11 |
Released LI |
count of m_req_line_items where release_ind is Y |
|
Negative Qty Line Items |
R.30.11 |
LI with neg Qty |
count of m_req_line_items where (rli.total_release_qty - rli.last_total_release_qty) < 0 |
|
Changed Attachments |
R.30.11 |
Changed Attachments |
bir_p70.get_changed_attachements |
|
Agreement Number |
R.30.11 |
Agreement Number |
m_po_headers.po_number |
|
Order Type |
R.30.11 |
Type |
m_po_headers.order_type |
|
Suppl |
R.30.11 |
Suppl |
m_po_headers.po_supp |
|
Origin |
R.30.11 |
Origin |
m_po_headers.origin_id (-> m_origins.origin_code) |
|
Inquiry Number |
R.30.11 |
Inquiry Number |
m_inquiries.inq_code |
|
Suppl |
R.30.11 |
Suppl |
m_inquiries.i_supp |
|
Purchase |
R.30.11 |
Purchase |
m_inquiries.actual_ind |
|
Buyer |
R.30.11 |
Buyer |
m_inquiries.po_buyer |
|
Created On |
R.30.11 |
Created On |
m_inquiries.inquiry_created_date |