APPS.JAI_CREDIT_CHECK_PKG dependencies on JAI_OM_OE_SO_LINES

Line 291: JAI_OM_OE_SO_LINES JL

287: ,OL.LINE_CATEGORY_CODE LINE_CATEGORY_CODE
288: ,JL.LINE_NUMBER LINE_NUMBER
289: ,NVL(OL.TAX_VALUE,0) TAX_VALUE
290: FROM OE_ORDER_LINES OL,
291: JAI_OM_OE_SO_LINES JL
292: WHERE OL.HEADER_ID = pn_header_id
293: AND OL.HEADER_ID = JL.HEADER_ID
294: AND OL.LINE_ID = JL.LINE_ID
295: AND OL.FLOW_STATUS_CODE not in ('CANCELLED','SHIPPED','FULFILLED','CLOSED')

Line 749: Update JAI_OM_OE_SO_LINES

745: FETCH c_tax_amount INTO ln_exclusive_tax;
746: CLOSE c_tax_amount;
747:
748: -- update exclusive tax by line id
749: Update JAI_OM_OE_SO_LINES
750: Set tax_amount = ln_exclusive_tax
751: Where line_id = pn_so_line_id;
752:
753: ELSIF ln_count > 1 THEN