DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_PO_REQ_LINES

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

770: prla.suggested_vendor_name, prla.suggested_vendor_location,
771: prla.destination_organization_id, prla.deliver_to_location_id, prla.source_organization_id,
772: prla.source_type_code, -- this tells whether source is VENDOR or INVENTORY. If vendor then suggested vendor will be there
773: prha.segment1 document_no, prla.line_num
774: FROM po_requisition_headers_all prha, po_requisition_lines_all prla, JAI_PO_REQ_LINES jirl
775: WHERE prha.requisition_header_id = prla.requisition_header_id
776: AND prla.requisition_line_id = jirl.requisition_line_id
777: AND ((p_document_no is null) OR (p_document_no is not null and prha.segment1 = p_document_no ))
778: AND prha.type_lookup_code = p_document_type

Line 3342: UPDATE JAI_PO_REQ_LINES

3338: p_func_curr => v_func_curr
3339: -- ,pn_gst_assessable_value => ln_gst_assess_value --Added by zhiwei for bug10043656 GST enhancement 2010/09/14
3340: );
3341:
3342: UPDATE JAI_PO_REQ_LINES
3343: SET tax_category_id = v_dflt_tax_category_id
3344: WHERE rowid = reqn_rec.rowid;
3345: -- WHERE requisition_line_id = reqn_rec.requisition_line_id;
3346: