APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 322: jai_cmn_document_taxes rtl,

318: nvl(rtl.modvat_flag, 'N') modvat_flag,
319: nvl(rtl.currency_code, 'INR') currency,
320: nvl(jtc.mod_cr_percentage, 0) mod_cr_percentage
321: FROM
322: jai_cmn_document_taxes rtl,
323: jai_cmn_taxes_all jtc
324: WHERE
325: source_doc_line_id = p_source_line_id
326: AND jtc.tax_id = rtl.tax_id

Line 489: FROM jai_cmn_document_taxes tax,

485: SUM(decode(tax_type, 'Addl. Excise', round(tax_amt), 0)) additional_ed,
486: SUM(decode(tax_type, 'Other Excise', round(tax_amt), 0)) other_ed,
487: SUM(decode(tax_type, jai_constants.tax_type_exc_edu_cess, round(tax_amt), 0)) other_cess,
488: 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
489: FROM jai_cmn_document_taxes tax,
490: jai_mtl_trxs trx
491: WHERE tax.source_doc_line_id = trx.transaction_temp_id
492: AND trx.transaction_header_id = tax.source_doc_id
493: AND trx.transaction_temp_id = trx_temp_id;

Line 498: FROM jai_cmn_document_taxes

494:
495: CURSOR c_excise_tax_rate(cp_temp_id number)
496: IS
497: SELECT NVL(sum(tax_rate),0) , count(1)
498: FROM jai_cmn_document_taxes
499: WHERE source_doc_line_id = cp_temp_id
500: AND TAX_TYPE in ('Addl. Excise','Excise','Other Excise');
501:
502: cursor c_rcpts_match (cp_temp_id IN NUMBER) IS

Line 978: from jai_cmn_document_taxes

974: jrtr.location_id=p_location_id;
975: CURSOR get_tax_id(cp_transaction_header_id in number,cp_transaction_temp_id in number)
976: IS
977: select tax_id
978: from jai_cmn_document_taxes
979: where source_doc_id=cp_transaction_header_id
980: and source_doc_line_id=cp_transaction_temp_id
981: and source_doc_type='INTERORG_XFER';
982: ---END----

Line 995: jai_cmn_document_taxes jcdt,

991: --jmt.creation_date,
992: sum(jcdt.tax_amt) tax_amt
993: FROM
994: jai_mtl_trxs jmt,
995: jai_cmn_document_taxes jcdt,
996: jai_cmn_taxes_all jtc,
997: jai_rgm_registrations jrg,
998: jai_rgm_definitions jrr
999: WHERE

Line 1529: FROM Jai_cmn_document_Taxes A,

1525: d.to_organization ,
1526: d.to_subinventory ,
1527: d.location_id,
1528: d.inventory_item_id
1529: FROM Jai_cmn_document_Taxes A,
1530: jai_cmn_taxes_all B,
1531: jai_mtl_trxs D,
1532: jai_regime_tax_types_v aa
1533: WHERE source_doc_line_id = p_transaction_temp_id

Line 5305: DELETE jai_cmn_document_taxes

5301: AND transaction_temp_id = nvl(p_transaction_temp_id, transaction_temp_id )
5302: AND transaction_commit_date is null
5303: );
5304:
5305: DELETE jai_cmn_document_taxes
5306: WHERE source_doc_type = 'INTERORG_XFER'
5307: and source_table_name = 'MTL_MATERIAL_TRANSACTIONS_TEMP'
5308: AND source_doc_line_id IN
5309: (

Line 5440: UPDATE jai_cmn_document_taxes

5436: IF r_jai_mtl_trxs.inventory_item_id = p_inventory_item_id AND
5437: r_jai_mtl_trxs.transaction_uom = p_uom_code AND
5438: r_jai_mtl_trxs.to_subinventory = p_transfer_subinventory THEN
5439:
5440: UPDATE jai_cmn_document_taxes
5441: SET tax_amt = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * tax_amt,
5442: FUNC_TAX_AMT = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * func_tax_amt,
5443: last_update_date = sysdate,
5444: last_updated_by = ln_user_id