DBA Data[Home] [Help]

APPS.POS_SUPP_CUSTOM dependencies on PO_VENDOR_SITES_ALL

Line 122: PO_VENDOR_SITES_all a

118:
119: cursor existing_contact_by_vendor is
120: select count(*)
121: from PO_VENDOR_CONTACTS b,
122: PO_VENDOR_SITES_all a
123: where a.VENDOR_ID = p_supplier_id
124: and a.VENDOR_SITE_ID = b.VENDOR_SITE_ID
125: and upper(last_name) = upper(p_last_name);
126:

Line 159: PO_VENDOR_SITES_all a

155:
156: select vendor_contact_id
157: into l_contact_id
158: from PO_VENDOR_CONTACTS b,
159: PO_VENDOR_SITES_all a
160: where a.VENDOR_ID = p_supplier_id
161: and a.VENDOR_SITE_ID = b.VENDOR_SITE_ID
162: and upper(last_name) = upper(p_last_name);
163: /*