APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 199: jai_cmn_document_taxes rtl,

195: nvl(rtl.modvat_flag, 'N') modvat_flag,
196: nvl(rtl.currency_code, 'INR') currency,
197: nvl(jtc.mod_cr_percentage, 0) mod_cr_percentage
198: FROM
199: jai_cmn_document_taxes rtl,
200: jai_cmn_taxes_all jtc
201: WHERE
202: source_doc_line_id = p_source_line_id
203: AND jtc.tax_id = rtl.tax_id

Line 366: FROM jai_cmn_document_taxes tax,

362: SUM(decode(tax_type, 'Addl. Excise', round(tax_amt), 0)) additional_ed,
363: SUM(decode(tax_type, 'Other Excise', round(tax_amt), 0)) other_ed,
364: SUM(decode(tax_type, jai_constants.tax_type_exc_edu_cess, round(tax_amt), 0)) other_cess,
365: sum(decode(tax_type, jai_constants.tax_type_sh_exc_edu_cess, round(tax_amt), 0)) other_sh_cess --Added higher education cess constants by vkaranam for bug#5907436
366: FROM jai_cmn_document_taxes tax,
367: jai_mtl_trxs trx
368: WHERE tax.source_doc_line_id = trx.transaction_temp_id
369: AND trx.transaction_header_id = tax.source_doc_id
370: AND trx.transaction_temp_id = trx_temp_id;

Line 375: FROM jai_cmn_document_taxes

371:
372: CURSOR c_excise_tax_rate(cp_temp_id number)
373: IS
374: SELECT NVL(sum(tax_rate),0) , count(1)
375: FROM jai_cmn_document_taxes
376: WHERE source_doc_line_id = cp_temp_id
377: AND TAX_TYPE in ('Addl. Excise','Excise','Other Excise');
378:
379: cursor c_rcpts_match (cp_temp_id IN NUMBER) IS

Line 855: from jai_cmn_document_taxes

851: jrtr.location_id=p_location_id;
852: CURSOR get_tax_id(cp_transaction_header_id in number,cp_transaction_temp_id in number)
853: IS
854: select tax_id
855: from jai_cmn_document_taxes
856: where source_doc_id=cp_transaction_header_id
857: and source_doc_line_id=cp_transaction_temp_id
858: and source_doc_type='INTERORG_XFER';
859: ---END----

Line 872: jai_cmn_document_taxes jcdt,

868: --jmt.creation_date,
869: sum(jcdt.tax_amt) tax_amt
870: FROM
871: jai_mtl_trxs jmt,
872: jai_cmn_document_taxes jcdt,
873: jai_cmn_taxes_all jtc,
874: jai_rgm_registrations jrg,
875: jai_rgm_definitions jrr
876: WHERE

Line 1401: FROM Jai_cmn_document_Taxes A,

1397: d.to_organization ,
1398: d.to_subinventory ,
1399: d.location_id,
1400: d.inventory_item_id
1401: FROM Jai_cmn_document_Taxes A,
1402: jai_cmn_taxes_all B,
1403: jai_mtl_trxs D,
1404: jai_regime_tax_types_v aa
1405: WHERE source_doc_line_id = p_transaction_temp_id

Line 4862: DELETE jai_cmn_document_taxes

4858: AND transaction_temp_id = nvl(p_transaction_temp_id, transaction_temp_id )
4859: AND transaction_commit_date is null
4860: );
4861:
4862: DELETE jai_cmn_document_taxes
4863: WHERE source_doc_type = 'INTERORG_XFER'
4864: and source_table_name = 'MTL_MATERIAL_TRANSACTIONS_TEMP'
4865: AND source_doc_line_id IN
4866: (

Line 4980: UPDATE jai_cmn_document_taxes

4976: IF r_jai_mtl_trxs.inventory_item_id = p_inventory_item_id AND
4977: r_jai_mtl_trxs.transaction_uom = p_uom_code AND
4978: r_jai_mtl_trxs.to_subinventory = p_transfer_subinventory THEN
4979:
4980: UPDATE jai_cmn_document_taxes
4981: SET tax_amt = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * tax_amt,
4982: FUNC_TAX_AMT = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * func_tax_amt,
4983: last_update_date = sysdate,
4984: last_updated_by = ln_user_id