DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on PO_VENDOR_SITES_ALL

Line 782: FROM po_vendor_sites_all vendor_site

778: SELECT p_key,
779: l_subscript_array(i),
780: min(vendor_site.vendor_site_id),
781: vendor_site.vendor_id
782: FROM po_vendor_sites_all vendor_site
783: WHERE p_headers_rec.vendor_id(i) IS NOT NULL
784: AND p_headers_rec.vendor_site_id(i) IS NULL
785: --AND p_headers_rec.has_errors(i) = 'N'
786: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create

Line 929: FROM po_vendor_sites_all vendor_site

925: vendor_site.invoice_currency_code,
926: vendor_site.terms_id,
927: vendor_site.pay_on_code,
928: vendor_site.shipping_control -- (not present in 11.5.9)
929: FROM po_vendor_sites_all vendor_site
930: WHERE p_headers_rec.vendor_id(i) IS NOT NULL
931: AND p_headers_rec.vendor_site_id(i) IS NOT NULL
932: --AND p_headers_rec.has_errors(i) = 'N'
933: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create