APPS.INV_CONSIGN_UTIL SQL Statements

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

Line: 13

    	  SELECT   pasl.asl_id
    	  FROM     po_approved_supplier_lis_val_v pasl,
		   po_asl_attributes paa,
                   po_asl_status_rules_v pasr
    	  WHERE    pasl.item_id = p_item_id
    	  AND	   pasl.vendor_id = p_vendor_id
    	  AND	   nvl(pasl.vendor_site_id, -1) = nvl(p_vendor_site_id, -1)
    	  AND	   pasl.using_organization_id IN (-1, p_using_organization_id)
	  AND	   pasl.asl_id = paa.asl_id
          AND      pasr.business_rule like '2_SOURCING'
          AND      pasr.allow_action_flag like 'Y'
          AND      pasr.status_id = pasl.asl_status_id
	  AND	   paa.using_organization_id =
			(SELECT  max(paa2.using_organization_id)
			 FROM	 po_asl_attributes paa2
			 WHERE   paa2.asl_id = pasl.asl_id
                         AND     paa2.using_organization_id IN (-1, p_using_organization_id))
	  ORDER BY pasl.using_organization_id DESC;