DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_OM_OE_RMA_TAXES

Line 4280: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

4276: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount, A.tax_amount, b.tax_type,
4277: A.func_tax_amount,
4278: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
4279: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
4280: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
4281: WHERE A.rma_line_id = v_interface_line_attribute7
4282: AND A.tax_id = b.tax_id
4283: and b.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/
4284: ORDER BY tax_line_no;

Line 4302: FROM JAI_OM_OE_RMA_TAXES

4298:
4299:
4300: CURSOR SO_RMA_TAX_RECORD_CHECK IS
4301: SELECT 1
4302: FROM JAI_OM_OE_RMA_TAXES
4303: WHERE rma_line_id = v_interface_line_attribute7;
4304:
4305:
4306: v_trans_type VARCHAR2(30);