eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_REQUISITION_LINES_ALL

Line 158: FROM po_requisition_lines_all

154: l_tax_amount number;
155: l_total_amount number;
156: cursor req_total_csr(p_doc_id number) is
157: SELECT nvl(SUM(quantity * unit_price), 0)
158: FROM po_requisition_lines_all
159: WHERE requisition_header_id = p_doc_id
160: AND NVL(cancel_flag,'N') = 'N'
161: AND NVL(modified_by_agent_flag, 'N') = 'N';
162: cursor req_tax_csr(p_doc_id number) is

Line 164: FROM po_requisition_lines_all rl,

160: AND NVL(cancel_flag,'N') = 'N'
161: AND NVL(modified_by_agent_flag, 'N') = 'N';
162: cursor req_tax_csr(p_doc_id number) is
163: SELECT nvl(sum(nonrecoverable_tax), 0)
164: FROM po_requisition_lines_all rl,
165: po_req_distributions_all rd
166: WHERE rl.requisition_header_id = p_doc_id
167: AND rd.requisition_line_id = rl.requisition_line_id
168: AND NVL(rl.cancel_flag,'N') = 'N'