DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on PO_VENDORS

Line 275: po_vendors pv

271: pcar.party_site_id
272: FROM pos_cont_addr_requests pcar,
273: pos_contact_requests pcr,
274: pos_supplier_mappings psm,
275: po_vendors pv
276: WHERE pcar.contact_req_id = p_contact_request_id
277: AND pcar.request_status = 'PENDING'
278: AND pcar.party_site_id IS NOT NULL
279: AND pcar.mapping_id = psm.mapping_id

Line 339: po_vendors pv

335: (SELECT pcar.cont_addr_request_id
336: FROM pos_cont_addr_requests pcar,
337: pos_contact_requests pcr,
338: pos_supplier_mappings psm,
339: po_vendors pv
340: WHERE pcar.contact_req_id = p_contact_request_id
341: AND pcar.request_status = 'PENDING'
342: AND pcar.mapping_id = psm.mapping_id
343: AND psm.vendor_id = pv.vendor_id