APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on RCV_TRANSACTIONS

Line 1221: FROM rcv_transactions

1217: WHERE c.tax_line_no > nvl(v_tax_line_no,0)
1218: AND a.tax_id = b.tax_id
1219: AND c.tax_id = b.tax_id
1220: AND (c.shipment_line_id,a.line_location_id) = (SELECT shipment_line_id,po_line_location_id
1221: FROM rcv_transactions
1222: WHERE transaction_id = (select receipt_ref
1223: from JAI_CMN_RG_23D_TRXS
1224: where register_id = p_receipt_id))
1225: ORDER BY c.tax_line_no;

Line 1785: FROM rcv_transactions

1781: AND b.tax_type = p_Cess_type_code ;/*Bug 5989740 bduvarag*/
1782:
1783: CURSOR c_get_shp_line_id(cp_transaction_id IN NUMBER) IS
1784: SELECT shipment_line_id
1785: FROM rcv_transactions
1786: WHERE transaction_id = cp_transaction_id;
1787:
1788:
1789: CURSOR c_ed_cess_tax_check(cp_shipment_line_id IN NUMBER) IS