APPS.FV_FACTS1_GL_PKG dependencies on PO_VENDORS

Line 984: l_recipient_name po_vendors.vendor_name%type ;

980:
981: -- Variables for Dynamic Cursor
982:
983:
984: l_recipient_name po_vendors.vendor_name%type ;
985: l_elim_dept VARCHAR2(6);
986:
987: l_govt_non_govt_ind VARCHAR2(1);
988:

Line 1072: po_vendors v

1068: INTO l_vendor_id, l_vendor_type,
1069: l_elim_dept,
1070: l_recipient_name
1071: FROM ap_invoices_all i,
1072: po_vendors v
1073: WHERE i.invoice_id = to_number(p_reference_2)
1074: AND i.vendor_id = v.vendor_id;
1075:
1076: l_cust_vend_type := 'V';

Line 1138: po_vendors v,

1134: eliminations_id, v.vendor_name
1135: INTO l_vendor_id, l_vendor_type, l_elim_dept,
1136: l_recipient_name
1137: FROM rcv_transactions rt,
1138: po_vendors v,
1139: po_headers_all ph
1140: WHERE rt.po_header_id = to_number(p_reference_2)
1141: AND rt.transaction_id = to_number(p_reference_5)
1142: AND rt.po_header_id = ph.po_header_id

Line 1205: FROM po_vendors v, po_headers_all poh

1201: INTO l_vendor_id,
1202: l_vendor_type,
1203: l_elim_dept,
1204: l_recipient_name
1205: FROM po_vendors v, po_headers_all poh
1206: WHERE poh.po_header_id = to_number(p_reference_2)
1207: AND v.vendor_id = poh.vendor_id;
1208:
1209: l_cust_vend_type := 'V';

Line 1316: po_vendors v

1312: v.vendor_name
1313: INTO l_vendor_id, l_vendor_type, l_elim_dept,
1314: l_recipient_name
1315: FROM ap_checks_all apc,
1316: po_vendors v
1317: WHERE apc.vendor_id = v.vendor_id
1318: AND apc.check_id = to_number(p_reference_3);
1319:
1320: l_cust_vend_type := 'V';