APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on RCV_TRANSACTIONS

Line 1162: FROM rcv_transactions

1158: WHERE c.tax_line_no > nvl(v_tax_line_no,0)
1159: AND a.tax_id = b.tax_id
1160: AND c.tax_id = b.tax_id
1161: AND (c.shipment_line_id,a.line_location_id) = (SELECT shipment_line_id,po_line_location_id
1162: FROM rcv_transactions
1163: WHERE transaction_id = (select receipt_ref
1164: from JAI_CMN_RG_23D_TRXS
1165: where register_id = p_receipt_id))
1166: ORDER BY c.tax_line_no;

Line 1690: FROM rcv_transactions

1686: AND b.tax_type = p_Cess_type_code ;/*Bug 5989740 bduvarag*/
1687:
1688: CURSOR c_get_shp_line_id(cp_transaction_id IN NUMBER) IS
1689: SELECT shipment_line_id
1690: FROM rcv_transactions
1691: WHERE transaction_id = cp_transaction_id;
1692:
1693:
1694: CURSOR c_ed_cess_tax_check(cp_shipment_line_id IN NUMBER) IS