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_RCV_TAX_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 1148: .modified the main SQL's to fetch taxes from various sources to use jai_regime_tax_types_v to fetch regime_code

1144: 36 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.12
1145: .Implemented VAT Tax Calculation based on VAT Assessable value by making a call to jai_general_pkg.ja_in_vat_assessable_value
1146: .JAI_RCV_LINE_TAXES.modvat_flag is set to proper value for VAT Taxes based on RECOVERABLE item attribute
1147: of item. If item setup is not done, then Default value is taken as "Y" (meaning, tax is recoverable)
1148: .modified the main SQL's to fetch taxes from various sources to use jai_regime_tax_types_v to fetch regime_code
1149: against each tax so that the information can be used for MODVAT_FLAG setting of tax
1150: .RTV will raise an exception incase recoverable VAT exists in the receipt line and it is neither Claimed or
1151: Unclaimed
1152:

Line 1850: , jai_regime_tax_types_v tax_types

1846: tax_types.regime_code regime_code
1847: --3848133
1848: FROM JAI_OM_OE_RMA_TAXES rtl,
1849: JAI_CMN_TAXES_ALL jtc
1850: , jai_regime_tax_types_v tax_types
1851: WHERE rtl.rma_line_id = p_oe_order_line_id
1852: AND jtc.tax_id = rtl.tax_id
1853: AND tax_types.tax_type(+) = jtc.tax_type
1854: )

Line 2092: , jai_regime_tax_types_v tax_types

2088: llt.precedence_9,
2089: llt.precedence_10
2090: FROM JAI_PO_TAXES llt,
2091: JAI_CMN_TAXES_ALL jtc
2092: , jai_regime_tax_types_v tax_types
2093: WHERE line_location_id = p_line_location_id
2094: AND jtc.tax_id = llt.tax_id
2095: AND jtc.tax_type = tax_types.tax_type (+)
2096: order by tax_line_no;

Line 2148: jai_regime_tax_types_v tax_types

2144: llt.precedence_10
2145: FROM jai_cmn_document_taxes llt,
2146: jai_cmn_lines cml,
2147: JAI_CMN_TAXES_ALL jtc ,
2148: jai_regime_tax_types_v tax_types
2149: WHERE cml.po_line_location_id = p_line_location_id
2150: AND cml.cmn_line_id = llt.source_doc_line_id
2151: AND cml.shipment_number = lv_shipment_num
2152: AND llt.source_doc_type = 'ASBN'

Line 2218: jai_regime_tax_types_v tax_types,

2214: llt.precedence_9,
2215: llt.precedence_10
2216: FROM jai_cmn_document_taxes llt,
2217: JAI_CMN_TAXES_ALL jtc ,
2218: jai_regime_tax_types_v tax_types,
2219: mtl_material_transactions mtl
2220: WHERE llt.source_doc_line_id = mtl.original_transaction_temp_id
2221: AND llt.source_doc_type = 'INTERORG_XFER'
2222: AND jtc.tax_id = llt.tax_id

Line 3154: jai_regime_tax_types_v tax_types

3150: tax_types.regime_code regime_code
3151: --3848133
3152: FROM JAI_OM_WSH_LINE_TAXES stl,
3153: JAI_CMN_TAXES_ALL jtc,
3154: jai_regime_tax_types_v tax_types
3155: WHERE delivery_detail_id = v_picking_line_id --added by GSri and Jagdish on 5-may-01
3156: AND jtc.tax_id = stl.tax_id
3157: AND tax_types.tax_type(+) = jtc.tax_type
3158: )

Line 3347: FROM JAI_RCV_LINE_TAXES jrtl, JAI_CMN_TAXES_ALL jtc, jai_regime_tax_types_v tax_types

3343: RTV creation should have taken care of this check
3344: Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG */
3345: FOR exc_rec IN (SELECT jrtl.tax_amount, jrtl.tax_type tax_type, nvl(mod_cr_percentage, 0) mod_cr_percentage
3346: , nvl(tax_types.regime_code, 'XXXX') regime_code
3347: FROM JAI_RCV_LINE_TAXES jrtl, JAI_CMN_TAXES_ALL jtc, jai_regime_tax_types_v tax_types
3348: WHERE shipment_line_id = p_shipment_line_id
3349: AND NVL(modvat_flag, 'N') = 'Y'
3350: AND jtc.tax_type = tax_types.tax_type(+)
3351: AND jrtl.tax_id = jtc.tax_id)