APPS.WIP_OSP_SHP_I_WF dependencies on PO_VENDOR_SITES_ALL

Line 598: po_vendor_sites_all pvs,

594: from po_headers_all ph,
595: po_lines_all pl,
596: po_distributions_all pd,
597: po_vendors pv,
598: po_vendor_sites_all pvs,
599: wip_operation_resources wor,
600: wip_operations wo,
601: mtl_system_items msi
602: where pd.wip_entity_id = l_wip_entity_id

Line 661: po_vendor_sites_all pvs,

657: po_lines_all pl,
658: po_line_locations_all ps,
659: po_distributions_all pd,
660: po_vendors pv,
661: po_vendor_sites_all pvs,
662: wip_operation_resources wor,
663: wip_operations wo,
664: mtl_system_items msi
665: where ph.type_lookup_code = 'BLANKET'

Line 1128: po_vendor_sites_all pvs

1124: pvs.address_line4, pvs.city,pvs.county,pvs.state,
1125: pvs.province,pvs.zip,null)
1126: into l_address
1127: from po_headers_all ph,
1128: po_vendor_sites_all pvs
1129: where ph.po_header_id = l_po_header_id
1130: and pvs.org_id = ph.org_id
1131: and pvs.vendor_site_id = ph.vendor_site_id;
1132:

Line 1217: po_vendor_sites_all pvs,

1213: pvs.vendor_site_code subcontractor_site,
1214: ps.ship_to_location_id ship_to_location_id,
1215: pr.release_num
1216: from po_releases_all pr,
1217: po_vendor_sites_all pvs,
1218: po_vendors pv,
1219: po_headers_all ph,
1220: po_lines_all pl,
1221: po_line_locations_all ps,

Line 1479: po_vendor_sites_all pvs,

1475: cursor GetShipToData (l_po_distribution_id NUMBER) is
1476: select pv.vendor_name,
1477: pvs.vendor_site_code
1478: from po_vendors pv,
1479: po_vendor_sites_all pvs,
1480: po_distributions_all pd,
1481: po_location_associations pla,
1482: po_line_locations_all ps
1483: where pd.po_distribution_id = l_po_distribution_id