APPS.INV_VIEW_MTL_TXN dependencies on PO_VENDOR_SITES_ALL

Line 146: FROM po_vendor_sites_all povs, po_vendors POV

142: IF (p_owning_tp_type=1) THEN
143: BEGIN
144: SELECT (pov.vendor_name||'-'||povs.vendor_site_code)
145: INTO x_owning_organization_name
146: FROM po_vendor_sites_all povs, po_vendors POV
147: WHERE povs.vendor_site_id = p_owning_organization_id
148: AND povs.vendor_id = pov.vendor_id;
149: EXCEPTION
150: WHEN OTHERS THEN

Line 178: FROM po_vendor_sites_all povs, po_vendors POV

174: IF (p_transfer_owning_tp_type=1) THEN
175: BEGIN
176: SELECT (pov.vendor_name||'-'||povs.vendor_site_code)
177: INTO x_xfr_owning_organization_name
178: FROM po_vendor_sites_all povs, po_vendors POV
179: WHERE povs.vendor_site_id = p_xfr_owning_organization_id
180: AND povs.vendor_id = pov.vendor_id;
181: EXCEPTION
182: WHEN OTHERS THEN

Line 206: FROM po_vendor_sites_all povs, po_vendors POV

202: IF (p_planning_tp_type=1) THEN
203: BEGIN
204: SELECT (pov.vendor_name||'-'||povs.vendor_site_code),pov.vendor_name
205: INTO x_supplier_site_name, x_supplier
206: FROM po_vendor_sites_all povs, po_vendors POV
207: WHERE povs.vendor_site_id = p_planning_organization_id
208: AND povs.vendor_id = pov.vendor_id;
209:
210: EXCEPTION