APPS.POA_EDW_SPEND_PKG dependencies on PO_APPROVED_SUPPLIER_LIST

Line 390: po_approved_supplier_list pasl

386: po_lines_all pol,
387: po_headers_all poh,
388: po_asl_status_rules pasr,
389: po_asl_statuses pas,
390: po_approved_supplier_list pasl
391: WHERE pod.po_header_id = poh.po_header_id
392: and pod.po_line_id = pol.po_line_id
393: and pod.line_location_id = pll.line_location_id
394: and poh.vendor_id = pasl.vendor_id

Line 406: po_approved_supplier_list pasl2

402: (SELECT 'local exists with global record'
403: FROM po_line_locations_all pll2,
404: po_lines_all pol2,
405: po_headers_all poh2,
406: po_approved_supplier_list pasl2
407: WHERE pll2.ship_to_organization_id =
408: pasl.using_organization_id
409: and pll2.po_header_id = poh2.po_header_id
410: and pol2.po_header_id = poh2.po_header_id

Line 452: po_approved_supplier_list pasl

448: select decode(max('Y'), 'Y', 'Y', 'N')
449: into v_supp_approved
450: from po_asl_status_rules pasr,
451: po_asl_statuses pas,
452: po_approved_supplier_list pasl
453: where pasl.vendor_id = p_vendor_id
454: and (pasl.vendor_site_id is null or
455: pasl.vendor_site_id = p_vendor_site_id)
456: and pasl.using_organization_id in (-1,p_ship_to_org_id)