eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OM_UTILS_PKG dependencies on JAI_OM_OE_SO_TAXES

Line 544: JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the table JAI_OM_OE_SO_TAXES

540:
541: Bug : 3436541
542:
543: Purpose : This function validates the different valid combination of values that can exist between
544: JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the table JAI_OM_OE_SO_TAXES
545:
546: A sales order In India Localization Order Management should be allowed to be shipped only when the
547: following conditions are satisfied: -
548: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like

Line 550: ( table JAI_OM_OE_SO_TAXES)

546: A sales order In India Localization Order Management should be allowed to be shipped only when the
547: following conditions are satisfied: -
548: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
549: 'EXCISE_EXEMPT_CERT', 'CT2','CT3' should not have Modvat Receovery type of taxes attached
550: ( table JAI_OM_OE_SO_TAXES)
551:
552: 2. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
553: 'EXCISE_EXEMPT_CERT_OTH', 'CT2_OTH' should have modvat recovery type of tax attached
554: ( table JAI_OM_OE_SO_TAXES)

Line 554: ( table JAI_OM_OE_SO_TAXES)

550: ( table JAI_OM_OE_SO_TAXES)
551:
552: 2. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
553: 'EXCISE_EXEMPT_CERT_OTH', 'CT2_OTH' should have modvat recovery type of tax attached
554: ( table JAI_OM_OE_SO_TAXES)
555:
556: 3. A sales order which does not have any excise exemptions specified (Null value for field
557: JAI_OM_OE_SO_LINES.excise_exempt_type) should not have any Modvat Recovery type of taxes
558: ( table JAI_OM_OE_SO_TAXES).

Line 558: ( table JAI_OM_OE_SO_TAXES).

554: ( table JAI_OM_OE_SO_TAXES)
555:
556: 3. A sales order which does not have any excise exemptions specified (Null value for field
557: JAI_OM_OE_SO_LINES.excise_exempt_type) should not have any Modvat Recovery type of taxes
558: ( table JAI_OM_OE_SO_TAXES).
559:
560: This function returns an error when any of the above conditions are not satisified.
561:
562: Return Status : Returns 'EE' -> Expected Error

Line 603: JAI_OM_OE_SO_TAXES tl,

599: IS
600: SELECT
601: '1'
602: FROM
603: JAI_OM_OE_SO_TAXES tl,
604: JAI_CMN_TAXES_ALL tc
605: WHERE
606: tc.tax_type = jai_constants.tax_type_modvat_recovery AND /*--'Modvat Recovery' Ramananda for removal of SQL LITERALs :bug#4428980*/
607: tc.tax_id = tl.tax_id AND