APPS.JAI_CMN_MTAX_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 344: FROM po_requisition_lines_all

340: AND (p_org_id IS NULL OR org_id = p_org_id);
341:
342: CURSOR c_requisition_line( p_requisition_header_id IN NUMBER, p_requisition_line_no IN NUMBER) IS
343: SELECT requisition_line_id
344: FROM po_requisition_lines_all
345: WHERE requisition_header_id = p_requisition_header_id AND line_num = p_requisition_line_no;
346:
347: v_document_find_failed CHAR(1); -- := 'N'; --Ramananda for File.Sql.35
348: v_failed CHAR(1); -- := 'N'; --Ramananda for File.Sql.35

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