APPS.PO_VMI_ENABLED SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 54

     SELECT 'Y' into v_temp from dual
       WHERE exists
       (SELECT 1 from
	po_asl_attributes paa,
	po_approved_supplier_list pasl,
	po_asl_status_rules pasr --bug 3648705 join to table not view
	WHERE
	paa.using_organization_id = p_organization_id
	AND pasl.asl_id = paa.asl_id
	AND (pasl.disable_flag = 'N' OR pasl.disable_flag IS NULL)
	and pasr.status_id = pasl.asl_status_id
	AND pasr.business_rule like '2_SOURCING'
	AND pasr.allow_action_flag like 'Y'
	AND paa.enable_vmi_flag =  'Y');

Line: 81

     SELECT set_of_books_id
     INTO  l_sob_id
     FROM  org_organization_definitions OOD
     WHERE  OOD.organization_id = p_organization_id;

Line: 86

	select 'Y'  INTO v_temp from dual where exists
	  (
	   select paa.asl_id
	   from
	   po_vendors pv,
	   po_vendor_sites_all pvsa,
	   po_asl_attributes paa,
	   po_approved_supplier_list  pasl,
	   po_asl_status_rules pasr --bug 3648672, join to base table instead of view
	   where
	   --Getting all organizations associated with the particular set_of_books_id
	   pv.set_of_books_id = l_sob_id -- bug 3648672

	   --Getting the vendor_id,vendor_site_id
	   AND pvsa.vendor_id = pv.vendor_id


	   --Getting to the po_approved_supplier_list using vendor_id and vendor_site_id
	   AND pvsa.vendor_id = pasl.vendor_id
	   AND pvsa.vendor_site_id = pasl.vendor_site_id
	   AND (pasl.disable_flag = 'N' OR pasl.disable_flag IS NULL)
	   and paa.asl_id = pasl.asl_id

	   --getting the global_asl_id from paa and verifying its validity
	   and paa.using_organization_id = -1
	   and pasr.status_id = pasl.asl_status_id
	   AND pasr.business_rule like '2_SOURCING'
	   AND pasr.allow_action_flag like 'Y'
	   AND paa.enable_vmi_flag =  'Y'

	     );