DBA Data[Home] [Help]

APPS.POS_ASN_SEARCH_PKG dependencies on PO_VENDOR_SITES

Line 200: PO_VENDOR_SITES vs,

196: l_supplier_site,
197: l_ship_to_loc_id,
198: l_ship_to_location
199: from POS_ASN_SHOP_CART_HEADERS ct,
200: PO_VENDOR_SITES vs,
201: HR_LOCATIONS hrl
202: where ct.session_id = l_session_id
203: and ct.vendor_site_id = vs.vendor_site_id
204: and ct.SHIP_TO_LOCATION_ID = hrl.LOCATION_ID;

Line 216: PO_VENDOR_SITES vs

212: vs.VENDOR_SITE_CODE
213: into l_supplier_site_id,
214: l_supplier_site
215: from AK_WEB_USER_SEC_ATTR_VALUES ak,
216: PO_VENDOR_SITES vs
217: where ATTRIBUTE_CODE = 'ICX_SUPPLIER_SITE_ID'
218: and ak.NUMBER_VALUE = vs.VENDOR_SITE_ID
219: and WEB_USER_ID = l_user_id
220: and exists (select 1

Line 918: from po_vendor_sites vs,

914:
915: /*
916: select vs.vendor_id
917: into l_supplier_id
918: from po_vendor_sites vs,
919: po_vendor_contacts vc,
920: fnd_user fu
921: where fu.user_id = p_user_id
922: and fu.supplier_id = vc.vendor_contact_id