APPS.JAI_CREDIT_CHECK_PKG dependencies on JAI_OM_OE_SO_TAXES

Line 129: ,JAI_OM_OE_SO_TAXES TAX

125: (SELECT LINE.LINE_ID LINE_ID
126: ,NVL(LINE.TAX_VALUE,0) ORDER_LINE_TAX_VALUE
127: ,TAX.TAX_AMOUNT JAI_TAX_LINE_AMOUNT
128: FROM OE_ORDER_LINES LINE
129: ,JAI_OM_OE_SO_TAXES TAX
130: ,JAI_CMN_TAXES_ALL JCTA
131: WHERE LINE.HEADER_ID = pn_so_order_id
132: AND TAX.LINE_ID = LINE.LINE_ID
133: AND TAX.TAX_ID = JCTA.TAX_ID

Line 190: JAI_OM_OE_SO_TAXES TAX,

186: FROM
187: ( SELECT LINE.LINE_ID,
188: NVL(SUM(TAX.TAX_AMOUNT), 0) TAX_AMOUNT_SUM
189: FROM OE_ORDER_LINES LINE,
190: JAI_OM_OE_SO_TAXES TAX,
191: JAI_CMN_TAXES_ALL JCTA
192: WHERE LINE.LINE_ID = pn_line_id
193: AND TAX.LINE_ID = LINE.LINE_ID
194: AND TAX.TAX_ID = JCTA.TAX_ID

Line 508: ,JAI_OM_OE_SO_TAXES TAX

504: ,TAX.TAX_AMOUNT TAX_AMOUNT
505: ,TAX.TAX_RATE TAX_RATE
506: FROM OE_ORDER_HEADERS HDR
507: ,OE_ORDER_LINES LINE
508: ,JAI_OM_OE_SO_TAXES TAX
509: ,JAI_CMN_TAXES_ALL JCTA
510: WHERE HDR.HEADER_ID = LINE.HEADER_ID
511: AND TAX.LINE_ID = LINE.LINE_ID
512: AND LINE.LINE_ID = cn_line_id

Line 699: FROM JAI_OM_OE_SO_TAXES JOS,

695:
696: -- Cursor used to get exclusive tax amount
697: CURSOR c_tax_amount IS
698: SELECT sum(nvl(JOS.tax_amount,0))
699: FROM JAI_OM_OE_SO_TAXES JOS,
700: JAI_CMN_TAXES_ALL JCT
701: WHERE JOS.line_id = pn_so_line_id
702: AND JOS.tax_id = JCT.tax_id
703: AND NVL(JCT.inclusive_tax_flag,'N') = 'N';

Line 724: UPDATE JAI_OM_OE_SO_TAXES jos

720: AND wdd.CONTAINER_FLAG = 'N'
721: AND wdd.SOURCE_CODE = 'OE'
722: AND wdd.RELEASED_STATUS IN ('N', 'R', 'S', 'Y', 'B', 'X');
723: IF ln_count = 1 THEN
724: UPDATE JAI_OM_OE_SO_TAXES jos
725: SET (jos.tax_amount,jos.Base_Tax_Amount,jos.Func_Tax_Amount) =
726: ( SELECT jcm.tax_amount,jcm.Base_Tax_Amount,jcm.Func_Tax_Amount
727: FROM JAI_CMN_MATCH_TAXES jcm
728: WHERE jcm.Ref_Line_Id = pn_ref_line_id