APPS.JAI_RCV_TAX_PKG dependencies on JAI_REGIME_TAX_TYPES_V

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

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

Line 2096: , jai_regime_tax_types_v tax_types

2092: tax_types.regime_code regime_code
2093: --3848133
2094: FROM JAI_OM_OE_RMA_TAXES rtl,
2095: JAI_CMN_TAXES_ALL jtc
2096: , jai_regime_tax_types_v tax_types
2097: WHERE rtl.rma_line_id = p_oe_order_line_id
2098: AND jtc.tax_id = rtl.tax_id
2099: AND tax_types.tax_type(+) = jtc.tax_type
2100: )

Line 2346: , jai_regime_tax_types_v tax_types

2342: llt.precedence_9,
2343: llt.precedence_10
2344: FROM JAI_PO_TAXES llt,
2345: JAI_CMN_TAXES_ALL jtc
2346: , jai_regime_tax_types_v tax_types
2347: WHERE line_location_id = p_line_location_id
2348: AND jtc.tax_id = llt.tax_id
2349: AND jtc.tax_type = tax_types.tax_type (+)
2350: order by tax_line_no;

Line 2402: jai_regime_tax_types_v tax_types

2398: llt.precedence_10
2399: FROM jai_cmn_document_taxes llt,
2400: jai_cmn_lines cml,
2401: JAI_CMN_TAXES_ALL jtc ,
2402: jai_regime_tax_types_v tax_types
2403: WHERE cml.po_line_location_id = p_line_location_id
2404: AND cml.cmn_line_id = llt.source_doc_line_id
2405: AND cml.shipment_number = lv_shipment_num
2406: AND llt.source_doc_type = 'ASBN'

Line 2472: jai_regime_tax_types_v tax_types,

2468: llt.precedence_9,
2469: llt.precedence_10
2470: FROM jai_cmn_document_taxes llt,
2471: JAI_CMN_TAXES_ALL jtc ,
2472: jai_regime_tax_types_v tax_types,
2473: mtl_material_transactions mtl
2474: WHERE llt.source_doc_line_id = mtl.original_transaction_temp_id
2475: AND llt.source_doc_type = 'INTERORG_XFER'
2476: AND jtc.tax_id = llt.tax_id

Line 4288: jai_regime_tax_types_v tax_types

4284: tax_types.regime_code regime_code
4285: --3848133
4286: FROM JAI_OM_WSH_LINE_TAXES stl,
4287: JAI_CMN_TAXES_ALL jtc,
4288: jai_regime_tax_types_v tax_types
4289: WHERE delivery_detail_id = v_picking_line_id --added by GSri and Jagdish on 5-may-01
4290: AND jtc.tax_id = stl.tax_id
4291: AND tax_types.tax_type(+) = jtc.tax_type
4292: )

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

4477: RTV creation should have taken care of this check
4478: Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG */
4479: FOR exc_rec IN (SELECT jrtl.tax_amount, jrtl.tax_type tax_type, nvl(mod_cr_percentage, 0) mod_cr_percentage
4480: , nvl(tax_types.regime_code, 'XXXX') regime_code
4481: FROM JAI_RCV_LINE_TAXES jrtl, JAI_CMN_TAXES_ALL jtc, jai_regime_tax_types_v tax_types
4482: WHERE shipment_line_id = p_shipment_line_id
4483: AND NVL(modvat_flag, 'N') = 'Y'
4484: AND jtc.tax_type = tax_types.tax_type(+)
4485: AND jrtl.tax_id = jtc.tax_id)