DBA Data[Home] [Help]

APPS.JAI_RCV_TAX_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 426: from mtl_material_transactions

422: r_rec_ship_txn c_rec_ship_txn%rowtype;
423:
424: cursor c_get_inv_trx_info(Cp_transaction_id IN NUMBER) IS
425: select abs(transaction_quantity) , transaction_uom , original_transaction_temp_id , prior_cost
426: from mtl_material_transactions
427: where transaction_id = cp_transaction_id ;
428:
429: cursor c_jai_mtl_Trxs(cp_trx_temp_id NUMBER) IS
430: select *

Line 2219: mtl_material_transactions mtl

2215: llt.precedence_10
2216: FROM jai_cmn_document_taxes llt,
2217: JAI_CMN_TAXES_ALL jtc ,
2218: jai_regime_tax_types_v tax_types,
2219: mtl_material_transactions mtl
2220: WHERE llt.source_doc_line_id = mtl.original_transaction_temp_id
2221: AND llt.source_doc_type = 'INTERORG_XFER'
2222: AND jtc.tax_id = llt.tax_id
2223: AND mtl.transaction_id = r_rec_ship_txn.MMT_TRANSACTION_ID