APPS.WIP_OSP_SHP_I_WF dependencies on PO_VENDOR_SITES_ALL

Line 555: po_vendor_sites_all pvs,

551: from po_headers_all ph,
552: po_lines_all pl,
553: po_distributions_all pd,
554: po_vendors pv,
555: po_vendor_sites_all pvs,
556: wip_operation_resources wor,
557: wip_operations wo,
558: mtl_system_items msi
559: where pd.wip_entity_id = l_wip_entity_id

Line 618: po_vendor_sites_all pvs,

614: po_lines_all pl,
615: po_line_locations_all ps,
616: po_distributions_all pd,
617: po_vendors pv,
618: po_vendor_sites_all pvs,
619: wip_operation_resources wor,
620: wip_operations wo,
621: mtl_system_items msi
622: where ph.type_lookup_code = 'BLANKET'

Line 1085: po_vendor_sites_all pvs

1081: pvs.address_line4, pvs.city,pvs.county,pvs.state,
1082: pvs.province,pvs.zip,null)
1083: into l_address
1084: from po_headers_all ph,
1085: po_vendor_sites_all pvs
1086: where ph.po_header_id = l_po_header_id
1087: and pvs.org_id = ph.org_id
1088: and pvs.vendor_site_id = ph.vendor_site_id;
1089:

Line 1174: po_vendor_sites_all pvs,

1170: pvs.vendor_site_code subcontractor_site,
1171: ps.ship_to_location_id ship_to_location_id,
1172: pr.release_num
1173: from po_releases_all pr,
1174: po_vendor_sites_all pvs,
1175: po_vendors pv,
1176: po_headers_all ph,
1177: po_lines_all pl,
1178: po_line_locations_all ps,

Line 1436: po_vendor_sites_all pvs,

1432: cursor GetShipToData (l_po_distribution_id NUMBER) is
1433: select pv.vendor_name,
1434: pvs.vendor_site_code
1435: from po_vendors pv,
1436: po_vendor_sites_all pvs,
1437: po_distributions_all pd,
1438: po_location_associations pla,
1439: po_line_locations_all ps
1440: where pd.po_distribution_id = l_po_distribution_id