APPS.PO_CHG_REQUEST_GRP dependencies on PO_VENDOR_SITES_ALL

Line 244: FROM po_vendor_sites_all

240: mutiple records fetch.*/
241:
242: SELECT org_id
243: into l_org_id
244: FROM po_vendor_sites_all
245: WHERE vendor_id = p_tp_id
246: AND vendor_site_id = p_tp_site_id;
247:
248: select po_header_id, VENDOR_ORDER_NUM

Line 285: FROM po_vendor_sites_all

281: mutiple records fetch.*/
282:
283: SELECT org_id
284: into l_org_id
285: FROM po_vendor_sites_all
286: WHERE vendor_id = p_tp_id
287: AND vendor_site_id = p_tp_site_id;
288:
289: select po_header_id into l_po_header_id

Line 446: FROM po_vendor_sites_all

442: mutiple records fetch.*/
443:
444: SELECT org_id
445: into l_org_id
446: FROM po_vendor_sites_all
447: WHERE vendor_id = p_tp_id
448: AND vendor_site_id = p_tp_site_id;
449:
450: select

Line 822: FROM po_vendor_sites_all

818: mutiple records fetch.*/
819:
820: SELECT org_id
821: into l_org_id
822: FROM po_vendor_sites_all
823: WHERE vendor_id = p_tp_id
824: AND vendor_site_id = p_tp_site_id;
825: select
826: PLLA.po_release_id, PLLA.LINE_LOCATION_ID,

Line 905: FROM po_vendor_sites_all

901: mutiple records fetch.*/
902:
903: SELECT org_id
904: into l_org_id
905: FROM po_vendor_sites_all
906: WHERE vendor_id = p_tp_id
907: AND vendor_site_id = p_tp_site_id;
908:
909: select

Line 1493: FROM po_vendor_sites_all

1489: mutiple records fetch.*/
1490:
1491: SELECT org_id
1492: into l_org_id
1493: FROM po_vendor_sites_all
1494: WHERE vendor_id = p_tp_id
1495: AND vendor_site_id = p_tp_site_id;
1496:
1497: -- Bug 7287009 - End

Line 2079: FROM po_vendor_sites_all

2075: mutiple records fetch.*/
2076:
2077: SELECT org_id
2078: into l_org_id
2079: FROM po_vendor_sites_all
2080: WHERE vendor_id = p_tp_id
2081: AND vendor_site_id = p_tp_site_id;
2082:
2083: select to_char(po_header_id), to_char(agent_id), LAST_UPDATE_DATE