APPS.INV_PO_ITEMVALID_MDTR SQL Statements

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

Line: 116

  SELECT 'Y'
    INTO l_vmiorconsign_flag
    FROM po_approved_supplier_list pasl,
         po_asl_attributes paa,
	 po_asl_status_rules pasr
    WHERE pasl.item_id = p_item_id
	AND pasl.using_organization_id IN (-1,p_organization_id)
	AND pasl.asl_id = paa.asl_id
	AND pasr.business_rule = '2_SOURCING'
	AND pasr.allow_action_flag = 'Y'
	AND pasr.status_id = pasl.asl_status_id
	AND (disable_flag IS NULL OR disable_flag = 'N')
	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_organization_id))
	AND (paa.consigned_from_supplier_flag='Y' OR paa.enable_vmi_flag='Y')
	AND rownum=1;

Line: 249

  SELECT 'Y'
    INTO l_consign_flag
    FROM po_approved_supplier_list pasl,
         po_asl_attributes paa,
	 po_asl_status_rules pasr
    WHERE pasl.item_id = p_item_id
	AND pasl.using_organization_id IN (-1,p_organization_id)
	AND pasl.asl_id = paa.asl_id
	AND pasr.business_rule = '2_SOURCING'
	AND pasr.allow_action_flag = 'Y'
	AND pasr.status_id = pasl.asl_status_id
	AND (disable_flag IS NULL OR disable_flag = 'N')
	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_organization_id))
	AND paa.consigned_from_supplier_flag='Y'
	AND rownum=1;