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 966: JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the table JAI_OM_OE_SO_TAXES

962:
963: Bug : 3436541
964:
965: Purpose : This function validates the different valid combination of values that can exist between
966: JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the table JAI_OM_OE_SO_TAXES
967:
968: A sales order In India Localization Order Management should be allowed to be shipped only when the
969: following conditions are satisfied: -
970: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like

Line 972: ( table JAI_OM_OE_SO_TAXES)

968: A sales order In India Localization Order Management should be allowed to be shipped only when the
969: following conditions are satisfied: -
970: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
971: 'EXCISE_EXEMPT_CERT', 'CT2','CT3' should not have Modvat Receovery type of taxes attached
972: ( table JAI_OM_OE_SO_TAXES)
973:
974: 2. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
975: 'EXCISE_EXEMPT_CERT_OTH', 'CT2_OTH' should have modvat recovery type of tax attached
976: ( table JAI_OM_OE_SO_TAXES)

Line 976: ( table JAI_OM_OE_SO_TAXES)

972: ( table JAI_OM_OE_SO_TAXES)
973:
974: 2. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
975: 'EXCISE_EXEMPT_CERT_OTH', 'CT2_OTH' should have modvat recovery type of tax attached
976: ( table JAI_OM_OE_SO_TAXES)
977:
978: 3. A sales order which does not have any excise exemptions specified (Null value for field
979: JAI_OM_OE_SO_LINES.excise_exempt_type) should not have any Modvat Recovery type of taxes
980: ( table JAI_OM_OE_SO_TAXES).

Line 980: ( table JAI_OM_OE_SO_TAXES).

976: ( table JAI_OM_OE_SO_TAXES)
977:
978: 3. A sales order which does not have any excise exemptions specified (Null value for field
979: JAI_OM_OE_SO_LINES.excise_exempt_type) should not have any Modvat Recovery type of taxes
980: ( table JAI_OM_OE_SO_TAXES).
981:
982: This function returns an error when any of the above conditions are not satisified.
983:
984: Return Status : Returns 'EE' -> Expected Error

Line 1025: JAI_OM_OE_SO_TAXES tl,

1021: IS
1022: SELECT
1023: '1'
1024: FROM
1025: JAI_OM_OE_SO_TAXES tl,
1026: JAI_CMN_TAXES_ALL tc
1027: WHERE
1028: tc.tax_type = jai_constants.tax_type_modvat_recovery AND /*--'Modvat Recovery' Ramananda for removal of SQL LITERALs :bug#4428980*/
1029: tc.tax_id = tl.tax_id AND