DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 1404: jai_regime_tax_types_v aa

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
1406: AND d.transaction_temp_id = p_transaction_temp_id
1407: AND a.source_doc_type = 'INTERORG_XFER'
1408: AND A.Tax_Id = B.Tax_Id

Line 4430: from jai_regime_tax_types_v

4426: jai_rcv_lines c
4427: WHERE a.shipment_line_id =c.shipment_line_id
4428: AND a.shipment_line_id = cp_shipment_line_id
4429: AND a.tax_type IN ( select tax_type
4430: from jai_regime_tax_types_v
4431: where regime_code = jai_constants.vat_regime
4432: )
4433: AND a.tax_id = b.tax_id
4434: AND a.modvat_flag = 'Y'