DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on PO_VENDORS

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

4725: x_need_by_date DATE := NULL;
4726: x_item_revision VARCHAR2(3) := '';
4727: x_currency_code VARCHAR2(15) := '';
4728: x_vendor_id NUMBER := NULL;
4729: x_vendor_name PO_VENDORS.VENDOR_NAME%TYPE := NULL; --Bug# 1813740 / Bug 2823775
4730: x_vendor_site_id NUMBER := NULL;
4731: x_vendor_contact_id NUMBER := NULL;
4732: x_source_organization_id NUMBER := NULL;
4733: x_source_subinventory VARCHAR2(10) := '';

Line 5852: po_vendors pov

5848: pasl.vendor_site_id,
5849: pasl.asl_id
5850: FROM po_approved_supplier_list pasl,
5851: po_asl_status_rules pasr,
5852: po_vendors pov
5853: WHERE pasl.category_id = p_category_id
5854: AND pasl.item_id IS NULL -- as part of Bug# 3379053: For commodity based ASL's,
5855: -- the item MUST be NULL
5856: -- Bug# 3379053: Use destination inv org instead of the default inv org of the ROU.