DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on PO_VENDORS

Line 4767: x_vendor_name PO_VENDORS.VENDOR_NAME%TYPE := NULL; --Bug# 1813740 / Bug 2823775

4763: x_need_by_date DATE := NULL;
4764: x_item_revision VARCHAR2(3) := '';
4765: x_currency_code VARCHAR2(15) := '';
4766: x_vendor_id NUMBER := NULL;
4767: x_vendor_name PO_VENDORS.VENDOR_NAME%TYPE := NULL; --Bug# 1813740 / Bug 2823775
4768: x_vendor_site_id NUMBER := NULL;
4769: x_vendor_contact_id NUMBER := NULL;
4770: x_source_organization_id NUMBER := NULL;
4771: x_source_subinventory VARCHAR2(10) := '';

Line 5929: po_vendors pov

5925: pasl.vendor_site_id,
5926: pasl.asl_id
5927: FROM po_approved_supplier_list pasl,
5928: po_asl_status_rules pasr,
5929: po_vendors pov
5930: WHERE pasl.category_id = p_category_id
5931: AND pasl.item_id IS NULL -- as part of Bug# 3379053: For commodity based ASL's,
5932: -- the item MUST be NULL
5933: -- Bug# 3379053: Use destination inv org instead of the default inv org of the ROU.