DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_PO_REQ_LINES

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

Line 2873: UPDATE JAI_PO_REQ_LINES

2869: p_po_curr => reqn_rec.currency_code,
2870: p_func_curr => v_func_curr
2871: );
2872:
2873: UPDATE JAI_PO_REQ_LINES
2874: SET tax_category_id = v_dflt_tax_category_id
2875: WHERE rowid = reqn_rec.rowid;
2876: -- WHERE requisition_line_id = reqn_rec.requisition_line_id;
2877: