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.JAI_CMN_MTAX_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 337: FROM po_requisition_headers_all

333: WHERE header_id = p_header_id AND line_number = p_line_no;
334:
335: CURSOR c_requisition_header( p_document_type IN VARCHAR2, p_requisition_no IN VARCHAR2, p_org_id IN NUMBER) IS
336: SELECT requisition_header_id
337: FROM po_requisition_headers_all
338: WHERE segment1 = p_requisition_no
339: AND type_lookup_code = p_document_type
340: AND (p_org_id IS NULL OR org_id = p_org_id);
341:

Line 637: FROM po_requisition_headers_all prha, po_requisition_lines_all prla, JAI_PO_REQ_LINES jirl

633: prla.suggested_vendor_name, prla.suggested_vendor_location,
634: prla.destination_organization_id, prla.deliver_to_location_id, prla.source_organization_id,
635: prla.source_type_code, -- this tells whether source is VENDOR or INVENTORY. If vendor then suggested vendor will be there
636: prha.segment1 document_no, prla.line_num
637: FROM po_requisition_headers_all prha, po_requisition_lines_all prla, JAI_PO_REQ_LINES jirl
638: WHERE prha.requisition_header_id = prla.requisition_header_id
639: AND prla.requisition_line_id = jirl.requisition_line_id
640: AND ((p_document_no is null) OR (p_document_no is not null and prha.segment1 = p_document_no ))
641: AND prha.type_lookup_code = p_document_type