DBA Data[Home] [Help]

APPS.JAI_CREDIT_CHECK_PKG dependencies on JAI_CMN_MATCH_TAXES

Line 727: FROM JAI_CMN_MATCH_TAXES jcm

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
729: AND nvl(jcm.Subinventory,'###') = nvl(pv_subinventory,'###')
730: AND jcm.receipt_id = pn_receipt_id
731: AND jcm.Tax_Line_No = jos.Tax_Line_No

Line 736: FROM JAI_CMN_MATCH_TAXES jcm

732: )
733: WHERE jos.line_id = pn_so_line_id
734: AND exists(
735: SELECT jcm.tax_amount,jcm.Base_Tax_Amount,jcm.Func_Tax_Amount
736: FROM JAI_CMN_MATCH_TAXES jcm
737: WHERE jcm.Ref_Line_Id = pn_ref_line_id
738: AND nvl(jcm.Subinventory,'###') = nvl(pv_subinventory,'###')
739: AND jcm.receipt_id = pn_receipt_id
740: AND jcm.Tax_Line_No = jos.Tax_Line_No