APPS.FV_GTAS_GL_PKG dependencies on RCV_TRANSACTIONS

Line 1693: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;

1689:
1690: l_module_name VARCHAR2(200) := g_module_name||'GET_PARTY_INFO_R12';
1691: i INTEGER := 1;
1692: --l_be_trx_id NUMBER;
1693: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
1694:
1695: BEGIN
1696: log(l_module_name, 'Begin');
1697:

Line 1944: FROM --rcv_transactions rt,

1940: P_party_info_tab(i).agency_id ,
1941: P_party_info_tab(i).party_line_amount,
1942: l_rcv_transaction_id
1943: --,P_party_info_tab(i).doc_num
1944: FROM --rcv_transactions rt,
1945: --rcv_shipment_headers rcv,
1946: ap_suppliers aps
1947: WHERE aps.vendor_id = cst_rec.vendor_id;
1948: --rt.shipment_header_id = rcv.shipment_header_Id

Line 1960: FROM rcv_shipment_headers h, rcv_transactions t

1956: ELSE
1957:
1958: SELECT h.receipt_num
1959: INTO p_party_info_tab(i).doc_num
1960: FROM rcv_shipment_headers h, rcv_transactions t
1961: WHERE t.transaction_id = l_rcv_transaction_id
1962: AND h.shipment_header_id = t.shipment_header_id;
1963: END IF;
1964:

Line 2089: FROM rcv_transactions rt,

2085: p_party_info_tab(i).party_name,
2086: p_party_info_tab(i).fed_nonfed_code ,
2087: p_party_info_tab(i).agency_id,
2088: p_party_info_tab(i).doc_num
2089: FROM rcv_transactions rt,
2090: ap_suppliers v ,
2091: po_headers_all ph
2092: WHERE rt.po_header_id = to_number(p_reference2)
2093: AND rt.transaction_id = to_number(p_reference5)