DBA Data[Home] [Help]

APPS.JAI_CREDIT_CHECK_PKG dependencies on JAI_OM_OE_RMA_TAXES

Line 140: ,JAI_OM_OE_RMA_TAXES TAX

136: SELECT LINE.LINE_ID LINE_ID
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

Line 201: JAI_OM_OE_RMA_TAXES TAX,

197: UNION ALL
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

Line 534: ,JAI_OM_OE_RMA_TAXES TAX

530: ,TAX.TAX_AMOUNT TAX_AMOUNT
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