DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 1532: jai_regime_tax_types_v aa

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
1534: AND d.transaction_temp_id = p_transaction_temp_id
1535: AND a.source_doc_type = 'INTERORG_XFER'
1536: AND A.Tax_Id = B.Tax_Id

Line 4872: from jai_regime_tax_types_v

4868: jai_rcv_lines c
4869: WHERE a.shipment_line_id =c.shipment_line_id
4870: AND a.shipment_line_id = cp_shipment_line_id
4871: AND a.tax_type IN ( select tax_type
4872: from jai_regime_tax_types_v
4873: where regime_code = jai_constants.vat_regime
4874: )
4875: AND a.tax_id = b.tax_id
4876: AND a.modvat_flag = 'Y'