APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on RCV_TRANSACTIONS

Line 54: FROM rcv_transactions

50: WHERE set_of_books_id = c_sob;
51:
52: CURSOR fetch_rcv_record(v_rcv_trans_id NUMBER) IS
53: SELECT po_header_id,po_line_id
54: FROM rcv_transactions
55: WHERE transaction_id = v_rcv_trans_id;
56:
57: CURSOR fetch_tax_distribution(v_po_header_id NUMBER, v_po_line_id NUMBER, v_invoice_id NUMBER) IS
58: SELECT COUNT(*)

Line 130: FROM rcv_shipment_headers rsh, rcv_transactions rt

126: AND NVL(org_id, 0) = NVL(v_org_id, 0);
127:
128: CURSOR count_receipts(p_pck_slip VARCHAR2, ven_id NUMBER, cpv_transaction_type VARCHAR2 ) IS
129: SELECT DISTINCT rsh.receipt_num, rsh.shipment_header_id
130: FROM rcv_shipment_headers rsh, rcv_transactions rt
131: WHERE rsh.shipment_header_id = rt.shipment_header_id
132: AND rsh.packing_slip = p_pck_slip
133: AND rsh.vendor_id = ven_id
134: AND rt.transaction_type = cpv_transaction_type;