APPS.FV_GTAS_GL_PKG dependencies on AP_SUPPLIERS

Line 1721: FROM ap_suppliers v

1717: p_party_info_tab(i).fed_nonfed_code ,
1718: P_party_info_tab(i).agency_id ,
1719: P_party_info_tab(i).party_line_amount,
1720: P_party_info_tab(i).doc_num
1721: FROM ap_suppliers v
1722: WHERE v.vendor_id = other_source_rec.party_id;
1723: EXCEPTION
1724: WHEN NO_DATA_FOUND THEN
1725: log(l_module_name,'No data found in ap_suppliers for vendor_id: '|| other_source_rec.party_id);

Line 1725: log(l_module_name,'No data found in ap_suppliers for vendor_id: '|| other_source_rec.party_id);

1721: FROM ap_suppliers v
1722: WHERE v.vendor_id = other_source_rec.party_id;
1723: EXCEPTION
1724: WHEN NO_DATA_FOUND THEN
1725: log(l_module_name,'No data found in ap_suppliers for vendor_id: '|| other_source_rec.party_id);
1726: p_party_info_tab(i).party_id := other_source_rec.party_id;
1727: p_party_info_tab(i).party_type := 'S';
1728: p_party_info_tab(i).party_name := 'Other';
1729: P_party_info_tab(i).party_line_amount := other_source_rec.amount;

Line 1946: ap_suppliers aps

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
1949: --AND rt.transaction_id = cst_rec.rcv_transaction_id;
1950: --IF transaction id = 0, it is an accrual and

Line 1997: ap_suppliers v

1993: p_party_info_tab(i).agency_id,
1994: p_party_info_tab(i).party_line_amount,
1995: p_party_info_tab(i).doc_num
1996: FROM ap_checks_all apc,
1997: ap_suppliers v
1998: WHERE apc.vendor_id = v.vendor_id
1999: AND apc.check_id = trs_confirm_rec.check_id;
2000: EXCEPTION WHEN NO_DATA_FOUND THEN
2001: log(l_module_name, 'Party info not found for Treas Conf');

Line 2039: l_vendor_id ap_suppliers.vendor_id%TYPE;

2035:
2036: l_module_name VARCHAR2(200) := g_module_name||'GET_11I_PARTY_INFO';
2037: l_select VARCHAR2(250);
2038: l_col_name all_tab_columns.column_name%TYPE;
2039: l_vendor_id ap_suppliers.vendor_id%TYPE;
2040: i INTEGER := 1;
2041: l_temp_reference_2 gl_je_lines.reference_2%TYPE;
2042:
2043: CURSOR projects_vendor_cur (p_ref1 IN VARCHAR2) IS

Line 2073: ap_suppliers v

2069: p_party_info_tab(i).fed_nonfed_code ,
2070: p_party_info_tab(i).agency_id,
2071: p_party_info_tab(i).doc_num
2072: FROM ap_invoices_all i,
2073: ap_suppliers v
2074: WHERE i.invoice_id = to_number(p_reference2)
2075: AND i.vendor_id = v.vendor_id;
2076:
2077: ELSIF (p_je_source = 'Purchasing' AND

Line 2090: ap_suppliers v ,

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)
2094: AND rt.po_header_id = ph.po_header_id

Line 2109: FROM ap_suppliers v,

2105: p_party_info_tab(i).party_name,
2106: p_party_info_tab(i).fed_nonfed_code ,
2107: p_party_info_tab(i).agency_id,
2108: p_party_info_tab(i).doc_num
2109: FROM ap_suppliers v,
2110: po_headers_all poh
2111: WHERE poh.po_header_id = to_number(p_reference2)
2112: AND v.vendor_id = poh.vendor_id;
2113:

Line 2190: ap_suppliers v

2186: p_party_info_tab(i).fed_nonfed_code ,
2187: p_party_info_tab(i).agency_id,
2188: p_party_info_tab(i).doc_num
2189: FROM ap_checks_all apc,
2190: ap_suppliers v
2191: WHERE apc.vendor_id = v.vendor_id
2192: AND apc.check_id = to_number(p_reference3);
2193: END IF;
2194: fv_utility.log_mesg('End: '||l_module_name);