APPS.JAI_CREDIT_CHECK_PKG dependencies on JAI_CMN_TAXES_ALL

Line 130: ,JAI_CMN_TAXES_ALL JCTA

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
134: AND NVL(JCTA.INCLUSIVE_TAX_FLAG,'N') = 'N'

Line 141: ,JAI_CMN_TAXES_ALL JCTA

137: ,NVL(LINE.TAX_VALUE,0) ORDER_LINE_TAX_VALUE
138: ,TAX.TAX_AMOUNT JAI_TAX_LINE_AMOUNT
139: FROM OE_ORDER_LINES LINE
140: ,JAI_OM_OE_RMA_TAXES TAX
141: ,JAI_CMN_TAXES_ALL JCTA
142: WHERE LINE.HEADER_ID = pn_so_order_id
143: AND TAX.RMA_LINE_ID = LINE.LINE_ID
144: AND TAX.TAX_ID = JCTA.TAX_ID
145: AND NVL(JCTA.INCLUSIVE_TAX_FLAG,'N') = 'N'

Line 191: JAI_CMN_TAXES_ALL JCTA

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
195: AND NVL(JCTA.INCLUSIVE_TAX_FLAG, 'N') = 'N'

Line 202: JAI_CMN_TAXES_ALL JCTA

198: SELECT LINE.LINE_ID,
199: NVL(SUM(TAX.TAX_AMOUNT), 0) TAX_AMOUNT_SUM
200: FROM OE_ORDER_LINES LINE,
201: JAI_OM_OE_RMA_TAXES TAX,
202: JAI_CMN_TAXES_ALL JCTA
203: WHERE LINE.LINE_ID = pn_line_id
204: AND TAX.RMA_LINE_ID = LINE.LINE_ID
205: AND TAX.TAX_ID = JCTA.TAX_ID
206: AND NVL(JCTA.INCLUSIVE_TAX_FLAG, 'N') = 'N'

Line 509: ,JAI_CMN_TAXES_ALL JCTA

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
513: AND TAX.TAX_ID = JCTA.TAX_ID

Line 535: ,JAI_CMN_TAXES_ALL JCTA

531: ,TAX.TAX_RATE TAX_RATE
532: FROM OE_ORDER_HEADERS HDR
533: ,OE_ORDER_LINES LINE
534: ,JAI_OM_OE_RMA_TAXES TAX
535: ,JAI_CMN_TAXES_ALL JCTA
536: WHERE HDR.HEADER_ID = LINE.HEADER_ID
537: AND TAX.RMA_LINE_ID = LINE.LINE_ID
538: AND LINE.LINE_ID = cn_line_id
539: AND TAX.TAX_ID = JCTA.TAX_ID

Line 700: JAI_CMN_TAXES_ALL JCT

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';
704: